Oracle REST Data Services (ORDS) Configuration on Tomcat

• Step 1: Disable HTTP access

Connect as SYS and disable the Oracle XML DB HTTP server by temporarily setting the HTTP port to zero (if it’s already zero, then it’s not enabled):

SELECT dbms_xdb.gethttpport FROM dual;

EXEC dbms_xdb.sethttpport(0);

• Step 2: Make a directory to hold the configuration.

$ mkdir -p $ORACLE_HOME/ords/conf

• Step 3: Edit the "$ORACLE_HOME/ords/params/ords_params.properties" file provided with the ORDS software, setting the appropriate parameters for your installation. In this case my file contents were as follows. 

db.hostname=prodasm
db.port=1521
db.servicename=orcl
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
plsql.gateway.add=false
rest.services.apex.add=false
rest.services.ords.add=true
schema.tablespace.default=SYSAUX
schema.tablespace.temp=TEMP
standalone.http.port=8080
standalone.mode=false
user.public.password=@05447824237977126F9604299904956C8D8DD53735F0F1BD53
user.tablespace.default=USERS
user.tablespace.temp=TEMP

• Step 4: Use the "ords.war" file to specify the configuration directory using the following command

$ $JAVA_HOME/bin/java -jar ords.war configdir <patch of oracle home>/ords/conf

• Step 5: Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.

SQL> @apex_rest_config.sql 

• Step 6: You should have the following three accounts for the RESTFul Service in the Oracle DB

Three accounts have been created:

APEX_PUBLIC_USER
APEX_LISTENER
APEX_REST_PUBLIC_USER

Login as sys to the Oracle DB, run the following statement to check:

select username,account_status from dba_users where USERNAME IN ('APEX_PUBLIC_USER', 'APEX_LISTENER', 'APEX_REST_PUBLIC_USER');

Account must be open . If account is expired and Locked then unlock using below command.

ALTER USER APEX_LISTENER IDENTIFIED BY Anup#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Anup#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY Anup#123 ACCOUNT UNLOCK;

• Step 6: Configure ORDS using the following command. 

$ $JAVA_HOME/bin/java -jar ords.war

• Step 7: Verify deployed ORDS in standalone mode 

$ $JAVA_HOME/bin/java -jar ords.war standalone

Launch to http://host:port:8080 if successfully launch then it's OK 

• Step 7: Tomcat Deployment

Copy the APEX images to the Tomcat "webapps" directory.

$ mkdir $TOMCAT_HOME/webapps/i/
$ cp -R <------>/apex/images/* $TOMCAT_HOME/webapps/i/

Copy the "ords.war" file to the Tomcat "webapps" directory.

$ cd <------>/ords
$ cp ords.war $TOMCAT_HOME/webapps/

ORDS should now be accessible using the following type of URL.

http://<server-name>:<port>/ords/

• Step 8: Starting/Stopping ORDS Under Tomcat

$ $TOMCAT_TOME/bin/startup.sh
$ $TOMCAT_HOME/bin/shutdown.sh