Monday 13 September 2010

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
______________________________________________________________________

No comments: