Category: Premium Content

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.







Subscribe






















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.






	


	





	

		
		
OEM Scheduled Information Publisher Report: Unexpected error getting the HTTP response stream while generating report: java.net.ConnectException:Connection refused (Connection refused)
	


	
	
	

		

OEM Scheduled Information Publisher Report failed everyday with the following errors:





"Unexpected error getting the HTTP response stream while generating report: java.net.ConnectException:Connection refused (Connection refused) Connection: https://emslb.domain:7799 URI:/em/onetime/reports/render?printablePage=true&reportID=0120G3D88D567B78E06324D1020A73D0&action=generate&scheduled=true"











Subscribe to get access





Read more of this content when you subscribe today.







Subscribe











	


	





	

		
		
ORA-00600: internal error code, arguments: [17287]
	


	
	
	

		

ORA-00600 error occurs while startup 19c RAC database in ExaCC:





ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [17287], [0x7FA1EDB80130],
[0x22F3A9C18], [], [GSMADMIN_INTERNAL], [DBMS_GSM_CLOUDADMIN], [11], [1], [],
[], [], []
Process ID: 335484
Session ID: 2850 Serial number: 17388





INCIDENT TRACE FILE  with CALL STACK




...
..
.
----- Incident Context Dump -----
Address: 0x7fa1f83fa060
Incident ID: 197141
Problem Key: ORA 600 [ORA-00600: internal error code, arguments: [17287], [0x7FA1EDB80130], [0x22F3A9C18], [], [GSMADMIN_INTERNAL], [DBMS_GS]
Error: ORA-600 [ORA-00600: internal error code, arguments: [17287], [0x7FA1EDB80130], [0x22F3A9C18], [], [GSMADMIN_INTERNAL], [DBMS_GSM_CLOUDADMIN], [11], [1], [], [], [], []
] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgeade []
[04]: kgeseml []
[05]: kgesem []
[06]: OCIKSEC []<-- Signaling
[07]: gwm_refresh_params []
[08]: gwm_init []
[09]: gwm_notifier []
[10]: gwm_pdb_notifier []
[11]: kscdnfy [VOS]
[12]: kpdbaSwitchOpenClose [PROGINT]
[13]: kpdbSwitchRunAsSysCbk [PROGINT]
[14]: rpiswu2 [RPI]
[15]: kpdbSwitch [PROGINT]
[16]: kpdbaOpenPdb [PROGINT]
[17]: kpdbaOpenClose [PROGINT]
[18]: kpdbaSwitchStateFromRoot [PROGINT]
[19]: kpdbRestorePdbStates_int [PROGINT]
[20]: kpdbRestorePdbStates [PROGINT]
[21]: kpdbCDBOpen [PROGINT]
[22]: adbdrv_options []
[23]: opiexe [Time_Limit]
[24]: opiosq0 [OPI]
[25]: kpooprx [PROGINT_MISC]
[26]: kpoal8 [PROGINT_MISC]
[27]: opiodr [OPI]
[28]: ttcpip []
[29]: opitsk [OPI]
[30]: opiino [OPI]
[31]: opiodr [OPI]
[32]: opidrv [OPI]
[33]: sou2o []
[34]: opimai_real [OPI]
[35]: ssthrdmain []
[36]: main []
...
..
.





CAUSE 





User has run a couple of SQL scripts to have revoked some privileges from PUBLIC for security compliance purpose. Hence there are many invalid objects for SYS, PUBLIC, GSMADMIN_INTERNAL, etc.





SOLUTION











Subscribe to get access





Read more of this content when you subscribe today.







Subscribe











	


	





	

		
		
OGG-00303 OGG-10124 Caused by DYNAMICPORTLIST Parameter When Starting GoldenGate Manager
	


	
	
	

		

The following errors occur when starting GoldenGate Manager:





2022-08-19T21:21:04.281+1000  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2022-08-19T21:21:04.325+1000  ERROR   OGG-00303  Oracle GoldenGate Manager for Oracle, mgr.prm:  Unrecognized parameter (DYNAMICPORTLIST        15100).
2022-08-19T21:21:04.325+1000  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.






2022-08-19T21:38:26.148+1000  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2022-08-19T21:38:26.207+1000  ERROR   OGG-10124  Oracle GoldenGate Manager for Oracle, mgr.prm:  (mgr.prm) line 3: Parsing error, value "15100 - 15150" is not one of the legal values ((0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4})))([-](0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4}))))?)([, ]+(0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4})))([-](0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4}))))?)* for [dynamicportlist].
2022-08-19T21:38:26.207+1000  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.






SOLUTION











Subscribe to get access





Read more of this content when you subscribe today.







Subscribe











	


	





	

		
		
ORA-00308: cannot open archived log
	


	
	
	

		

Standby database recovery stopped with the following errors:





Wed Aug 17 10:43:35 2022
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 8 slaves
Waiting for all non-current ORLs to be archived…
All non-current ORLs have been archived.
Media Recovery Log /fra/PRDB/archivelog/2022_08_11/o1_mf_1_68911_kh8kkwp0_.arc
Error opening /fra/PRDB/archivelog/2022_08_11/o1_mf_1_68911_kh8kkwp0_.arc
Attempting refetch
MRP0: Background Media Recovery terminated with error 308
Errors in file /u01/app/oracle/diag/rdbms/prdb/PRDB/trace/PRDB_pr00_17264.trc:
ORA-00308: cannot open archived log '/fra/PRDB/archivelog/2022_08_11/o1_mf_1_68911_kh8kkwp0_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE
MRP0: Background Media Recovery process shutdown (PRDB)





Check the missing archive log does exist: 





$ ls -ltr /fra/PRDB/archivelog/2022_08_11/o1_mf_1_68911_*_.arc
-rw-r-----. 1 oracle oinstall 910116352 Aug 11 09:58 /fra/PRDB/archivelog/2022_08_11/o1_mf_1_68911_kh8kjvh9_.arc





SOLUTION











Subscribe to get access





Read more of this content when you subscribe today.







Subscribe