Solution
$ export CV_ASSUME_DISTID=OEL7.6
Category: Upgrade
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [qksopGetBindName:1]
When running Oracle PRE-Upgrade Fixup Script “preupgrade_fixups.sql” for upgrading 11g to 19c, the following errors occur :
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. purge_recyclebin YES None.
2. parameter_obsolete NO Manual fixup recommended.
3. invalid_objects_exist NO Manual fixup recommended.
4. default_resource_limit NO Manual fixup recommended.
5. network_acl_priv NO Manual fixup recommended.
6. exclusive_mode_auth NO Manual fixup recommended.
7. case_insensitive_auth NO Manual fixup recommended.
8. streams_setup NO Manual fixup recommended.
9. mv_refresh NO Manual fixup recommended.
10. hidden_params NO Informational only.
Further action is optional.
11. underscore_events NO Informational only.
Further action is optional.
12. dictionary_stats YES None.
13. trgowner_no_admndbtrg YES None.
DECLARE
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [qksopGetBindName:1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_PREUP", line 3282
ORA-06512: at "SYS.DBMS_PREUP", line 3354
ORA-06512: at line 412
Alert and trace file:
ORA-00600: internal error code, arguments: [qksopGetBindName:1], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 219052 (ORA 600 [qksopGetBindName:1]) ========
*** 2024-05-06 13:03:58.038
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dvnyw9d47b9fv) -----
/* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("ADDR")),to_char(substrb(dump(min("ADDR"),16,0,32),1,120)),to_char(substrb(dump(max("ADDR"),16,0,32),1,120)),to_char(count("INDX")),to_char(substrb(dump(min("INDX"),16,0,32),1,120)),to_char(substrb(dump(max("INDX"),16,0,32),1,120)),to_char(count("INST_ID")),to_char(substrb(dump(min("INST_ID"),16,0,32),1,120)),to_char(substrb(dump(max("INST_ID"),16,0,32),1,120)),to_char(count("HADDR_KKOCS")),to_char(substrb(dump(min("HADDR_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("HADDR_KKOCS"),16,0,32),1,120)),to_char(count("PHADD_KKOCS")),to_char(substrb(dump(min("PHADD_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("PHADD_KKOCS"),16,0,32),1,120)),to_char(count("HASHV_KKOCS")),to_char(substrb(dump(min("HASHV_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("HASHV_KKOCS"),16,0,32),1,120)),to_char(count("SQLID_KKOCS")),to_char(substrb(dump(min("SQLID_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("SQLID_KKOCS"),16,0,32),1,120)),to_char(count("CHILDNO_KKOCS")),to_char(substrb(dump(min("CHILDNO_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("CHILDNO_KKOCS"),16,0,32),1,120)),to_char(count("PRED_KKOCS")),to_char(substrb(dump(min("PRED_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("PRED_KKOCS"),16,0,32),1,120)),to_char(count("RANGEID_KKOCS")),to_char(substrb(dump(min("RANGEID_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("RANGEID_KKOCS"),16,0,32),1,120)),to_char(count("LOWSEL_KKOCS")),to_char(substrb(dump(min("LOWSEL_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("LOWSEL_KKOCS"),16,0,32),1,120)),to_char(count("HIGHSEL_KKOCS")),to_char(substrb(dump(min("HIGHSEL_KKOCS"),16,0,32),1,120)),to_char(substrb(dump(max("HIGHSEL_KKOCS"),16,0,32),1,120)) from "SYS"."X$KKOCS_SELECTIVITY" t /* NDV,NIL,NIL,ACL,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x9cedd8288 145 package body SYS.DBMS_SQLTUNE_INTERNAL
0x9cedd8288 12098 package body SYS.DBMS_SQLTUNE_INTERNAL
0x9cedd8288 12732 package body SYS.DBMS_SQLTUNE_INTERNAL
0x9cedd8288 17413 package body SYS.DBMS_SQLTUNE_INTERNAL
SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; END;
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [qksopGetBindName:1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 25345
ORA-06512: at "SYS.DBMS_STATS", line 25887
ORA-06512: at line 1
SQL> select count(*) from "SYS"."X$KKOCS_SELECTIVITY" ;
select count(*) from "SYS"."X$KKOCS_SELECTIVITY"
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qksopGetBindName:1], [], [], [],
[], [], [], [], [], [], [], []
WORKAROUND
Subscribe to get access
Read more of this content when you subscribe today.
SQL> @ /u01/app/oracle/cfgtoollogs/testdb/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 13
Generated on: 2024-05-06 08:54:07
For Source Database: TESTDB
Source Database Version: 11.2.0.4.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. purge_recyclebin YES None.
2. parameter_obsolete NO Manual fixup recommended.
3. invalid_objects_exist NO Manual fixup recommended.
4. default_resource_limit NO Manual fixup recommended.
5. network_acl_priv NO Manual fixup recommended.
6. exclusive_mode_auth NO Manual fixup recommended.
7. case_insensitive_auth NO Manual fixup recommended.
8. streams_setup NO Manual fixup recommended.
9. mv_refresh NO Manual fixup recommended.
10. hidden_params NO Informational only.
Further action is optional.
11. underscore_events NO Informational only.
Further action is optional.
12. dictionary_stats YES None.
13. trgowner_no_admndbtrg YES None.
15. component_info NO Informational only.
Further action is optional.
16. tablespaces_info NO Informational only.
Further action is optional.
17. parameter_deprecated NO Informational only.
Further action is optional.
18. rman_recovery_version NO Informational only.
Further action is optional.
19. pre_disable_bct_upg NO Informational only.
Further action is optional.
20. invalid_all_obj_info NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
After database upgrated
SQL> desc "SYS"."X$KKOCS_SELECTIVITY" ;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
CON_ID NUMBER
HADDR_KKOCS RAW(8)
PHADD_KKOCS RAW(8)
HASHV_KKOCS NUMBER
SQLID_KKOCS VARCHAR2(13)
CHILDNO_KKOCS NUMBER
PRED_KKOCS VARCHAR2(40)
RANGEID_KKOCS NUMBER
LOWSEL_KKOCS VARCHAR2(10)
HIGHSEL_KKOCS VARCHAR2(10)
SQL> select count(*) from "SYS"."X$KKOCS_SELECTIVITY" ;
COUNT(*)
----------
0
SQL> exec dbms_stats.gather_table_stats('SYS','X$KKOCS_SELECTIVITY');
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
PL/SQL procedure successfully completed.
Make DBA Life Easy 