Archive for November 13th, 2008

13
Nov

Oracle Post Instalation

   Posted by: admin    in cuap - cuap

just for reminding my self .. :)

I. Oracle Post-installation Tasks
1.     add line to /home/oracle/.bash_profile (user root)

export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

2.    Edit  /etc/redhat-release (user root),
Red Hat Enterprise Linux Server release 5.2 (Tikanga)

note : if use option -IgnorePreReqs at start of installation , you shouldn’t do this.

3.    enables the oracle user to dbshut, dbstart and lsnrctl start (dengan user root)
# to orcl:/home/oracle/product/10.2.0/db_1:Y

4.    create the startup script, (dengan user oracle) gedit /home/oracle/oraclestartup.sh

lsnrctl start
emctl start dbconsole
isqlplusctl start
sqlplus sys/oracle as sysdba << EOF
startup
EOF
exit

and give it access :
chmod 755 /home/oracle/oraclestartup.sh

5.   add line to /etc/rc.local (user root)

su - oracle << EOF
/home/oracle/oraclestartup.sh
EOF
exit

6.  REBOOT. Login with oracle oracle and test the oracle :
lsnrctl status
emctl status dbconsole

from web browser :
- iSQL*Plus URL:
http://localhost:5560/isqlplus
- iSQL*Plus DBA URL:
http://localhost:5560/isqlplus/dba
- Enterprise Manager 10g Database Control URL:
http://localhost:1158/em

hope, this helpfull for anyone needed.

ceers,

5278712-1