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
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.
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?
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.
Reply With Quote
Originally Posted by ckiltz
Bookmarks