redhat 5.8 oracle11.2.0.3 报警ORA-12012 ORA-06550 PLS-00905 ORA-06550

zhangfuji11

数据库版本11.2.0.3 系统版本 redhat5.8 无rac无dg
报警日志中记录如下
Errors in file /u01/app/oracle/product/diag/rdbms/hr91prd/HR91PRD/trace/HR91PRD_j000_28709.trc:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06550: line 1, column 814:
PLS-00905: object DBSNMP.BSLN_INTERNAL is invalid
ORA-06550: line 1, column 807:
PL/SQL: Statement ignored
Sun Sep 29 00:00:34 2013
Thread 1 cannot allocate new log, sequence 40926
Private strand flush not complete

===========================================
以下为HR91PRD_j000_28709.trc内容
Trace file /u01/app/oracle/product/diag/rdbms/hr91prd/HR91PRD/trace/HR91PRD_j000_28709.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name:        Linux
Node name:        C5415
Release:        2.6.18-308.el5
Version:        #1 SMP Fri Jan 27 17:17:51 EST 2012
Machine:        x86_64
Instance name: HR91PRD
Redo thread mounted by this instance: 1
Oracle process number: 220
Unix process pid: 28709, image: oracle@C5415 (J000)


*** 2013-09-29 00:00:00.788
*** SESSION ID:(964.4619) 2013-09-29 00:00:00.788
*** CLIENT ID:() 2013-09-29 00:00:00.788
*** SERVICE NAME:(SYS$USERS) 2013-09-29 00:00:00.788
*** MODULE NAME:(DBMS_SCHEDULER) 2013-09-29 00:00:00.788
*** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2013-09-29 00:00:00.788

ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06550: line 1, column 814:
PLS-00905: object DBSNMP.BSLN_INTERNAL is invalid
ORA-06550: line 1, column 807:
PL/SQL: Statement ignored
执行过 grant execute on SYS.DBMS_ JOB to DBSNMP;
没有用 请帮忙分析下是什么问题 谢谢

liuwenqing

能不能提供一下BSLN_MAINTAIN_STATS_JOB怎么写的,日志中说object DBSNMP.BSLN_INTERNAL 无效.

lgang403

select comp_id,comp_name,version,status from dba_registry;

zhangfuji11

1* select status,object_name,owner from dba_objects where object_name like '%BSLN_INTERNAL%'
SQL> /  

STATUS  OBJECT_NAME                    OWNER
------- ------------------------------ ------------------------------
VALID   BSLN_INTERNAL                  DBSNMP
VALID   BSLN_INTERNAL                  DBSNMP

ALLSTARS_ORACLE

试试

-- Login as sys user.

SQL> sqlplus / as sysdba

-- From the sqlplus execute the following:

-- Drop the DBSNMP user by executing catnsnmp.sql script.

SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql

-- Create the DBSNMP user by executing catsnmp.sql

SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql