Setting Oracle Environment

How to setting Oracle Server?

• su - oracle
• vi .bash_profile

Append

#Oracle Environment
export ORACLE_BASE=/home/opt/oracle
export ORACLE_HOME=/home/opt/oracle/product/9.2.0.4
export ORACLE_SID=TMS
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
Save file

• To check status

1. ifconfig (run using root a/c - Eg. 192.168.1.1)
2. su - oracle (to check status)
3. su - root
4. xhost +192.168.1.1 (If got error-xhost:unable to open display ->proceed
   to step 4)
5. export DISPLAY=192.168.1.1:0.0
6. If got error - Connection refused, try to restart the server or run the command in X terminal
7. If successful - will show that it has been added to access list

• To apply p30006854 patch file

1. cd /home/patch
2. unzip p30006854_9204_LINUX.zip
3. cd 30006854
4. sh rhel3_pre_install.sh (Should display ->Patch successfully applied)

• To run Oracle Installer

1. Open X terminal
2. su - oracle
3. cd /home/setup/Disk1
4. ./runinstaller

• During Oracle installation

1. Welcome screen -> Click Next
2. Inventory Location -> Click Ok (should be /home/opt/oracle/orainventory)
3. UNIX Group Name -> Type “dba” -> Click Next
4. (Should prompt Oracle Universal installer asking to execute /tmp/orainstRoot.sh)
5. Open a new X terminal window
6. su - root
7. cd /tmp
8. ls
9. sh orainstRoot.sh
10. exit
11. Click Continue in the Installer window to continue
12. File Locations -> Click Next Source Path = /home/setup/Disk1/stage/products.jar

    i. Dest.Name =OUIHome
    ii. Dest. Path = /home/opt/oracle/product/9.2.0.4

13. Oracle 9i Databse -> Click Next
14. Standard Edition -> Click Next
15. General Purpose -> ClickNext
16. Global Database Name & SID = TMS -> Click Next
17. Database File Locations = /home/opt/oracle/oradata -> Click Next
18. Use default character set -> Click Next
19. Summary -> Click Install
20. Prompt to run /home/opt/oracle/product/9.2.0.4/root.sh
21. Open X terminal window
22. cd /home/opt/oracle/product/9.2.0.4
23. sh root.sh (enter full path name -> Press <Enter>)
24. Click OK in window to continue installation
25. Change Passwords SYS Password - oracle
    Confirm SYS Password - oracle
    SYSTEM Password - oracle
    Confirm SYSTEM Password - oracle
26. Press OK when Error Window prompt
27. Finish Installation
28. Close & exit the Oracle Enterprise Manager Console window