Home » RDBMS Server » Server Administration » RLM$SCHDNEGACTION
RLM$SCHDNEGACTION [message #239235] Mon, 21 May 2007 16:58 Go to next message
sweetness
Messages: 10
Registered: May 2005
Location: Pasadena
Junior Member
Lately I noticed a repeating entry in may alert_prod.log file.

I decided to look at DBA_SCHEDULER_JOBS, where I found the culprit to be RLM$SCHDNEGACTION. I went back to alert_prod.log file, looked at the slave trace file it pointed me to, and this is what it said:

*** ACTION NAME:(RLM$SCHDNEGACTION) 2007-05-21 14:45:55.073
*** MODULE NAME:(DBMS_SCHEDULER) 2007-05-21 14:45:55.073
*** SERVICE NAME:(SYS$USERS) 2007-05-21 14:45:55.073
*** SESSION ID:(26.2112) 2007-05-21 14:45:55.073
*** 2007-05-21 14:45:55.073
ORA-12012: error on auto execute of job 42580
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
error 604 in job queue process
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-12012: error on auto execute of job 42580
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process


The problem is that I don't have any other information to help me debug this problem. It just runs every hour and bombs. I could try to stop it and restart it, but I would really like to figure out what SQL it is running that is returning more than one row in case it happens again in the future.

Any suggestions?

Joe
Re: RLM$SCHDNEGACTION [message #239580 is a reply to message #239235] Tue, 22 May 2007 12:55 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI Joe

did you got any trace file generated?
If yes, have a look at same for the offending sql.

In case its not there, check out trace options.

Thanks
Girish
Previous Topic: undo_tablespace - rollback segment OFFLINE
Next Topic: Database shutdown automatically (merged again)
Goto Forum:
  


Current Time: Sun Dec 04 06:13:24 CST 2016

Total time taken to generate the page: 0.22046 seconds