Home » RDBMS Server » Server Administration » Listener 10g and 8i
Listener 10g and 8i [message #209590] Fri, 15 December 2006 13:44 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi,
i have installed 1og on a box,where i have alreaedy 8i running.And i am using 8i listener for both 8i and 1og
I can connect to 8i database,but
when i try to connec to 10g i get error "Connecting...ORA-12500: TNS:listener failed to start a dedicated server process"

by default LSNRCTL is using 8i listener.i donot knwo how to change this default settings to take 10g listener,so that i can add 8i database entry there.

Please advice
Re: Listener 10g and 8i [message #209591 is a reply to message #209590] Fri, 15 December 2006 13:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In your situation, you should actually use the 10g listener for both databases. You could just add the entries from the 8i listener.ora file to the 10g listener.ora file. When running LSNRCT, you'll have to ensure you are launching the one from the 10g home.
Re: Listener 10g and 8i [message #209595 is a reply to message #209590] Fri, 15 December 2006 14:09 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i copied 8i listener to 10g $ORACLE_HOME/network/admin .

cd to $ORACLE_HOME
issued lsnrctl
lsnrctl>stop
lsnrctl>start.

again i see only one service running.i can connec to 8i but not to 10g,gives same error "ORA-12500: TNS:listener failed to start a dedicated server process".

i think it is again using 8i listener.
Re: Listener 10g and 8i [message #209597 is a reply to message #209595] Fri, 15 December 2006 14:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Assuming you are using the default port, your 10g database should auto-register with the 10g listener. Once you issue LSNRCTL, it should tell you what version of the listener control utility you are using. To make sure, ensure all the listeners are stopped. Then set your ORACLE_HOME to the 10g home and launch the LSNRCTL again.

If you are still having problems, you can list your listener.ora file here for us to take a look at.
Re: Listener 10g and 8i [message #209598 is a reply to message #209590] Fri, 15 December 2006 14:50 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
>>Once you issue LSNRCTL, it should tell you what version of the listener control utility you are using. To make sure, ensure all the listeners are stopped
ebrian,that tip was really helpful !!!

now it works.i made all env poinging to 10g DB (using .oraenv)
and moved 8i listener to 10g location.
now it works perfectly.

thanks a lot.now i can enjoy my weekend Smile.thank you
Previous Topic: OEM agent connection to OEM grid control refused
Next Topic: Export error while run the export command
Goto Forum:
  


Current Time: Sun Dec 04 16:45:52 CST 2016

Total time taken to generate the page: 0.05684 seconds