My Oracle Support Banner

ORA-01427 Occurs In Alert Log And Trace File (Doc ID 564266.1)

Last updated on AUGUST 04, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.