7 Replies Latest reply on Jun 6, 2013 8:54 AM by oelk0



      saw the alert_XE.log and found the following:

      Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j002_11344.trc:
      ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
      ORA-06550: line 1, column 807:
      PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared
      ORA-06550: line 1, column 807:
      PL/SQL: Statement ignored

      This is cause the schema DBSNMP is not installed? Right?

      Is it necessary to install it:
      sqlplus sys/****** as sysdba @?/rdbms/admin/catsnmp.sql

      If i create it the messages disappear.

      Or is it usefull to disable the job BSLN_MAINTAIN_STATS_JOB:
      exec DBMS_SCHEDULER.disable (name => 'BSLN_MAINTAIN_STATS_JOB');

      What is this good for? Do i need it?

      Best regards
        • 1. Re: XE11: BSLN_MAINTAIN_STATS_JOB

          this is a known bug in 11.2 XE. It concerns the database job that would regularly update your tables statistics to ensure the optimizer will always get a good execution plan for queries. Whether you need it or not depends on how you use your database. But it certainly won't harm to fix the issue. To do so, you can run the follwing command sequence
          cd $ORACLE_HOME/rdbms/admin
          sqlplus / as sysdba
          shutdown immediate;
          I integrated this snippet in my personal "post-install" script, among with some other adjustments for OS-specific settings, database parameters and the fix for the mixed up datafiles (sysaux and undo).

          • 2. Re: XE11: BSLN_MAINTAIN_STATS_JOB
            Thanks Udo for your reply,

            in the process of a scripting installation i do a shutdown and startup.

            Is there a listing and explanation of all scheduler jobs?

            Best regards
            • 3. Re: XE11: BSLN_MAINTAIN_STATS_JOB
              Sure, you can query the corresponding dba-view dba_scheduler_jobs to get an overview.
              For just knowing what's there, you can run
              SELECT job_name,
                FROM dba_scheduler_jobs
               ORDER BY job_name;
              You'll see a short description for most predefined jobs in the comments section. If you want to know more, I recommend "RTFM" or your preferred search engine on the job name.

              • 4. Re: XE11: BSLN_MAINTAIN_STATS_JOB
                Thanks, i know that.
                I would like to have 'RTFM', where can i find?

                Best reagrds
                • 5. Re: XE11: BSLN_MAINTAIN_STATS_JOB
                  To be honest, there is no "all in one" view from Oracle directly. You either have to start with third-party sources (e. g. [url http://www.asktherealtom.ch/?p=147]Oracle 11g Default Jobs) or go through the docs based on their topic.
                  For the latter, a good start would be the Oracle Database Administration Guide, e. g. in Part IV on [url http://docs.oracle.com/cd/E18283_01/server.112/e17120/part6.htm#i996746]Database Resource Management and Task Scheduling. Then, there is the documentation for the [url http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#CHDEBFCH]DRA (Data Recovery Advisor). And so on. I'm not sure a "everyday" XE-dba would want to dig deeper into that area, unless you have an actual call for it.

                  • 6. Re: XE11: BSLN_MAINTAIN_STATS_JOB
                    Hi Udo,

                    does it concern only the linux-version or the windows-version also?
                    The document ID 1413756.1 does not make any statement about the version.

                    Best regards
                    • 7. Re: XE11: BSLN_MAINTAIN_STATS_JOB
                      Yes, it's missing in the windows-version also.

                      Best regards