#1 Deploy Oracle REST Data Service (ORDS)

What is ORDS ? 

ORDS is a Java application that enables developers with SQL and database skills to develop REST APIs for the Oracle Database, the Oracle Database 12c JSON Document store, and the Oracle NoSQL Database. Any application developer can use these APIs from any language environment, without installing and maintaining client drivers, in the same way they access other external services using the most widely used API technology: REST .  ORACLE site

Required Software: 

1. JDK (download from : https://www.oracle.com/technetwork/java/javaee/downloads/jdk8-downloads-2133151.html )

• install to c:\Program Files\Java

1. Oracle REST (download from : https://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html )
• extract ords.war  to c:\Oracle\ords\ords.war
2. Oracle database  12c or later

How to Enable ORDS ? 

1. Uninstall if exists using :c:\Program Files\Java\jdk1.8.0_152\bin>java -jar c:\Oracle\ords\ords.war uninstall
• Enter required data like SYS password
2. Download a fresh copy of ORDS from : 
3. install using : c:\Program Files\Java\jdk1.8.0_152\bin>java -jar D:\Oracle\ords\ords.war install
• Enter the location to store configuration data: D:\Oracle\ords\conf
• Enter the name of the database server [localhost]: localhost
• Enter the database listen port [1521]: 1521
• Enter 1 to specify the database service name, or 2 to specify the database SID [1]: 1
• Enter the database service name : ORCL
• Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]: 1
• Enter the database password for ORDS_PUBLIC_USER:oracle
• Confirm password:oracle
• Enter the administrator username:SYS *
• Enter the database password for SYS AS SYSDBA:123456
• Confirm password:123456
• 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]: 2
• Enter 1 if you wish to start in standalone mode or 2 to exit [1]: 1
• Enter 1 if using HTTP or 2 if using HTTPS [1]:1
• Enter the HTTP port [8080]:8080

IF you get the following message , this means ORDS is running :

2019-04-28 10:07:46.989:INFO:oejs.Server:main: Started @331997ms

 * Important Notice: You can get this error when installing ORDS:
ords_grant_privs.sql Error: ORA-01031: insufficient privileges
This  is a result of lack of current USER Privileges  even if it was GRANTED DBA permission.
SO , it's very recommended to  use SYS  with a DIGIT password as Oracle ORDS has a built-in Bug which cannot identify passwords letters case.
You changed SYS password  using :
ALTER USER SYS IDENTIFIED BY oracle;
To read more about this bug go here:  https://community.oracle.com/thread/4120820