Hi,
using Oracle Enterprise Edition 19.21
tried to install ORDS 23.4.0.r3461619 on a new PDB (APEX 23.1.8 installed):
2024-02-15T09:16:21.440Z INFO The log file is defaulted to the current working directory located at /usr/home/gweber/ords/bin/logs/
2024-02-15T09:16:22.041Z INFO Installing Oracle REST Data Services version 23.4.0.r3461619 in EHS
2024-02-15T09:16:25.071Z INFO ... Verified database prerequisites
2024-02-15T09:16:27.942Z INFO ... Created Oracle REST Data Services proxy user
2024-02-15T09:16:30.999Z INFO ... Created Oracle REST Data Services schema
2024-02-15T09:16:33.235Z INFO ... Granted privileges to Oracle REST Data Services
2024-02-15T09:16:52.836Z INFO ... Created Oracle REST Data Services database objects
2024-02-15T09:17:49.038Z SEVERE Error executing script: ords_verify_install.sql Error: ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.
ORA-06512: at "ORDS_METADATA.VALIDATE_ORDS", line 472
ORA-06512: at line 3
Refer to log file /usr/home/gweber/ords/bin/logs/ords_install_2024-02-15_091621_44480.log for details
Error executing script: ords_verify_install.sql Error: ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.
ORA-06512: at "ORDS_METADATA.VALIDATE_ORDS", line 472
ORA-06512: at line 3
Refer to log file /usr/home/gweber/ords/bin/logs/ords_install_2024-02-15_091621_44480.log for details
Logfile shows validation errors:
INFO: 10:17:27 Validating objects for Oracle REST Data Services.
VALIDATION: 10:17:27 Starting validation for schema: ORDS_METADATA
VALIDATION: 10:17:27 Validating objects
VALIDATION: 10:17:48 WARNING: PACKAGE BODY ORDS_SELF_SERVICE_SCHEMA status is
INVALID.
VALIDATION: 10:17:48 Validating roles granted to ORDS_METADATA and
ORDS_PUBLIC_USER
VALIDATION: 10:17:48 Validating ORDS Public Synonyms
VALIDATION: 10:17:48 INFO: PUBLIC SYNONYM ORDS_HTTP is not in the validation
list.
VALIDATION: 10:17:48 INFO: PUBLIC SYNONYM ORDS_VERSION is not in the validation
list.
VALIDATION: 10:17:48 Total objects: 315, invalid objects: 1, missing objects: 0
VALIDATION: 10:17:48 97 INDEX
VALIDATION: 10:17:48 3 LOB
VALIDATION: 10:17:48 16 PACKAGE
VALIDATION: 10:17:48 15 PACKAGE BODY
VALIDATION: 10:17:48 1 PROCEDURE
VALIDATION: 10:17:48 55 PUBLIC SYNONYM
VALIDATION: 10:17:48 1 SEQUENCE
VALIDATION: 10:17:48 34 TABLE
VALIDATION: 10:17:48 34 TRIGGER
VALIDATION: 10:17:48 16 TYPE
VALIDATION: 10:17:48 6 TYPE BODY
VALIDATION: 10:17:48 37 VIEW
Error starting at line : 31 in command -
begin
dbms_output.put_line('INFO: ' || to_char(sysdate,'HH24:MI:SS') || ' Validating objects for Oracle REST Data Services.');
validate_ords;
dbms_output.put_line('INFO: ' || to_char(sysdate,'HH24:MI:SS') || ' Completed validation for Oracle REST Data Services.');
end;
Error report -
ORA-20006: ERROR: Validating objects failed. ORA-20006: ERROR: ORDS schema database objects contains INVALID status.
ORA-06512: at "ORDS_METADATA.VALIDATE_ORDS", line 472
ORA-06512: at line 3
after checking by hand, ORDS_METADATA.ORDS_SELF_SERVICE_SCHEMA is invalid.
compile manually gives - wait for it -
Body
1702
41
PL/SQL: ORA-00600: internal error code, arguments: [qctbyt : bfc], [65535], [18446744073709551615], [1], [873], [1], [1], [0], [], [], [], []
support.oracle.com says in Doc ID 2972860.1:
SOLUTION
Bug 30874084 is fixed in Database 21.1.
What does that mean?
- i can not use ORDS 23.4 on 19.21
- the installation is finished and i can ignore the error?
- is the installation trustable and i do not get any errors when using in production?
- the installation is kaputt?
thanks & regards