Have ORDs 24.4 running with multiple connection pools. I want to change the "default" connection pool to connect to a new database. I tried running "ords install" and selecting the default connection pool but it does not give me the option to change the database connection details. It only asks for the db user/pw and checks the installed version of ORDs.
I was told elsewhere that I could manually alter the connection details and run “ords install”, select the “default” pool and ORDs would detect the missing install and run the install process. This does not happen. Instead I got the following error message:
PDB BLAH - Error, the ORDS schema version does not exist. This may be due to a previous ORDS installation failure.
You will need to do the following to reinstall ORDS in the database:
- Uninstall ORDS and then install ORDS in the database.
See Oracle REST Data Services documentation on how to uninstall ORDS from the database and install ORDS again.
I tried “ords install repair” as well and got the same result.
I tried “ords uninstall” and got the following error:
Uninstalling Oracle REST Data Services in BLAH
Error executing script: ords_alter_session_script.sql Error: ORA-20017: ERROR: Cannot set _ORACLE_SCRIPT parameter. ORA-02097: parameter cannot be modified because specified value is invalid
ORA-06512: at line 20
I assume this is because it has never been installed on the new database.
How can I change the default database?