ORACLE_HOME_LISTNER is Not Set Error

In: Oracle

17 Oct 2007

When you start or stop you oracle service in nix system and you get the prompt of ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener error.

Then you need to edit the “dbstart” & “dbshut” file, the should be located at $ORACLE_HOME\bin

Go through the file and fine line

ORACLE_HOME_LISTNER=$1

and change to

ORACLE_HOME_LISTNER=$ORACLE_HOME

5 Responses to ORACLE_HOME_LISTNER is Not Set Error

Avatar

MGC

April 2nd, 2008 at 7:05 am

Thankyou for this. I searched metalink, and provides offering an obscure workaround, it mentions the problem in 10.2 and now the same problem persists in 11.1 – you would have thought they could sort this out by now. So thanks again.

MGC

Avatar

Mark

February 10th, 2009 at 4:05 am

Hello,

Thanks for letting me know where to look. I used an alternate solution that others may also be interested in.

Another way to solve this is to add $ORACLE_HOME as the first and only parameter passed to dbstart and dbstop. This keeps you from needing to modify dbstart and dbshut. Don’t forget the to quote the command in your sudo call similar to this:

sudo su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart $ORA_HOME”

Mark

Avatar

Vicky Ronnen

August 29th, 2009 at 6:17 pm

And the best solution?
replace ORACLE_HOME_LISTNER=$1 with ORACLE_HOME_LISTNER=${1:-$ORACLE_HOME}

Then if dbshut/dbstart is called with an argument it’s used, otherwise it defaults to $ORACLE_HOME.

Then and only then the functionality of dbshut/dbstart regarding arguments is preserved.

Avatar

carloslnx

December 25th, 2010 at 2:55 am

thank , friend

Avatar

bumperman

October 13th, 2011 at 9:26 pm

Noticed this error a while ago make sure your $ORACLE_HOME is set in your ~/.bash_profile and if you are doing this for the first time source it

Comment Form

About this blog

This is a place I create just for fun and to write down some experience and notes for myself. So feel free to enjoy and drop any comments you have. I had been employed as Programmer, System Analysts, System Administrator, DBA and Project Manager. I will share some of my case study here as well. Enjoy!

Calendar

December 2014
M T W T F S S
« Oct    
1234567
891011121314
15161718192021
22232425262728
293031