Thursday, May 1, 2014

Oracle environmental variable setup (Unix)

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=rd2
export ORAENV_ASK=NO
export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/$ORACLE_HOME/bin:/$ORACLE_HOME/OPatch

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/12.1.0/grid/bin
export ORACLE_GRID=rd2
export ORAENV_ASK=NO
export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/$ORACLE_HOME/bin:/$ORACLE_HOME/OPatch

No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...