Amazon books

Tuesday, November 10, 2009

TNS-12560 and TNS-00583 when starting Listener

If you are trying to start the listener and are runing into the message below:

###############################################
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db11g/network/admin/list ener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dbms/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbms.f2c.com.br)(P ORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00583: Valid node checking: unable to parse configuration parameters

###############################################

Then , rename your sqlnet.ora, listener.ora and create another listener using netca or netmgr an try again.

This should solve your problem.

Best Regards,
Paulo Portugal
Posted by at

4 comments:

  1. UnknownAugust 24, 2012 at 8:37 AM

    thanks dear
    it worked

    ReplyDelete
  2. AnonymousJune 18, 2013 at 5:40 AM

    thanks dear
    it worked
    Ghulam Mujtaba Kori

    ReplyDelete
  3. S.H.E.M.E.E.M March 18, 2014 at 1:29 AM

    dear. tns started ..
    but in sql prompt coming the same error again..

    that is tns:protocol adapter error.

    please avice

    ReplyDelete
  4. UnknownFebruary 21, 2016 at 10:13 AM

    thanks so much.
    it is working for me

    ReplyDelete

Subscribe to: Post Comments (Atom)