Upgrade to CU7 fails on oracle_discovery_server_create.sql step - ORA-00600 error

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Upgrade to DX UIM 23.4.7 fails at step [6] oracle_discovery_server_create.sql

Symptoms:

• installer exits suddenly with no error
• /tmp/ca_uim/uimserver_ia_install.log contains ORA-00600 error

example:

 [main]  ERROR com.nimsoft.install.uimserver.action.impl.UIMServerDBSchemaController:run:183 impl.UIMServerDBSchemaController - NimException caught com.nimsoft.nimdbprovider.base.exception.NimDBProviderBaseException: java.sql.SQLException: ORA-00600: internal error code, arguments: [13011], [356], [243343623], [127], [243343623], [17], [], [], [], [], [], []

Environment

DX UIM 23.4.x upgrading to 23.4.7
Oracle 19c database
Red Hat Enterprise Linux 9

Cause

Corruption of the Oracle Data Dictionary 

Resolution

ORA-00600 is an internal Oracle database error unrelated to the application data or tables in most cases.

Oracle recommends always engaging Oracle Support when encountering ORA-0600 errors.  Oracle Support will need to collect logs and trace files in order to determine the source of the corruption.  ORA-00600 is an internal database error which can be cased by known defects in Oracle, database corruption, or other database-level issues which can only be diagnosed by Oracle.

When this issue was observed during an upgrade to DX UIM 23.4.7 from 23.4.3, Oracle Support was engaged, and they were able to identify corruption in the tables representing the Data Dictionary and provide a fix which was implemented by the customer DBA successfully.