ORA-01427 Occurs In Alert Log And Trace File
(Doc ID 564266.1)
Last updated on NOVEMBER 14, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.3 [Release 9.2 to 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
Below ORA-ORA-12012, ORA-01427 occurs in alert log and trace file.
*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2008-04-09 23:02:27.595
*** MODULE NAME:(DBMS_SCHEDULER) 2008-04-09 23:02:27.595
*** SERVICE NAME:(SYS$USERS) 2008-04-09 23:02:27.595
*** SESSION ID:(87.63291) 2008-04-09 23:02:27.595
*** 2008-04-09 23:02:27.595
ORA-12012: error on auto execute of job 3633898
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 15
Error 604 in job queue process
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 |
Cause |
Solution |