ORA-01427 Occurs In Alert Log And Trace File
Last updated on JULY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms