My Oracle Support Banner

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:

Oracle Database - Enterprise Edition - Version to [Release 19]
Oracle REST Data Services - Version 23.2.2 and later
Information in this document applies to any platform.


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-, 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

  --------- -------------------------------------------------------------
  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:


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


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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