ORA-06512 'DBSNMP.BSLN_INTERNAL [ID 736627.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

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

Cause

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. 

Solution

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 http://www.messagelabs.com/email
______________________________________________________________________