Repetitive ORA-12012/ORA-12005 Errors Appear In the Collaboration Suite Database's Alert.log

翻译 2018年04月17日 14:57:36

APPLIES TO:

Oracle Content Services - Version 10.1.2.0.0 to 10.2.1.0.27 [Release AS10gR2 to AS10gR3]
Information in this document applies to any platform.

SYMPTOMS

  • The OCS database's alert.log file contains following error messages :
Fri May 12 15:02:27 2006


Errors in file /u01/oracle/admin/OCS/bdump/ocs_j000_4213.trc:


ORA-12012: error on auto execute of job 76


ORA-12005: may not schedule automatic refresh for times in the past
  • The error messages are raised at regular interval, and the job is not executed.
  • The failing job is the one that is listening on the Content Services event queue
SQL> select job,what from dba_jobs where job=76;  





JOB        WHAT


---------- ---------------------------------


       76 wf_event.listen('ECM_OUT');

CAUSE

By default, the wf_event.listen('ECM_OUT') job executes every 5 seconds.

On loaded systems, the 5 seconds refresh time for the job is too low, and causes the job to get out of sync.  When the next execution date is already in the past, the error messages above are raised in the database's alert.log file.

SOLUTION

To implement the solution, please execute the following steps:

  1. Connect with sqlplus as OWF_MGR user to the OCS database
  2. Run the ClearJobs.sql script to drop the job : 
    $ORACLE_HOME/content/admin/sql/workflow/ClearJobs.sql
  3. Reconnect with sqlplus as OWF_MGR user
  4. Run SetupJobs.sql script to recreate the job :
    $ORACLE_HOME/content/admin/sql/workflow/SetupJobs.sql 15
    The argument passed to the script is the job's refresh rate : 15 seconds in the example above.

** Note: An alternate solution is attached to this document that provides a more accurate interval calculation.

See attached:  Addendum to Doc ID 370687.1.txt


The password for the OWF_MGR schema is stored in OID, and can be retrieved as follows :

Using Oracle Directory Manager :

  1. Start oidadmin (Oracle Directory Manager on Windows) and login as orcladmin to OID
  2. Click on the '+' sign next to 'Entry Management'
  3. Drill down : cn=OracleContext -> cn=Products -> cn=IAS -> cn=IAS Infrastructure Databases -> orclReferenceName=<your db name> -> OrclResourceName=OWF_MGR
  4. The attribute 'orclpasswordattribute' contains the schema password for the OWF_MGR user.

Using ldapsearch (instead of Oracle Directory Manager) :

$ORACLE_HOME/bin/ldapsearch -h <hostname> -p <port> -D cn=orcladmin -w <cn=orcladmin pwd> \


    -b "cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=oracleContext" \


    -s sub orclResourceName="OWF_MGR" orclpasswordattribute

【直通华为HCNA/HCNP系列S篇1】Sx7系列交换机主要特性及选型

本课程主要介绍华为最新一代Sx700系列交换机组成,各产品系列的特性、命名规则、主要机型、产品结构,以及各自主要应用等方面。这也是华为HCNA认证考试中的一个部分。
  • 2015年03月17日 22:05

ORA-12012,ORA-12005

ORA-12012: error on auto execute of job 125ORA-12005: may not schedule automatic refresh for times i...
  • Blaider
  • Blaider
  • 2010-06-18 16:56:00
  • 3305

Oracle11g ORA-12005: 不能安排过去时间的自动刷新

Tue Aug 29 23:30:04 2017 Errors in file /oracle/app/oracle/diag/rdbms/gg/gg1/trace/gg1_j001_47778152...
  • guogang83
  • guogang83
  • 2017-09-01 14:23:51
  • 619

ORA-12005不能安排过去时间的自动刷新--问题处理

这两天一个库总报ORA-12005的错误 查看alert日志信息: Thu Apr 09 22:30:03 2015 Errors in file /oracle/app/oracle/diag/rd...
  • royzhang7
  • royzhang7
  • 2015-04-13 11:35:50
  • 841

oracle dblink创建过程

两台不同的数据库服务器,从一台数据库服务器的一个用户读取另一台数据库服务器下的某个用户的数据,这个时候可以使用dblink。     其实dblink和数据库中的view差不多,建dblink的时候需...
  • xyjnzy
  • xyjnzy
  • 2007-12-04 11:54:00
  • 1597

rpmbuild报错Installed (but unpackaged) file(s) found ?

============================================================================== The changes which r...
  • zhoujiaxq
  • zhoujiaxq
  • 2014-07-25 09:20:17
  • 2498

openfire 安装配置报错The Openfire database schema does not appear to be installed. Follow the installati解决

The Openfire database schema does not appear to be installed. Follow the installation guide to fix...
  • mac_lim
  • mac_lim
  • 2013-09-12 15:08:16
  • 4783

安装opfenfire 错误以及原因

安装ofenfire,在连接数据库的时候,出现错误:The Openfire database schema does not appear to be installed. Follow the i...
  • wletv
  • wletv
  • 2013-03-17 01:58:46
  • 3642

openfire安装The Openfire database schema does not appear to be installed. Follow the installation guid

安装了好几次openfire,这次安装用mysql数据库时居然出现The Openfire database schema does not appear to be installed. Follo...
  • gly742279097
  • gly742279097
  • 2015-01-03 23:29:18
  • 1469
收藏助手
不良信息举报
您举报文章:Repetitive ORA-12012/ORA-12005 Errors Appear In the Collaboration Suite Database's Alert.log
举报原因:
原因补充:

(最多只允许输入30个字)