I am vistababa!

Installing Oracle 10g on RHEL4

leave a comment »

1. Install Redhat Enterprise Linux 4, with following filesystems and packages:

a. Filesystems and Memory:

RAM 1000 MB
Swap 1000 MB
/boot 100 MB
/ 5000 MB
/u01 5000 MB

NOTE: If you have less than 1000 MB, don’t worry, you can still install oracle!

b. Packages and Softwares:

It is better we install everything, although I think we have to install only base operating system with all libraries and development tools.

2. After installation, check if libaio-0.3.102-1 package is installed, if not install it from CD#3.

3. For configuring kernel parameters, add following lines to file /etc/sysctl.conf :

kernel.shmall=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144

On Redhat systems, by specifying the values in the /etc/sysctl.conf file, they persist when you restart the system. To view the values specified for these kernel parameters, see page 8 of Oracle® Database Quick Installation Guide 10g Release 2 (10.2) for Linux x86 document.

4. Creating required operating system Groups and Users:

#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#passwd oracle

5. To increase the shell limits for the Oracle User, do th followings:

a. Add the following lines to file /etc/security/limits.conf:

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

b. Add the following lines to file /etc/pam.d/login:

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

c. Add the followinf lines to file /etc/profile:

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

6. Create the Oracle Base Directory:

# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle

7. For configuring the Oracle’s User environment add following lines to file /home/oracle/.bash_profile:

umask 022
export ORACLE_BASE=/u01/app/oracle

8. So far, we did pre-installation configurations.

9. Reboot the system.

10. Now that the system is coming up, mount the Oracle product disk and to start Oracle database installation, start Oracle Universal Installer by running the runinstaller command from the root directory of the Oracle product disk and follow the screens. You can see Oracle® Database Quick Installation Guide 10g Release 2 (10.2) for Linux x86 document, for more detailed installation information.

11. After completing Oracle installation, to define oracle user’s environment variables, add the following lines to the file /home/oracle/.bash_profile:

LD_ASSUME_KERNEL=2.4.1
ORACLE_BASE=/u01/app/oracle/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
ORACLE_SID=orcl
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
ORACLE_DOC=$ORACLE_HOME/doc
TMPDIR=/tmp
TEMP=/tmp
NLS_LANG=american_america.utf8
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
ORACLE_TERM=xterm
PATH=$PATH:/bin:/usr/bin:$ORACLE_HOME/bin:/usr/bin/X11:/usr/local/bin:/sbin: /etc/init.d:.

export LD_ASSUME_KERNEL ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_NLS33 ORACLE_DOC TMPDIR TEMP NLS_LANG LD_LIBRARY_PATH ORACLE_TERM PATH

12. Now oracle installation is successfully completed. From now on, whenever you reboot the system, you must run the following commands to bringing Oracle database up :

$lsnrctl start
$sqlplus “sys/oracle as sysdba”
SQL>startup
SQL>

References: Configuring Linux for the Installation of Oracle Database 10g

Written by vistababa

June 9, 2008 at 7:55 pm

Posted in Linux, Oracle

Leave a Reply