Home » RDBMS Server » Server Administration » Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 (oracle 11.2.0.3; AIX 6.1)
Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584943] Mon, 20 May 2013 12:54 Go to next message
cakeday
Messages: 27
Registered: May 2010
Junior Member
Hello Experts:
i upgraded oracle from version 11.1.0.7 to 11.2.0.3; Applied the OPatch and the April 2013 PSU patch.

After i upgraded the database, i am getting the following errors in my alert log..

i am also listing a part of my alert log below for your reference. Please help since this is a very critical production database.


CLIENT_NAME JOB_START_TIME JOB_NAME JOB STATUS JOB_ERROR
auto space advisor 5/19/2013 10:05:42.939996 PM ORA$AT_SA_SPC_SY_15566 FAILED 6502
auto space advisor 5/19/2013 6:05:32.809577 PM ORA$AT_SA_SPC_SY_15555 FAILED 6502
auto space advisor 5/19/2013 2:05:23.400671 PM ORA$AT_SA_SPC_SY_15553 FAILED 6502
auto space advisor 5/19/2013 10:05:11.979476 AM ORA$AT_SA_SPC_SY_15551 FAILED 6502
auto space advisor 5/19/2013 6:00:02.714771 AM ORA$AT_SA_SPC_SY_15548 FAILED 6502
auto space advisor 5/18/2013 10:04:42.454018 PM ORA$AT_SA_SPC_SY_15546 FAILED 6502
auto space advisor 5/18/2013 6:04:31.750763 PM ORA$AT_SA_SPC_SY_15536 FAILED 6502
auto space advisor 5/18/2013 2:04:21.394908 PM ORA$AT_SA_SPC_SY_15534 FAILED 6502
auto space advisor 5/18/2013 10:04:10.336048 AM ORA$AT_SA_SPC_SY_15532 FAILED 6502
auto space advisor 5/18/2013 6:00:03.008264 AM ORA$AT_SA_SPC_SY_15529 FAILED 6502
auto space advisor 5/17/2013 10:00:02.618205 PM ORA$AT_SA_SPC_SY_15526 FAILED 6502
auto space advisor 5/16/2013 10:00:02.480381 PM ORA$AT_SA_SPC_SY_15523 SUCCEEDED 0
auto space advisor 5/15/2013 10:00:02.732581 PM ORA$AT_SA_SPC_SY_15520 SUCCEEDED 0

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15529"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15532"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15534"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15536"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-00600: internal error code, arguments: [723], [131048], [160248], [memory leak], [], [], [], [], [], [], [], []
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_15546"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538

Thank You. Any help will be highly appreciated.
Re: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584946 is a reply to message #584943] Mon, 20 May 2013 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel
Re: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584955 is a reply to message #584943] Mon, 20 May 2013 14:15 Go to previous messageGo to next message
John Watson
Messages: 4082
Registered: January 2010
Location: Global Village
Senior Member
Is this actually a problem for you? Do you ever look at the results of the space advisor auto task? It doesn't do much for me. Disable it with dbms_auto_task_admin.disable and you won't get any more such messages.
Re: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584958 is a reply to message #584943] Mon, 20 May 2013 14:30 Go to previous messageGo to next message
cakeday
Messages: 27
Registered: May 2010
Junior Member
THANK YOU Michel and John for your prompt response.

hi Michel: i am looking into the external tables and the link that you offered.. with not much success so far..

John: In the meantime, i have diabled the job like you suggested since i don't use the space advisor utility.
exec dbms_auto_task_admin.disable('auto optimizer stats collection',NULL,NULL);
how do i know that the issue has been resolved ? Since this seems like an automatic sys job. ?
= = =


Although, another error that i see in the alert log since the upgrade is the following..

ALERT LOG:Sun May 19 18:27:04 2013
Errors in file /p097/oracle/diag/rdbms/p097/p097/trace/p097_dw00_32637418.trc (incident=303682):
ORA-00600: internal error code, arguments: [723], [131048], [169960], [memory leak], [], [], [], [], [], [], [], []
Incident details in: /p097/oracle/diag/rdbms/p097/p097/incident/incdir_303682/p097_dw00_32637418_i303682.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun May 19 18:27:08 2013

The dump file has the following..Dump continued from file: /p097/oracle/diag/rdbms/p097/p097/trace/p097_dw00_32637418.trc
ORA-00600: internal error code, arguments: [723], [131048], [169960], [memory leak], [], [], [], [], [], [], [], []

========= Dump for incident 303682 (ORA 600 [723]) ========
----- Beginning of Customized Incident Dump(s) -----
******** ERROR: PGA memory leak detected 169960 > 131048 ********
******************************************************
HEAP DUMP heap name="pga heap" desc=110004a60
extent sz=0x20c0 alt=216 het=32767 rec=0 flg=3 opc=3
parent=0 owner=0 nex=0 xsz=0x10fff0 heap=0
fl2=0x60, nex=0, dsxvers=1, dsxflg=0x0
dsx first ext=0x1083b590
EXTENT 0 addr=111966ba0
Chunk 111966bb0 sz= 2097120 perm "perm " alo=2085552
EXTENT 1 addr=111916ba0
Chunk 111916bb0 sz= 1072 free " "
Chunk 111916fe0 sz= 4856 freeable "kdl ctxdp:ctx "
Dump of memory from 0x0000000111916FE0 to 0x00000001119182D8
111916FE0 00B38F00 000012F9 00000001 11916BB0 [..............k.]
111916FF0 00000001 0A4369B8 00000000 00000000 [.....Ci.........]
111917000 00180500 00000001 08560000 00000002 [.........V......]
111917010 00000000 050226BC 05022685 00000000 [......&...&.....]
111917020 00000000 00000000 00000000 00000000 [................]

MORE OF THE SAME and then,------------------- end error stack dump with barriers
----- END DDE Action: 'dumpKGEState' (SUCCESS, 0 csec) -----
----- START DDE Action: 'kpuActionDefault' (Sync) -----
Begin OCI Current State Dump
End OCI Current State Dump

Begin OCI Call Context Dump
End OCI Call Context Dump

Begin Process state dump.
ttcdrvdmplocation: msg-0 ln-0 reporting 0
HST is NULL or no two task connection
End Process state dump.
----- END DDE Action: 'kpuActionDefault' (SUCCESS, 0 csec) -----
----- END DDE Actions Dump (total 0 csec) -----
End of Incident Dump

Re: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584970 is a reply to message #584958] Mon, 20 May 2013 15:21 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 20 May 2013 20:22
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

[Updated on: Mon, 20 May 2013 15:22]

Report message to a moderator

Re: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3 [message #584971 is a reply to message #584958] Mon, 20 May 2013 15:23 Go to previous message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how do i know that the issue has been resolved ?


The issue is not solve, it just no more appears.

Regards
Michel
Previous Topic: Why oracle scheduler is not running
Next Topic: Listener shutdown for individual instances?
Goto Forum:
  


Current Time: Sat Apr 19 21:05:14 CDT 2014

Total time taken to generate the page: 0.26749 seconds