Multi-Process Fork Program Throws ORA-12514 (Doc ID 785519.1)

Last updated on MARCH 31, 2009

Applies to:

Oracle Net Services - Version: 10.2.0.1
This problem can occur on any platform.

Symptoms

  1. When an application initiates multiple connections to database in a very short time, after several successful connections, connections start to fail with ORA-12514.
  2. Oracle Net Client trace shows the failure on initiation of the handshake

    *|[23-FEB-2009 14:43:51:515] nscon: doing connect handshake...
    [23-FEB-2009 14:43:51:515] nscon: sending NSPTCN packet|*

    Refuse packet is then received

    *|[23-FEB-2009 14:43:51:519] nsprecv: 00 67 00 00 04 00 00 00 |.g......|
    [23-FEB-2009 14:43:51:519] nsprecv: 22 00 00 5B 28 44 45 53 |"..[(DES|
    [23-FEB-2009 14:43:51:520] nsprecv: 43 52 49 50 54 49 4F 4E |CRIPTION|
    [23-FEB-2009 14:43:51:520] nsprecv: 3D 28 54 4D 50 3D 29 28 |=(TMP=)(|
    [23-FEB-2009 14:43:51:520] nsprecv: 56 53 4E 4E 55 4D 3D 31 |VSNNUM=1|
    [23-FEB-2009 14:43:51:520] nsprecv: 35 33 30 39 34 31 34 34 |53094144|
    [23-FEB-2009 14:43:51:520] nsprecv: 29 28 45 52 52 3D 31 32 |)(ERR=12|
    [23-FEB-2009 14:43:51:520] nsprecv: 35 31 34 29 28 45 52 52 |514)(ERR|
    [23-FEB-2009 14:43:51:520] nsprecv: 4F 52 5F 53 54 41 43 4B |OR_STACK|
    [23-FEB-2009 14:43:51:520] nsprecv: 3D 28 45 52 52 4F 52 3D |=(ERROR=|
    [23-FEB-2009 14:43:51:520] nsprecv: 28 43 4F 44 45 3D 31 32 |(CODE=12|
    [23-FEB-2009 14:43:51:520] nsprecv: 35 31 34 29 28 45 4D 46 |514)(EMF|
    [23-FEB-2009 14:43:51:520] nsprecv: 49 3D 34 29 29 29 29 |I=4)))) |
    [23-FEB-2009 14:43:51:520] nsprecv: normal exit
    [23-FEB-2009 14:43:51:520] nscon: got NSPTRF packet

3. There is no firewall in between the client and server

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms