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

:confused:

Do you have any suggestions?

Thank you in advance!

Chris

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,

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!

Quote:

---

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! :D

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.

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,