Vpire Blog
Good Team Plays Hard
ORACLE_HOME_LISTNER is Not Set Error
In: Oracle
17 Oct 2007When 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
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!
Categories
- Delicious Food (49)
- Recipes (15)
- Ebooks (1)
- Gadget News (52)
- HTC (6)
- Iphone (4)
- Leisure (48)
- Microsoft Windows (5)
- MS SQL (14)
- MySQL (17)
- Oracle (55)
- Photography (10)
- Travel (11)
- Ubuntu or Linux (77)
Archives
- April 2013
- February 2013
- December 2012
- June 2012
- May 2012
- August 2011
- July 2011
- June 2011
- October 2010
- September 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- vpire: You need other software tool like downloader to fully download the youku video. [...]
- Mikezang: Hi I am using you way to play youku video, but I have another question, how can I download video fro [...]
- Doh Ouattara: Please, type "ulimit -f unlimited" in the shell prompt before starting the database. It should solve [...]
- jinjao: thats good but i still have a problem coz i had moved a temp.dbf to a certain location before doing [...]
- Nick: I actually had to go to the console and look for this: Forms Applet version is : 60825 Ours is f [...]
Gallery
5 Responses to ORACLE_HOME_LISTNER is Not Set Error
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
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
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.
carloslnx
December 25th, 2010 at 2:55 am
thank , friend
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