1 | Get Oracle 10g Installing File |
| a. | Download the Complete Files
|
|
|
| |
| b. | Unzip the file
|
|
|
| |
| c. | Extract the file
|
|
|
| |
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 |