E-PRCS: ORA-12514: TNS:listener Does Not Currently Know of Service Requested in Connect Descriptor (Doc ID 1389453.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
Doc ID is reviewed for currency on 11th November 2013
Doc ID is reviewed for currency on 15th Apr 2015

Symptoms

Process Scheduler Server logs(MSTRSCHDLR_MMDD.LOG, SCHDLR_1221.LOG)got following message and Shutting down the scheduler

On the other hand, Application Server seem to work normally.
Users can continue to access the PIA.

PSPRCSRV.9623 (0) [12/21/11 19:19:14](0) Sleeping for 300 seconds before making another connection attempt
PSPRCSRV.9623 (0) [12/21/11 19:24:14](0) Connection Attempt Counter: 11
PSPRCSRV.9623 (0) [12/21/11 19:24:14](0) Testing connectivity from the database server....
PSPRCSRV.9623 (0) [12/21/11 19:24:14](3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12514 - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
PSPRCSRV.9623 (0) [12/21/11 19:24:14](0) Attempt to reconnect failed
PSPRCSRV.9623 (0) [12/21/11 19:24:29](0) Sleeping for 300 seconds before making another connection attempt
PSPRCSRV.9623 (0) [12/21/11 19:29:29](0) Connection Attempt Counter: 12
PSPRCSRV.9623 (0) [12/21/11 19:29:29](0) Testing connectivity from the database server....
PSPRCSRV.9623 (0) [12/21/11 19:29:29](3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12514 - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
PSPRCSRV.9623 (0) [12/21/11 19:29:29](0) Attempt to reconnect failed
PSPRCSRV.9623 (0) [12/21/11 19:29:44](0) Have exceeded reconnection attempt of 12. Shutting down scheduler
PSPRCSRV.29788 (0) [12/21/11 19:29:52](0) PeopleTools Release 8.51.14 (Linux) starting. Tuxedo server is BASE(1)/101
PSPRCSRV.29788 (0) [12/21/11 19:29:52](0) Cache Directory being used: /home/oracle/psft/pt/8.51/appserv/prcs/H91T851E/CACHE/PSPRCSRV_101/
PSPRCSRV.29788 (0) [12/21/11 19:29:52](3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 12514 - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
PSPRCSRV.29788 (0) [12/21/11 19:29:52](0) Server failed to start


It seems Process Scheduler is unable to connect Database. Despite Process Scheduler seems to down, why Application Server is working normally ?

Changes


 

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