MAKE DIRECTORY:
mkdir /u01/ords
cd /u01/ords
unzip ords.3.0.9.348.07.16.zip
sqlplus / as sysdba
select value from v$parameter where name like ‘%service_name%’;
cp ords.war ords.war_bkp
mv ords.war apex.war
BACKUP THE PARAMETER FILE:
cp /u01/ords/ords_params.properties /u01/ords/ords_params.properties_bkp
>/u01/ords/ords_params.properties
EDIT THE PARAMETER FILE:
vi /u01/ords/ords_params.properties
db.hostname=hostname
db.port=port value
db.servicename=service name
db.sid= database sid
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=APEX
schema.tablespace.temp=TEMP
standalone.http.port=8081
standalone.static.images=
user.tablespace.default=APEX
user.tablespace.temp=TEMP
CONFIGURE THE ORDS DIRECTORY:
export JAVA_HOME=/usr/java/jdk1.7.0_79
$JAVA_HOME/bin/java -jar apex.war configdir /u01/ords/conf
$JAVA_HOME/bin/java -jar ords.war
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Please login with SYSDBA privileges to verify Oracle REST Data Services schema.
Enter the username with SYSDBA privileges to verify the installation [SYS]:
Enter the database password for SYS:
Confirm password:
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Jan 13, 2017 3:49:56 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 3.0.9.348.07.16
… Log file written to /u01/ords/FILENAME.LOG
… Verified database prerequisites
… Created Oracle REST Data Services schema
… Created Oracle REST Data Services proxy user
… Granted privileges to Oracle REST Data Services
… Created Oracle REST Data Services database objects
… Log file written to <LOCATION>
Completed installation for Oracle REST Data Services version 3.0.9.348.07.16. Elapsed time: 00:03:30.673
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
Start and Stop ORDS:
cd /u01/ords
$JAVA_HOME/bin/java -jar ords.war standalone
It will capture the console and push all log information to it. You can stop ORDS using CTRL+C.
