Hi
I try to install ORDS on an OCI-compute instance as standalone, which is connecting to ADB
it keeps complianing about not sufficent privleges, but i cannot use SYS as i don't know the password.
Please help
[oracle@instance-ords oracle]$ ords --config /opt/oracle/conf install
ORDS: Release 23.4 Production on Thu Feb 08 04:56:56 2024
Copyright (c) 2010, 2024, Oracle.
Configuration:
/opt/oracle/conf/
The configuration folder /opt/oracle/conf does not contain any configuration files.
Oracle REST Data Services - Interactive Install
Enter a number to select the type of installation
[1] Install or upgrade ORDS in the database only
[2] Create or update a database pool and install/upgrade ORDS in the database
[3] Create or update a database pool only
Choose [2]: 1
Enter a number to select the database connection type to use
[1] Basic (host name, port, service name)
[2] TNS (TNS alias, TNS directory)
[3] Custom database URL
Choose [1]: /usr/lib/oracle/21/client64/lib/network/admin
Invalid value. Try again.
Enter a number to select the database connection type to use
[1] Basic (host name, port, service name)
[2] TNS (TNS alias, TNS directory)
[3] Custom database URL
Choose [1]: 2
Enter the TNS location: /usr/lib/oracle/21/client64/lib/network/admin
Enter a number to select the TNS Network alias to use
[1] DBPUB_HIGH ...service_name=ge0c282fb07782a_dbpub_high.adb.oracleclou...
[2] DBPUB_LOW ...service_name=ge0c282fb07782a_dbpub_low.adb.oraclecloud...
[3] DBPUB_MEDIUM ...service_name=ge0c282fb07782a_dbpub_medium.adb.oraclecl...
[4] DBPUB_TP ...service_name=ge0c282fb07782a_dbpub_tp.adb.oraclecloud....
[5] DBPUB_TPURGENT ...service_name=ge0c282fb07782a_dbpub_tpurgent.adb.oracle...
Choose [1]: 1
Provide database user name with administrator privileges.
Enter the administrator username: admin
Enter the database password for admin:
Connecting to database user: admin url: jdbc:oracle:thin:@DBPUB_HIGH?TNS_ADMIN=/usr/lib/oracle/21/client64/lib/network/admin
Retrieving information.
Connecting to database user: ORDS_PUBLIC_USER url: jdbc:oracle:thin:@DBPUB_HIGH?TNS_ADMIN=/usr/lib/oracle/21/client64/lib/network/admin
2024-02-08T04:57:35.487Z INFO The log file is defaulted to the current working directory located at /opt/oracle/logs/
2024-02-08T04:57:35.727Z SEVERE ORA-01031: insufficient privileges