Step by step setting Oracle Environment Server On Linux (part 2)

How to setting up Oracle Server?

Shutdown Oracle Instance (Shutdown Oracle instance before applying patch)

1. su - oracle
2. sqlplus /nolog
3. connect sys as sysdba
4. Password - oracle
5. shutdown
6. exit

To unzip OPatch files (p2617419)

1. Login as root
2. cd /home/patch
3. unzip p2617419_10102_GENERIC.zip (should see OPatch folder created)

To apply p3119415 Patch File

1. su - root (Login as root to unzip files)
2. cd /home/patch
3. unzip p3119415_9204_LINUX.zip (should see 3119415 folder created)
4. su - oracle (Login as oracle to run patch)
5. cd /home/patch/3119415
6. export PATH=$PATH:/home/patch/OPatch
7. export PATH=$PATH:/sbin
8. which opatch (should see -> /home/patch/OPatch/opatch)
9. opatch apply (Please respond -> Y)
10. cd

To Apply p3238344 Patch File

1. su - root ( Login as root to unzip files)
2. cd /home/patch
3. unzip p3238244_9204_LINUX.zip (should see 3238244 folder created)
4. su - oracle (Login as oracle to run patch)
5. cd /home/patch/3238244
6. export PATH=$PATH:/home/patch/Opatch
7. export PATH=$PATH:/sbin
8. which opatch (should see -> /home/patch/OPatch/opatch)
9. opatch apply (please respond -> Y)
10. cd.

To relinked dbsnmp & start Oracle Agent

1. su - oracle
2. cd $ORACLE_HOME/network/lib
3. make -f ins_oemagent.mk install
4. agentctl start (To start oracle agent)
5. exit

Reboot the server

1. su - root
2. init 6

Start the Listener

1. su - oracle
2. sqlplus /nolog
3. connect sys as sysdba
4. Password -> oracle
5. start (to start oracle instance)
6. exit
7. lsnrctl
8. status (Check listener status)
9. start (to start listener -> should see listener uptime)
10. exit
11. End of Oracle installation

To shutdown the server : shutdown Oracle listener & instance

1. su - oracle
2. lsnrctl
3. status (to check status of listener)
4. stop
5 exit
6. sqlplus /nolog
7. connect sys as sysdba
8. shutdown
9. exit
10. init 0