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
Wednesday, January 9, 2013
Resolved: ORACLE_HOME_LISTNER is not set
2 Comments:
better to leave dbstart as is and just pass in the expected oracle home.
ie dbstart /path/to/your/home
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
Post a Comment