ORA-01427 Occurs In Alert Log And Trace File

(Doc ID 564266.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 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.

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

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