Oracle DBA, How To, Error, Cause and Action

Showing posts with label Oracle 11g Installation. Show all posts
Showing posts with label Oracle 11g Installation. Show all posts

Oracle 11g Installation on Enterprise Linux 32-bit (5/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5) [You are here]


17. Click Exit to end the Installation.



18. Click Yes to comfirm the end of the Installation.




Congratulation we have Oracle Database 11g Installed.


Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5) [You are here]

Oracle 11g Installation on Enterprise Linux 32-bit (4/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)


13. There are two scripts you need to run with root user.





14. You can open new workspace by clicking second box at the bottom right corner, as you can see the blue box.
Open new terminal and switch user to root to execute the scripts from step13.




15. For the 2nd scripts press enter to use default local bin directory setting.
After both scripts are completed go back to first workspace, by clicking first box at bottom right corner.


16. When you back to the fist workspace the Oracle Universal Installer.
Click Ok to continue.





Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)

Oracle 11g Installation on Enterprise Linux 32-bit (3/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)


9. Choose Basic Installation, untick Create Starter Database, we will create database using Database Configuration Assistance (DBCA), I will show you more about this later, as for now we just install Oracle Database 11g Server software..
Click Next to continue.




10. Oracle Inventory directory is a file call oraInventory it store the information of what type of Oracle product and version you are installing in the server.
Leave it as default value and click Next to continue.





11. Oracle now will check the prerequisite setting, you need to have all items with succeeded, you may have 1 warning which is DHCP is set even though you are using static IP just acknowledge the warning by tick the tick box.
Click Next to continue.





12. Click Install to continue.




Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)

Oracle 11g Installation on Enterprise Linux 32-bit (2/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)



5. Edit oracle user .bash_profile file

We need to edit .bash_profile, add following lines, this to setup the environment of our database.

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_SID=edba01; export ORACLE_SID


ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi





6. Reboot the system and login as oracle (the user that we created at step 3)

reboot <- We have change kernel configuration from step 2 we need to reboot so that it take effect

Mount Oracle Database 11g 32-bit DVD (or iso file)

If you have permission error run following command with root to fix it.

mount -o loop /dev/cdrom /media




7. as oracle user (please note that you are not able to execute runInstaller if your current working directory is the CD/DVD

cd /

./media/runInstaller





8. Oracle Universal Installer is launch, choose Oracle Database 11g, and click Next to continue.





Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Oracle 11g Installation on Enterprise Linux 32-bit (2/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5)

Oracle 11g Installation on Enterprise Linux 32-bit (1/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)


You need to have following requirement in order to install Oracle Database Server 11g on Oracle Enterprise Linux 5

- At least 1 GB RAM
- SWAP space at least twice of your RAM
- x86 CPU compatibility
- 32-bit Oracle Database Server 11g for 32-bit Oracle Enterprise Linux 5, and 64-bit Oracle Database Server 11g for 64-bit Oracle Enterprise Linux 5

If you do not have above system requirement, you will face problem in this process or at least different result.

Before we install Oracle Database Server 11g on Oracle Enterprise Linux 5 following tasks need to be perform by root user.

1. Packages required by Oracle Database Server 11g can be install using following command

Mount disk 1, and run following command

yum -y install binutils-2.*
yum -y install elfutils-libelf-0.*
yum -y install glibc-2.5*
yum -y install glibc-common-2.*
yum -y install libaio-0.*
yum -y install libgcc-4.*
yum -y install libstdc++-4.*
yum -y install make-3.*

Mount disk 2, run following command

cd /media/cdrom/Server
yum -y install elfutils-libelf-devel-0.*
yum -y install glibc-devel-2.*
yum -y install gcc-4.*
yum -y install gcc-c++-4.*
yum -y install libstdc++-devel-4.*
cd /
eject

Mount disk 3, run following command

cd /media/cdrom/Server
yum -y install compat-libstdc++-33*
yum -y install sysstat-7.*
yum -y install unixODBC*
yum -y install libaio-devel-0.*
cd /
eject


In my case, I am using the Oracle Enterprise Linux DVD, so I do not have to locate each of the packages in separate CDs or iso files.

I am using yum command which is similar with rpm

cd /media/*/Server

yum -y install binutils-2.* elfutils-libelf-0.* glibc-2.5* glibc-common-2.* libaio-0.* libgcc-4.* libstdc++-4.* make-3.* elfutils-libelf-devel-0.* glibc-devel-2.* gcc-4.* gcc-c++-4.* libstdc++-devel-4.* compat-libstdc++-33* sysstat-7.* unixODBC* libaio-devel-0.*




You need to make sure all the packages required are installed, you may run the yum command multiple times.


2. Once you installed all packages edit /etc/sysctl.conf add add (amend) following lines
You may carefully copy the setting and paste it in the configuration files.

kernel.shmmni = 4096
# following line for semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144

Edit /etc/security/limits.conf add (amend) following lines

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536


Edit /etc/pam.d/login add (amend) following lines

session required /lib/security/pam_limits.so
session required pam_limits.so




3. Now we will create Oracle user and groups (you need to key in oracle user), fun following commands

groupadd oinstall; groupadd dba; groupadd oper; groupadd asmadmin
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle <- you will need to key in new password for oracle





4. Create Oracle Home, Oracle Home is a path where Oracle Software is going to be installed.

mkdir -p /u01/app/oracle/product/11.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01




Oracle 11g Installation on Enterprise Linux 32-bit (1/5) [You are here]
Oracle 11g Installation on Enterprise Linux 32-bit (2/5)
Oracle 11g Installation on Enterprise Linux 32-bit (3/5)
Oracle 11g Installation on Enterprise Linux 32-bit (4/5)
Oracle 11g Installation on Enterprise Linux 32-bit (5/5)