Wednesday, January 9, 2013

Resolved: ORACLE_HOME_LISTNER is not set

I had the above error message when I tried to run dbstart, the problem is the dbstart script.

Edit $ORACLE_HOME/bin/dbstart, and found below lines:

ORACLE_HOME_LISTNER=$1
if [ ! $ORACLE_HOME_LISTNER ] ; then
  echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
else
  LOG=$ORACLE_HOME_LISTNER/listener.log

Changed ORACLE_HOME_LISTNER=$1 to ORACLE_HOME_LISTNER=$ORACLE_HOME

Saved and exited, then ran "dbstart" successfully without errors

2 Comments:

HGClowns said...

better to leave dbstart as is and just pass in the expected oracle home.

ie dbstart /path/to/your/home

Nasser said...

Thanks a lot. useful steps
I was able to startup database and run with no issues.
Actually I was facing different issues earlier and all because listener and database are not up but in other side error messages were showing completely something different then stating the database and listener is not up.
Again thanks a lot