| RLM$SCHDNEGACTION [message #239235] |
Mon, 21 May 2007 16:58  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
