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:
How to Enable 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:
- JDK (download from : https://www.oracle.com/technetwork/java/javaee/downloads/jdk8-downloads-2133151.html )
- install to c:\Program Files\Java
- 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
- Oracle database 12c or later
How to Enable ORDS ?
- 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
- Download a fresh copy of ORDS from :
- 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
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
* 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