error 12560 causing webservices slowdown

From: Roy M <RXMiller_at_gmail.com>
Date: 9 Mar 2006 07:46:38 -0800
Message-ID: <1141919198.125724.267590@v46g2000cwv.googlegroups.com>

NOTE: in all logs we just replaced real host names with XXXX

We are getting these errors on our web servers intermittently. When these error happen, all web servers "choke", they do not respond to ANY request, not just DB requests. The DB server itself shows almost no activity at all during that time. Usually the problem clears itself after few minutes then everything goes back to normal. We see the same errors in logs on probably 9 out of 13 webservers at least for the last time it happened.

Some clients are running client 8.1.7 on WIN2K Some are running client 9.2.0.1 on 2003, Both show the error.

DB server is 9.2.0.5 on solaris 5.9

the error always appears to be as follows, the client program is either intefo.exe or cfserver.exe (our client programs),

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\CFusion\Bin\cfserver.exe)(HOST=xxxxxx)(USER=SYSTEM))))

  VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
  Time: 01-MAR-2006 14:20:03
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 126
    nt OS err code: 0

While the error shows BEQ, the tnsnames.ora on the clients has no BEQ protocol defined. The connection to the DB server is TCP, as follows:

PRODUCTION.XXXXXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = FPROD)

    )
  )

the listener.ora on the DB server has no BEQ protocol either. Here it is:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXX)(PORT = 1521)

(QUEUESIZE=100
))

      )
    )
  )

LOGGING_LISTENER=off

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u5/app/oracle/product/9.2.0)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = FPROD.XXXXXX)
(ORACLE_HOME = /u5/app/oracle/product/9.2.0)
(SID_NAME = FPROD)

    )
    (SID_DESC =
(GLOBAL_DBNAME = FPROD1.XXXXXX)
(ORACLE_HOME = /u5/app/oracle/product/9.2.0)
(SID_NAME = FPROD1)

    )
  )

Any suggestions?

Thank you,

Roy Received on Thu Mar 09 2006 - 09:46:38 CST