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_LISTENERandAPEX_REST_PUBLIC_USERusers 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
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
Responses