How to Install ORDS 3.0.9.348.07.16

Things to check first.

1. check you init.ora file has an entry remote_login_passwordfie.
2. loin into sql and check your param at sql prompt show param remote_login.
3. create orapwSID file, It should locate ORACLE_HOME/dbs
4. select * from v$pwfile_users. you will get one row selected.
5 . Refer ORACLE TEST Data Services Install and config Guide E56293-11

/uo1/scratch/ords

webserver$/u01/product/jdk80121/bin/java -jar test_ebs.war install advanced

This Oracle REST Data Services instance has not yet been configured.

Please complete the following prompts

Enter the location to store configuration data:/u01/scratch/ords/config

Enter the name of the database server [localhost]:servername

Enter the database listen port [1521]:0000

Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2

Enter the database SID [xe]:SID

Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:

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 the default tablespace for ORDS_METADATA [SYSAUX]:    

Enter the temporary tablespace for ORDS_METADATA [TEMP]:

Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:

Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:

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 PL/SQL Gateway database user name [APEX_PUBLIC_USER]:XXX_ORDS

Enter the database password for XXX_ORDS:

Confirm password:

Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:2

May 26, 2017 12:51:26 PM 

INFO: Updated configurations: defaults, apex, apex_pu

Installing Oracle REST Data Services version 3.0.9.348.07.16

... Log file written to /apps2/scratch/ords/logs/ords_install_core_2017-05-26_125126_00397.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 /u01/scratch/ords/logs/ords_install_datamodel_2017-05-26_125148_00039.log

Completed installation for Oracle REST Data Services version 3.0.9.348.07.16. Elapsed time: 00:00:23.509

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

$

Verify your configuration directory

$/u01/product/jdk80121/bin/java -jar test_ebs.war configdir      

May 26, 2017 12:55:07 PM 

INFO: The config.dir value is /u01/scratch/ords/config

Depoly war file in weblogic