My Oracle Support Banner

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 to [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.


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


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

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