ORA-06512 DBSNMP.BSLN_INTERNAL

2283 ワード

sql NoSQL テーブル文書

チェックログで次のエラーが発生しました.

ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1

一時的な解決策はこのjobを無効にすることです.

BEGIN
sys.dbms_scheduler.disable( '"SYS"."BSLN_MAINTAIN_STATS_JOB"' ); 
END;

MOSを問い合わせると、元は権限の問題です.
【参考文献】AlertLog Errors:ORA-12012:Error On Auto Execute Of Job,ORA-06512:at“DBSSNMP.BSLN＿INTERNAL”［ID 13296181.1］
DBSNMPユーザにSYSを付与必要がある.DBMS_JOBにはEXECUTEの権限があります.

SQL> select * from dba_tab_privs where table_name = 'DBMS_JOB';
 
GRANTEE         OWNER    TABLE_NAME    GRANTOR   PRIVILEGE     GRANTABLE HIERARCHY
--------------- -------- ------------- --------- ------------- --------- ---------
SYSMAN          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
OWBSYS          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
APEX_030200     SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
EXFSYS          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO     
PUBLIC          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO

SQL> grant EXECUTE on SYS.DBMS_JOB to DBSNMP;
 
Grant succeeded

SQL> select * from dba_tab_privs where table_name = 'DBMS_JOB';
GRANTEE         OWNER    TABLE_NAME    GRANTOR   PRIVILEGE     GRANTABLE HIERARCHY
--------------- -------- ------------- --------- ------------- --------- ---------
SYSMAN          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
OWBSYS          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
APEX_030200     SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
EXFSYS          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO
DBSNMP          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO     
PUBLIC          SYS      DBMS_JOB      SYS       EXECUTE       NO        NO

nosqlのredis、mongodb自動構成スクリプト

Vscode構成C++コンパイル環境