My Oracle Support Banner

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

Last updated on JULY 28, 2019

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
*** Checked for relevance on 29-ul-2019 ***

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.