Monday, 13 September 2010


Applies to:
Oracle Server - Enterprise Edition - Version: to - Release: 11.1 to 11.2
Information in this document applies to any platform.
The BSLN_MAINTAIN_STATS_JOB doesn't run anymore.
Trace file shows : 
ORA-12012: error on auto execute of job 11689 
ORA-06502: PL/SQL: numeric or value error 
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
Table DBSNMP.BSLN_BASELINES contains inconsistent information. In this case, after database cloning, existing records in table "DBSNMP.BSLN_BASELINES" conflict with new baseline information inserted in the cloned database.
The DBSNMP user needs to be dropped and re-created. 
From the sqlplus execute the following:

SQL> @?/rdbms/admin/catnsnmp.sql -- drop user 
SQL> @?/rdbms/admin/catsnmp.sql -- create user

This email has been scanned by the MessageLabs Email Security System.
For more information please visit

No comments: