Skip to Content

Database Listener Start

Dear Team,

We have done the oracle upgrade from 10g to 11g in Windows server 2008. We are facing a problem while Creating the Oracle TNSListener Service.

In command promt we exicuted following command

<complete_path_to_new_Oracle_Home>\bin\lsnrctl start

the error message like

"TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error"

Why we are getting this error.

Please guide us to resolve.

Regards,

Skiruba.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 19, 2011 at 05:25 AM

    Hi,

    Check the reference link:

    http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm

    Regards,

    Srikishan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2011 at 05:49 AM

    Hi Skiruba,

    Could you provide full trace? Why you are trying to create a new listener service, manually?

    The listener TCP port might be allocated by the other application, or you are facing with a security problem on Windows 2008, as usual.

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2011 at 12:13 PM

    Hi,

    the error message like

    "TNS-12560: TNS:protocol adapter error

    TNS-00530: Protocol adapter error"

    Check the following:

    1. Environment variables ORACLE_HOME, PATH, TNS_ADMIN points to new Oracle 11g installation directory.

    After that,

    1. Copy TNSNAMES.ORA, LISTENER.ORA, SQLNET.ORA from OLD Oracle_Home to NEW Oracle_Home at same path.

    2. Edit above configuration files and make sure that ORACLE_HOME path points to Oracle 11g installation.

    Then try to start LISTENER. It will work.

    Regards.

    Rajesh Narkhede

    Add comment
    10|10000 characters needed characters exceeded