ORA-00600 Error On ORDS_SELF_SERVICE_SCHEMA During Installation Of ORDS 23.2.x (Doc ID 2972860.1)

Last updated on DECEMBER 15, 2023

Applies to:

Symptoms

Getting error when installing ORDS 23.2.x:
ORA-00600 Error on ORDS_SELF_SERVICE_SCHEMA during installation of ORDS 23.2.x

Installing a new instance of ORDS in a Oracle 19.20 database.

Started with the latest version, ords-23.2.2.208.1534, and ran

./ords install --interactive --log-folder ${ORDS_LOGS}

When the installation procedure was complete, was left with an error on validation, noting that the package ORDS_SELF_SERVICE_SCHEMA was invalid with the following error:

  Package Body ORDS_SELF_SERVICE_SCHEMA compiled

  LINE/COL ERROR
  --------- -------------------------------------------------------------
  1686/7 PL/SQL: SQL Statement ignored
  1702/41 PL/SQL: ORA-00600: internal error code, arguments: [qctbyt : bfc], [65535], [18446744073709551615], [1], [873], [1], [1], [0], [], [], [], []

Went back to previous versions of ORDS and tried installing each of those, dropping the ords_public_user, ords_metadata user, and ords_administrator_role and ords_runtime_role between each.

Found as that the following versions all install without error, deploy correctly and are usable:

ords-19.4.6.142.1859
ords-20.4.3.050.1904
ords-22.4.4.041.1526
ords-23.1.4.150.1808

However, the following versions all give the same ORA-00600 error in ORDS_SELF_SERVICE_SCHEMA:

ords-23.2.0.177.0931
ords-23.2.1.200.1208
ords-23.2.2.208.1534

Other than the validation script errors at the end of the installation which indicate there is an invalid object, the above quoted ORA-00600 error is the only error related to installation found in the installation log.

Running all of these installs with a privileged user since SYS access to the database is not available. Used the same privileged user with the grants from the 23.2.2 version of ords_installer_privileges.sql for all of these attempts, so this user has the latest privileges applied.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.