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,

This entry was posted on Thursday, November 13th, 2008 at 6:14 pm and is filed under cuap - cuap. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One comment

 1 

butuh om…butuh sama yang nulis boleh??:P

November 14th, 2008 at 11:11 am

Leave a reply

Name (*)
Mail (will not be published) (*)
URI
Comment


Masukin kodenya disini :

5278712-1