E-ORA 'ORA-12537: TNS:connection closed' when trying to boot domain (Doc ID 647368.1)

Last updated on JULY 15, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO:
PeopleTools Oracle



***Checked for relevance on 07-Jun-2013***
***Checked for relevance on 8-Dec-2014***

Symptoms

'ORA-12537: TNS:connection closed' when trying to boot domain

There are two scenarios on different platforms where this error can occur.

Scenario 1:

Unable to boot the Application Server and/or Process Scheduler on AIX platform. It gives the following error in the listener.log residing on the database server :

TNS-12518: TNS:listener could not hand off client connection
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailable

Enabling a TraceSQL=31 in the psappsrv.cfg file will reveal the error : "ORA-12537: TNS:connection closed" in the tracesql file. The error can occur at different server processes and may not necessarily fail at same server process.


Scenario 2 :

Our database server version is Oracle 10.2.0.1.0 - 64bit running on Solaris.

Not able to start either the second Application Server or second Process Scheduler on the Windows server. It gives the following error message in the sqlnet.log and aborts :


****************************************************************
Fatal NI connect error 12537, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.1.120.151)(PORT=1572))(CONNECT_DATA=(SERVICE_NAME=LEA)(CID=(PROGRAM=D:\EPM88SP2\BIN\SERVER\WINX86\PSAPPSRV.exe)(HOST=S233)(USER=jobloggs))))

VERSION INFORMATION:
TNS 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: 21-MAR-2006 19:35:06
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 507
TNS-00507: Connection closed
nt secondary err code: 0
nt OS err code: 0

***********************************************************************

In the application server log, we see the following error :


APPSRV.LOG
PSAPPSRV.4856 (0) [03/21/06 19:44:36](1) GenMessageBox(200, 0, M): SQL Access Manager: SQL error. Stmt #: 2 Error Position: 0 Return: 12537 - ORA-12537: TNS:connection closed
PSAPPSRV.4856 (0) [03/21/06 19:44:36](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database EPM88 with user VP1.
PSWATCHSRV.4584 (0) [03/21/06 19:44:37] Shutting down
PSADMIN.296 (0) [03/21/06 19:44:43](0) End boot attempt on domain EPM88

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