-
Can not start 11g listener
Hello,
I can not start the 11G Listener on a Windows 2003 Server with Oracle 10.2.0.4 installed.
In preparation to migrate Oracle from 10.2.0.4 to 11.2.0.2 I stopped and disabled the 10g listener and installed the 11g listener withe the help of the 11g "Net Configuration Assistant".
Every thin was running fine until the system reboot yesterday.
The 11g listener did not start an had the following error in its log:
TNS-12557: TNS protocol adapter not loadable
TNS-12560: TNS protocol adapter error
TNS-00527: Protocol Adapter not loadable
Do you have any suggestions?
Thank you in advance!
Chris
Last edited by ckiltz; 12-23-2011 at 09:05 AM.
-
Now I deinstalled 10G and 11G listener and tried to reinstall 11G Listener: no success :-(
=> The same error message as before.
The 11G Listener is using the Parameter File in the 10G ORACLE_HOME.
Why???
-
Make sure you have set 11g ORACLE_HOME in the environment variables. start the 11g listener from 11g ORACLE_HOME/bin. Post the error message if you see any.
Regards,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Hi,
I set the ORACLE_HOME to 11G and installed the 11G listener: SUCCESS!
But there is an Oracle 10G database running. So I deleted the ORACLE_HOME entry in the environment because I fear the 10G database has problems with 11G ORACLE_HOME.
Now the 11G Listener has the same problems again!
How do I set the ORACLE_HOME variable while migrating from 10G to 11G because I have to run the 11G listener during migration. Am I right?
Thank you very much!
-
Originally Posted by ckiltz
Hi,
I set the ORACLE_HOME to 11G and installed the 11G listener: SUCCESS!
But there is an Oracle 10G database running. So I deleted the ORACLE_HOME entry in the environment because I fear the 10G database has problems with 11G ORACLE_HOME.
Now the 11G Listener has the same problems again!
How do I set the ORACLE_HOME variable while migrating from 10G to 11G because I have to run the 11G listener during migration. Am I right?
Thank you very much!
1) Stop 11g (and 10g if up) listeners services.
2) Check the environment variables for correct oracle home in the PATH and if there is a TNS_ADMIN pointing to correct location of the listener.ora and tnsnames.ora files.
3) Check in the registry oracle-homes for TNS_ADMIN entry and point it to the correct location.
4) Disable the 10g listener in the services.
5) Start 11g listener service
Good luck!
PS: When there are multiple oracle homes on one server, some of us prefer to create a separate directory for the listener parameter files, for example: C:\Oracle\Network\Admin that will have the listener.ora, tnsnames.ora and sqlnet.ora files.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
you can keep both the homes in env variables. While connecting from command prompt, make sure you set the proper home before connecting to either database or listener.
Regards,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|