-
On the Apache Tomcat server, download Oracle Rest Dataservices to c:\tmp.
-
Extract ords.xx.x.x.xx.xxxx.zip to <apache_home> folder.
For example:
ords-19.4.6.142.1859.zip or the latest version.
<apache_home>: c:\apache
-
Create a ords_config directory to store ORDS configuration data in <apache_home>\<ords_config>.
-
Open a Command Prompt window as an administrator.
-
Perform the following steps to deploy Apache Tomcat:
-
Navigate to <apache_home>\<ords.version> in Windows Explorer.
-
Rename the file ords.war to apex.war.
-
Copy the file apex.war from the <apache_home>\<ords.version> directory to the <apache_home>\webapps\ directory.
-
-
Change directory to <apache_home>\webapps\.
For example: C:\Apache\webapps
-
Execute the following command:
Run: java -jar apex.war install advanced
-
Enter the following information:
-
Location to store configuration: <apache_home>\ords_config
-
Database connection type to use: Type 1
-
Name of the database server [local host]: <your_database_server>
-
Database listen port [1521]
-
Database service name
-
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]
-
Database password for ORDS_PUBLIC_USER
-
Database password for SYS AS SYSDBA
-
Confirm the password
-
Default tablespace for ORDS_METADATA [SYSAUX]: Select default [sysaux]
-
Temporary tablespace for ORDS_METADATA [TEMP]: Select default [temp]
-
Default tablespace for ORDS_PUBLIC_USER [USER]: Select default [users]
-
Temporary tablespace for ORDS_PUBLIC_USER [TEMP]: Select default [temp]
-
If using Oracle Application Express or ......: Type 1
-
PL/SQL Gateway database user name [APEX_PUBLIC_USER]: Select the APEX_PUBLIC_USER.
-
Database password for APEX_PUBLIC_USER
-
Confirm password
-
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) ...: Type 1
-
Enter the database password for APEX_LISTENER
-
Confirm password
-
Database password for APEX_REST_PUBLIC_USER
-
Confirm password
-
Enter a number to select a feature to enable ... : Type 3
-
Enter 1 if you wish to start in standalone mode or 2 to exit: Type 2
-
-
Start SQLPLUS and connect as SYS user.
-
Unlock all APEX and ORDS accounts and set the passwords as configured above (replace <..._password> accordingly):
alter user apex_rest_public_user identified by <apex_rest_user_password>;
alter user ords_public_user identified by <ords_public_user_password>;
alter user apex_public_user identified by <apex_public_user_password>;
alter user apex_listener identified by <apex_listener_password>;
alter user apex_rest_public_user account unlock;
alter user ords_public_user account unlock;
alter user apex_public_user account unlock;
alter user apex_listener account unlock;
-
Check the configuration files at <apache_home>\<ords_config>\apex.
There should be defaults.xml.
These files should be in the conf subfolder:
-
Apex.xml
-
apex_al.xml
-
apex_pu.xml
-
apex_rt.xml
-
-
Restart the TOMCAT service.
-
Open the following URL in a browser:
http://<servername>:9090/apex
If problems occur, see Troubleshooting.