Home » RDBMS Server » Server Administration » ORA-12012, ORA-04021, ORA-06512 (Oracle 12c (12.1.0.1.0)- Solaris)
ORA-12012, ORA-04021, ORA-06512 [message #668033] Thu, 01 February 2018 04:13 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member

Hello Team,

I am getting the below error in alert log file. I need your help to resolve this.

Errors in file /mnt/tfr/oracle/diag/rdbms/tfrdb1/tfrdb/trace/tfrdb_j000_27002.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_27214"
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 248
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 3847
ORA-06512: at "SYS.DBMS_STATS", line 42399
ORA-06512: at "SYS.DBMS_STATS", line 42599

Thanks
Re: ORA-12012, ORA-04021, ORA-06512 [message #668036 is a reply to message #668033] Thu, 01 February 2018 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04021: timeout occurred while waiting to lock object %s%s%s%s%s
 *Cause:  While waiting to lock a library object, a timeout occurred.
 *Action: Retry the operation later.
Have a look at trace file.
Have a look at what does the job do and which object it uses.

Re: ORA-12012, ORA-04021, ORA-06512 [message #668107 is a reply to message #668036] Wed, 07 February 2018 03:08 Go to previous message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hi Michel, Thanks for your suggestion. this issue is not reported again. We have retried the operation again & found that the operation is completed successfully.
Previous Topic: DB parameter change
Next Topic: dataguard server (physical standby) is restarted automatically
Goto Forum:
  


Current Time: Thu Mar 28 12:54:29 CDT 2024