Database Administration (MOSC)

MOSC Banner

ORA-12012, ORA-01878

edited Apr 5, 2010 2:58AM in Database Administration (MOSC) 4 commentsAnswered
 Hi,
These errors started showing up in my 11.1.0.7, RAC database:
Fri Apr 02 16:16:30 2010
Errors in file /u01/app/oracle/diag/rdbms/trng/TRNG1/trace/TRNG1_j000_24002.trc:
ORA-12012: error on auto execute of job 41
ORA-01878: specified field not found in datetime or interval

The trace file has is this:
Trace file /u01/app/oracle/diag/rdbms/trng/TRNG1/trace/TRNG1_j000_24002.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1
System name:    Linux
Node name:      db2dev.cis.ship.edu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center