Database Administration (MOSC)

MOSC Banner

If the package BSLN_MAINTAIN_STATS_JOB doesn't run, will that cause issues with the database?

edited Sep 8, 2018 3:52AM in Database Administration (MOSC) 9 commentsAnswered ✓

Hi DBA Gurus,

I found the following error in the alert log of our UAT instance. Oracle Database version 11.2.0.3, OS : IBM AIX 64-bit Power systems version 7.1:

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

Oracle support has a metalink document on this which asks to apply a patch or as a workaround delete and recreate DBSNMP user.

I found the following entries from DBSNMP.BSLN_BASELINES:

My output:

DBID             INSTANCE NAME     STATUS      LAST_COMPUTE DATE

3450607347   ccbtest                      ACTIVE    12-AUG-18

3450607347   CCBPROD                ACTIVE    12-AUG-18

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center