Can not start 11g listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Can not start 11g listener

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97

    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 08:05 AM.

  2. #2
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    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???

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  4. #4
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    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!

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Cool

    Quote Originally Posted by ckiltz View Post
    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

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
  •  



Click Here to Expand Forum to Full Width