Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Simple installation of ORDS

Eslam_ElbyalyAug 25 2023

Hi. I am following the documentation https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/20.2/aelig/installing-REST-data-services.html#GUID-831F6EBD-C044-44F4-A4A0-5BE7B3A8018A to execute a simple installation of ORDS 20.2.1.227 with APEX 21.1 and Oracle db 18c XE on Windows 7 64 bits.

I am on a virtual machine(VirtualBox).

I modified the ords_params.properties file in params folder and now it has the following parameters…

#fri Nov 20 19:59:59 EET 2020
#That's the original file after modifying and adding what I needed.
database.api.enabled=true
db.connectionType=basic
db.hostname=localhost
db.password=MyPassword
db.port=1521
db.servicename=XEPDB1
db.username=APEX_PUBLIC_USER
plsql.gateway.add=true
rest.services.ords.add=true
standalone.http.port=8080
standalone.mode=true
standalone.static.images=d\:/ords/images
user.apex.listener.password=MyPassword
user.apex.restpublic.password=MyPassword
user.public.password=MyPassword

First problem I have is that I do not know the name of the parameter that would tell where the config files will be stored. For example, the synonym for “configdir” command.

2- The parameter of the Username and password of the user with ORDS Installer privileges or with SYS AS SYSDBA account.

3- I face error,

“No provider found for: requires oracle.dbtools.common.pools.legacy.ConfigurationFilesProvider”

That's how I start installation…

  • I open CMD and move to the ORDS folder which has the ords.war file, then issue the command
java -jar ords.war
or
java -jar ords.war install simple
Comments
Post Details
Added on Aug 25 2023
17 comments
877 views