Problem:
BSLN_MAINTAIN_STATS_JOB fails with the following error:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
|
Solution:
DBSNMP Oracle user can be dropped and re-created using the delivered scripts:
# If you are using Grid Control:
$AGENT_BIN/emctl stop agent
-- Login as sys 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
# If you are using Grid Control:
$AGENT_BIN/emctl stop agent
|
I hope this helps.
Please feel free to leave your questions or suggest improvements to this section.
Beware if you have a pw verification function. Catsnmp.sql is likely to fail when it attempts to create dbsnmp with pw dbsnmp. Then it will create the rest of the objects as sys. If so, you should create user dbsnmp before you run the script.
ReplyDelete