Mohammad Nazmul Huda

Search this site
  • About Me
  • Certifications
  • Employment History
  • Publications
  • Study Resources
  • Training
  • Technical Docs
    • Oracle
      • Managing Database
      • Backup and Recovery
      • Performance Tuning
      • ASM
      • Security
      • Replication
      • Database Change
      • Data Guard
      • Cloud Control
      • LISTENER
      • Parameters
      • SQL
      • SQL Functions
      • PL/SQL
      • ORA ERROR
      • 12c Issues
      • Bugs
      • Scripts
      • Tools
      • OCM
    • Teradata
    • MySQL
    • SQL SERVER
    • Linux
    • AWS
    • Data Science
  • Other
  • Contact

LISTENER

Check for non-successful connection attempts in listener.log
How to Purge Listener Log Data

Listener Error:
ORA-12162: TNS:net service name is incorrectly specified
ORA-12505: TNS:listener does not currently known of SID given in connect descriptor
ORA-12514: TNS:listener does not currently known of service requested in connect descriptor
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DGMGRL)
TNS-12516 TNS:listener could not find instance with matching protocol stack
ORA-12516:TNS:listener could not find available handler with matching protocol stack
TNS-12519:TNS: no appropriate service handler found
ORA-12519:TNS: no appropriate service handler found 
ORA-12520:TNS:listener could not find available handler for requested type of server
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-12528: TNS:listener: all appropriate instances are blocking new connection during connection to ASM instance remotely
ORA-12154: TNS:could not resolve the connect identifier specified
TNS-12547:TNS:lost contact, Linux Error:104: Connection reset by peer
TNS-12537:TNS:connection closed, Linux Error: 29: Illegal seek

Comments

Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites