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  |
cakeday
Messages: 31
Registered: May 2010
|
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 #584958 is a reply to message #584943] |
Mon, 20 May 2013 14:30  |
cakeday
Messages: 31
Registered: May 2010
|
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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Apr 16 06:28:33 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
