Oracle 10g Install on CetOS5.6
1 | Get Oracle 10g Installing File | |||||||
a. | Download the Complete Files | |||||||
Filename : 10201_database_linux_x86_64.cpio.gz | ||||||||
b. | Unzip the file | |||||||
$gunzip 10201_database_linux_x86_64.cpio.gz | ||||||||
c. | Extract the file | |||||||
$cpio -idmv < 10201_database_linux_x86_64.cpio | ||||||||
2 | Installation Guide | |||||||
a. | Preinstallation Tasks | |||||||
i. | Install JDK | |||||||
$vi /etc/profile JAVA_HOME=/usr/local/jdk1.6.0_24 export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH export CLASSPATH=.:/usr/local/jdk1.6.0_24/lib:/usr/local/jdk1.6.0_24/jre/lib | ||||||||
ii. | Checking the Software Requirements | |||||||
$uname -r $rpm -qa | ||||||||
iii. | Checking the Network Setup | |||||||
1 | Configuring Name Resolution | |||||||
$vi /etc/sysconfig/network HOSTNAME=myhost.ora.mycompany.com | ||||||||
$vi /etc/hosts 10.10.0.102 myhost.ora.mycompany.com myhost | ||||||||
2 | Setting the ORACLE_HOSTNAME Environment Variable | |||||||
$vi /etc/profile ORACLE_HOSTNAME=myhost.ora.mycompany.com export ORACLE_HOSTNAME | ||||||||
iv. | Creating Required Operating System Groups and Users | |||||||
1 | Need to create several operating system groups and users | |||||||
The OSDBA group : dba The OSOPER group : oper The Oracle Inventory group : oinstall The Oracle software owner user : oracle | ||||||||
2 | Creating the Oracle Inventory Group | |||||||
$/usr/sbin/groupadd oinstall $/usr/sbin/groupadd dba $/usr/sbin/groupadd oper $/usr/sbin/useradd -g oinstall -G dba,oper oracle $/usr/sbin/usermod -g oinstall -G dba,oper oracle $passwd oracle ${password} $id nobody | ||||||||
3 | Configuring Kernel Parameters | |||||||
$/sbin/sysctl -a | grep sem $/sbin/sysctl -a | grep shm $/sbin/sysctl -a | grep file-max $/sbin/sysctl -a | grep ip_local_port_range $/sbin/sysctl -a | grep rmem_default $/sbin/sysctl -a | grep rmem_max $/sbin/sysctl -a | grep wmem_default $/sbin/sysctl -a | grep wmem_max $vi /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 = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 Restart the system | ||||||||
4 | Setting Shell Limits for the oracle User | |||||||
$vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 $vi /etc/pam.d/login session required pam_limits.so $vi /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 | ||||||||
v. | Identifying Required Software Directories | |||||||
1 | Identifying or Creating an Oracle Base Directory | |||||||
a. | Identifying an Existing Oracle Base Directory | |||||||
$more /etc/oraInst.loc | ||||||||
b. | Creating an Oracle Base Directory | |||||||
$mkdir -p /ora/app/oracle $chown -R oracle:oinstall /ora/app/oracle $chmod -R 775 /ora/app/oracle $mkdir -p /ora/app/oracle/product/10.2.0 $chown -R oracle:oinstall /ora/app/oracle/product/10.2.0 $chmod -R 775 /ora/app/oracle/product/10.2.0 | ||||||||
vi. | Creating Directories for Oracle Database or Recovery Files | |||||||
1 | Creating Required Directories | |||||||
a. | Database files | |||||||
$mkdir /ora/app/oracle/product/10.2.0/oradata $chown -R oracle:oinstall /ora/app/oracle/product/10.2.0/oradata $chmod -R 775 /ora/app/oracle/product/10.2.0/oradata | ||||||||
b. | Recovery files | |||||||
$mkdir /ora/app/oracle/product/10.2.0/flash_recovery_area $chown -R oracle:oinstall /ora/app/oracle/product/10.2.0/flash_recovery_area $chmod -R 775 /ora/app/oracle/product/10.2.0/flash_recovery_area | ||||||||
vii. | Configuring the oracle User's Environment | |||||||
$mkdir -p /ora/app/oracle/tmp $chmod a+wr /ora/app/oracle/tmp $su - oracle $vi .bash_profile umask 022 TEMP=/ora/app/oracle/tmp TMPDIR=/ora/app/oracle/tmp export TEMP TMPDIR ORACLE_BASE=/ora/app/oracle ORACLE_HOME=/ora/app/oracle/product/10.2.0/db_1 ORACLE_SID=orcl export ORACLE_BASE ORACLE_HOME ORACLE_SID export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib $. ./.bash_profile $vi /etc/redhat-release redhat 4 $yum -y install libXp | ||||||||
b. | Installation Tasks | |||||||
$xhost + $xterm $su - oracle $export DISPLAY=:0.0 $./database/runInstall | ||||||||
3 | Database Administration | |||||||
a. | Tasks of a Database Administrator | |||||||
i. | Create and Open the Database | |||||||
Use the Database Configuration Assistant (DBCA) | ||||||||
$xhost + $xterm $su - oracle $cd /ora/app/oracle/product/10.2.0/db_1/bin $./dbca | ||||||||
ii. | Starting Up and Shutting Down | |||||||
Starting Up a Database | ||||||||
$su - oracle $cd /ora/app/oracle/product/10.2.0/db_1/bin $./sqlplus /nolog conn sys/orcl as sysdba startup force exit $./lsnrctl start $./emctl start dbconsole | ||||||||
Shutting Down a Database | ||||||||
$su - oracle $cd /ora/app/oracle/product/10.2.0/db_1/bin $./sqlplus /nolog conn sys/orcl as sysdba shutdown immediate exit $./lsnrctl stop $./emctl stop dbconsole | ||||||||