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 19.3.0.0.0 to 19.3.0.0.0 [Release 19]Oracle REST Data Services - Version 23.2.2 and later
Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |