ORA-06512: at "DBSNMP.BSLN_INTERNAL",

生产库有以下报错：

 

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

网上资料都是说DBSNMP.BSLN_INTERNAL表记录冲突导致，解决方法就是删除并重建DBSNMP 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

 

考虑是生产库，又不影响业务，暂时不动。