生产库有以下报错:
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
考虑是生产库,又不影响业务,暂时不动。