ORA-12012: error on auto execute of job 83

cd /data/oracle/product/10.2.0.1/OPatch

cp /home/oracle/p8350262_10205_Generic.zip  .
[oracle@ora OPatch]$ unzip p8350262_10205_Generic.zip

[oracle@ora 8350262]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./
......

ApplySession adding interim patch '8350262' to inventory

Verifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.

 

 

 

[oracle@ora 8350262]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at May 24, 2012 11:29:08 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle.  All rights reserved.

Enter the following information:
Database SID: mamiai
Listener port number: 1521
Password for SYS user: 
Password for SYSMAN user: 

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y
May 24, 2012 11:29:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /data/oracle/product/10.2.0.1/cfgtoollogs/emca/mamiai/emca_2012-05-24_11-29-08-PM.log.
May 24, 2012 11:29:54 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
WARNING: ORA-28000: the account is locked

May 24, 2012 11:29:54 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
May 24, 2012 11:29:56 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script.
 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
May 24, 2012 11:29:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
May 24, 2012 11:29:56 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
May 24, 2012 11:38:18 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 24, 2012 11:38:19 PM

 

[oracle@ora bdump]$ tail -f alert_mamiai.log
  Current log# 5 seq# 11315 mem# 0: /data/oracle/oradata/mamiai/redo05.log
Thu May 24 12:30:32 CST 2012
Thread 1 advanced to log sequence 11316 (LGWR switch)
  Current log# 6 seq# 11316 mem# 0: /data/oracle/oradata/mamiai/redo06.log
Thu May 24 16:54:27 CST 2012
Thread 1 advanced to log sequence 11317 (LGWR switch)
  Current log# 1 seq# 11317 mem# 0: /data/oracle/oradata/mamiai/redo01.log
Thu May 24 22:03:12 CST 2012
Thread 1 advanced to log sequence 11318 (LGWR switch)
  Current log# 2 seq# 11318 mem# 0: /data/oracle/oradata/mamiai/redo02.log
Thu May 24 23:30:04 CST 2012
Database in quiesce mode
Thu May 24 23:37:56 CST 2012
Errors in file /data/oracle/admin/mamiai/bdump/mamiai_j000_5694.trc:
ORA-12012: error on auto execute of job 83
ORA-04063: package body "SYSMAN.EMD_MAINTENANCE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EMD_MAINTENANCE"
ORA-06512: at line 1
Thu May 24 23:38:18 CST 2012
Database out of quiesce mode

[oracle@ora ~]$ cat  /data/oracle/admin/mamiai/bdump/mamiai_j000_5694.trc |more
/data/oracle/admin/mamiai/bdump/mamiai_j000_5694.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /data/oracle/product/10.2.0.1
System name:    Linux
Node name:      ora.mamiai.com.cn
Release:        2.6.18-238.9.1.el5
Version:        #1 SMP Tue Apr 12 18:10:13 EDT 2011
Machine:        x86_64
Instance name: mamiai
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 5694, image: oracle@ora.mamiai.com.cn (J000)

*** ACTION NAME:() 2012-05-24 23:37:56.334
*** MODULE NAME:() 2012-05-24 23:37:56.334
*** SERVICE NAME:(SYS$USERS) 2012-05-24 23:37:56.334
*** CLIENT ID:() 2012-05-24 23:37:56.334
*** SESSION ID:(488.52546) 2012-05-24 23:37:56.334
*** 2012-05-24 23:37:56.334
ORA-12012: error on auto execute of job 83
ORA-04063: package body "SYSMAN.EMD_MAINTENANCE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EMD_MAINTENANCE"
ORA-06512: at line 1

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7583803/viewspace-730925/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7583803/viewspace-730925/