Wednesday, December 18, 2013

ORA-12637 Packet receive failed


                                                   ORA-12637 Packet Receive Failed


Issue: Sometimes when your trying to login for  oracle database  from WINDOWS client box to Linux box/Windows server box  we will face issue below issues

ORA-12637 Packet receive failed


Symptoms:
Trying to connect from a remote client or even loopback on the server to the database, results in an ORA-12637 Packet receive failed. Connection attempt is in the standard form:
sqlplus scott/tiger@ORCL


Cause:

Check to see if you have the SQLNET.AUTHENTICATION_SERVICES=(NTS) line in the sqlnet.ora file (client and/or server). If you are passing usernames and passwords that will be authenticated via the Oracle database, then you should not have NTS authentication enabled or attempted. If this parameter is set, then authentication will be retrieved from the OS and, if the database and OS are not setup for OS or External Authentication, an abnormal condition exists and errors are likely

Solution:
Remove the SQLNET.AUTHENTICATION_SERVICES=(NTS) line.
Only if an external authentication mechanism (OS authentication) is to be employed will this line be used.
Note:
- If this line is removed from the Server, then the database and listener will need to be restarted.
- If this line is removed from only the Client, then no Oracle processes need to be restarted.

5 comments:

  1. SQLNET.AUTHENTICATION_SERVICES= (NONE)

    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)同样出现上面问题,这个如何解决

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete

Share your knowledge it really improves, don't show off...