Articles Comments

Oracle DBA & All IT » ORA-Error » ORA-06512 DBSNMP.BSLN_INTERNAL

ORA-06512 DBSNMP.BSLN_INTERNAL

May 5th, 2011 | 14 Comments

Error นี้พบใน oracle11g  จะเกิดขึ้นใน alert log file โดยจะมี Error นี้เกิดขึ้นทุกๆวันอาทิตย์ โดยมี Error ตามด้านล่างนี้

ORA-12012: error on auto execute of job 2473584
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1

Cause:

Table DBSNMP.BSLN_BASELINES contains inconsistent information. 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: metalink[ID 736627.1]

SQL> @?/rdbms/admin/catnsnmp.sql — drop user
SQL> @?/rdbms/admin/catsnmp.sql — create user
 

Example Error:

1.  BSLN_MAINTAIN_STATS_JOB failed at every SUNDAY

2.  Alert messages got the following

Errors in file /opt/oracle/diag/rdbms/vstbpro/vstbpro1/trace/vstbpro1_j000_7796.trc:
ORA-12012: error on auto execute of job 11762
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at “DBSNMP.BSLN_INTERNAL”, line 2073

3. Details of the trace file

Trace file /opt/oracle/diag/rdbms/vstbpro/vstbpro1/trace/vstbpro1_j000_7796.trc
Oracle Database 11g Release 11.1.0.7.0 – 64bit Production
With the Real Application Clusters option
ORACLE_HOME = /opt/oracle/product/11g
System name:    SunOS
Node name:      wvpdb09
Release:        5.10
Version:        Generic_138888-01
Machine:        sun4u
Instance name: vstbpro1
Redo thread mounted by this instance: 1
Oracle process number: 73
Unix process pid: 7796, image: oracle@wvpdb09 (J000)

*** 2010-04-11 15:00:04.639
*** SESSION ID:(1041.32020) 2010-04-11 15:00:04.639
*** CLIENT ID:() 2010-04-11 15:00:04.639
*** SERVICE NAME:(SYS$USERS) 2010-04-11 15:00:04.639
*** MODULE NAME:(DBMS_SCHEDULER) 2010-04-11 15:00:04.639
*** ACTION NAME:(BSLN_MAINTAIN_STATS_JOB) 2010-04-11 15:00:04.639

ORA-12012: error on auto execute of job 11762
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at “DBSNMP.BSLN_INTERNAL”, line 2073
ORA-06512: at line 1

.. Preview : 14322

Related Search:

  • ORA-06512: at DBSNMP BSLN_INTERNAL line 2073
  • DBSNMP BSLN_INTERNAL
  • ORA-12012: error on auto execute of job SYS BSLN_MAINTAIN_STATS_JOB
  • ORA-06512: at DBSNMP BSLN_INTERNAL
  • BSLN_INTERNAL
  • ora-06512 at dbsnmp bsln_internal after 11g upgrade
  • bsln_maintain_stats_job
  • oracle dbsnmp bsln_internal

Written by

บอกเล่าสิ่งที่พบเจอมาในการทำงาน ประสบการณ์การทำงานด้าน DBA ถ่ายทอดกันด้วยภาษาง่ายๆ บ้านๆ " ทุกอย่างไม่อยาก แต่... แค่ตั้งใจไม่พอ ต้องลงมือทำ และทำ GoodLuck " Fanpage: www.facebook.com/DBAor .. "Oracle Database Consultant " ..

Filed under: ORA-Error · Tags: , , , , , , , , , , ,

  • What a great web log. I spend hours on the net reading blogs, about tons of various subjects. I have to first of all give praise to whoever created your theme and second of all to you for writing what i can only describe as an fabulous article. I honestly believe there is a skill to writing articles that only very few posses and honestly you got it. The combining of demonstrative and upper-class content is by all odds super rare with the astronomic amount of blogs on the cyberspace.

    • It’s soopky how clever some ppl are. Thanks!

  • You have a very nice layout for your blog. i want it to use on my site too “    

    • Glad I’ve fnailly found something I agree with!

  • Hi buddy, very informative post. Please keep them coming. Thanks, auncey Favorite.

    • How could any of this be better satetd? It couldn’t.

    • This site is like a calssroom, except I don’t hate it. lol

  • Wow, I’m flabbergasted by the stature of material on this blog. There are a ton of good resources here. I know I will visit this blog again.

    • Play informative for me, Mr. inentret writer.

  • when you have proper sales training, you can always sell any item that you want wether it online or offline*

  • Our wine has been carried at Bevmo stores since the beginning, when we made less then 5,000 cases. We are a little larger now (avg. of 70,000 cases annually, but still family-owned and operated) My experiences there is they are very friendly to local markets and carry different products in different stores.

  • Boy that raelly helps me the heck out.

  • Whoa, whoa, get out the way with that good inofmration.

  • THX that’s a great awnesr!