How to find more information on ORA-12012
On my Oracle 11g R1 database, I found ORA-12012 errors on alert_log and trace files.
How to find out the job/scheduler information? why did I get different job numbers with same ORA-01756?
Thanks
*** 2012-07-17 09:13:59.999
*** SESSION ID:(146.21974) 2012-07-17 09:13:59.999
*** CLIENT ID:() 2012-07-17 09:13:59.999
*** SERVICE NAME:(SYS$USERS) 2012-07-17 09:13:59.999
*** MODULE NAME:(DBMS_SCHEDULER) 2012-07-17 09:13:59.999
*** ACTION NAME:(PO3091129998) 2012-07-17 09:13:59.999
ORA-12012: error on auto execute of job 220483
ORA-01756: quoted string not properly terminated
*** 2012-07-10 02:35:45.827
*** SESSION ID:(153.22211) 2012-07-10 02:35:45.827
*** CLIENT ID:() 2012-07-10 02:35:45.827
*** SERVICE NAME:(SYS$USERS) 2012-07-10 02:35:45.827
*** MODULE NAME:(DBMS_SCHEDULER) 2012-07-10 02:35:45.827
*** ACTION NAME:(PO16098989998) 2012-07-10 02:35:45.827