Re: Weird PeopleSoft PSNT (on Oracle) Database Error
- From: "Rajesh Kella" <rajesh.kella@xxxxxxxxx>
- To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx,"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2011 15:18:04 +0000
Check listener.log for the same timestamp..
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Thu, 21 Apr 2011 09:50:53
To: 'oracle-l@xxxxxxxxxxxxx'<oracle-l@xxxxxxxxxxxxx>
Reply-To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
Subject: Weird PeopleSoft PSNT (on Oracle) Database Error
For you PeopleSoft DBAs out there (and anyone else that wants to chime in),
have you ever seen this?
In one of our SCHDLR logs, we started getting the below errors and the PSNT
processes started going to NO SUCCESS (or ERROR).
1. There are 0 entries in the alert log for the database.
2. I cannot find a specific ORA- error in any of the PSNT logs.
3. The error has disappeared now and no other database processes ever
experienced a problem.
4. My "hunch" is that this is a PSNT memory error and not actually coming
from the database...
Thoughts?
PSPRCSRV.4696 (0) [04/20/11 23:05:50](0)
=====================================================================
PSPRCSRV.4696 (0) [04/20/11 23:06:05](3) Server: PSNT checking status...
PSPRCSRV.4696 (0) [04/20/11 23:06:05](3) Server action mode: Ok (looking for
requests)
PSPRCSRV.4696 (0) [04/20/11 23:06:05](3) Server: PSNT looking for work
PSPRCSRV.4696 (0) [04/20/11 23:06:05](3) Checking Process cancels...
PSPRCSRV.4696 (0) [04/20/11 23:06:05](3) Requests found in Process Request
table 1
PSPRCSRV.4696 (0) [04/20/11 23:06:06](3) Server: PSNT checking status...
PSPRCSRV.4696 (0) [04/20/11 23:06:06](3) Server action mode: Submitting
request
PSPRCSRV.4696 (0) [04/20/11 23:06:06](3) Number of New Process Request(s) To
Start: 1
PSPRCSRV.4696 (0) [04/20/11 23:06:06](1)
=================================Error===============================
PSPRCSRV.4696 (0) [04/20/11 23:06:06](1) Database error encountered
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2) Info:
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2) Section:
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2) Info:
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2) SQL Stmt: SELECT PARMLIST
,WORKINGDIR ,CMDLINE ,OUTDEST ,ORIGPARMLIST ,PRCSPARMEXTFLAG ,PRCSFILENAME FROM
PSPRCSPARMS WHERE PRCSINSTANCE = :1
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2) Explain: Insufficient memory
available
PSPRCSRV.4696 (0) [04/20/11 23:06:06](2)
=====================================================================
PSPRCSRV.4696 (0) [04/20/11 23:06:06](0)
=================================Error===============================
PSPRCSRV.4696 (0) [04/20/11 23:06:06](0) Msg Set: 65
PSPRCSRV.4696 (0) [04/20/11 23:06:06](0) Msg #: 65
PSPRCSRV.4696 (0) [04/20/11 23:06:06](0) Message: Process Scheduler Server
was unable to find 1700715 in Process Request table (65,65)
PSPRCSRV.4696 (0) [04/20/11 23:06:06](0)
=====================================================================
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
Other related posts:
