Install Oracle 12C as Windows Services

It's more professional to make Oracle services start as Windows services , So the end-user is not required to start services every time PC starts.

Moreover It's not user-friendly too.

1.Here's how to Add Weblogic to Windows service :

SETLOCAL
set DOMAIN_NAME=insight
set USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\insight
set SERVER_NAME=AdminServer
set WL_HOME=D:\Oracle\Middleware\wlserver
set PRODUCTION_MODE=true
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
rem *** call "C:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL

Save the file as Install_AdminServer.cmd

just  double click the file to add it to Windows services

2.Here's how to Add WLS_FORMS to Windows service :

SETLOCAL
set DOMAIN_NAME=insight
set USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\insight
set SERVER_NAME=WLS_FORMS
set WL_HOME=D:\Oracle\Middleware\wlserver
set PRODUCTION_MODE=true
set ADMIN_URL=http://localhost:9001
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
rem *** call "C:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL

Save the file as InstallWLS_FORMS.cmd

just  double click the file to add it to Windows services

3.Here's how to Add WLS_REPORTS to Windows service :

SETLOCAL
set DOMAIN_NAME=insight
set USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\insight
set SERVER_NAME=WLS_REPORTS
set WL_HOME=D:\Oracle\Middleware\wlserver
set PRODUCTION_MODE=true
set ADMIN_URL=http://localhost:9002
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
rem *** call "C:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
call "%WL_HOME%\server\bin\installSvc.cmd"
ENDLOCAL

Save the file as InstallWLS_REPORTS.cmd

just  double click the file to add it to Windows services

UPDATE :  Reports Server is nolonger available according to Oracle site link 

UPDATE :  Some services might not work because After Windows 10 updates and  it may ask for of Node manager , so we need to start up Node Manger too.

4.Here's how to Add Node Manger to Windows service :
Go to D:\Oracle\Middleware\user_projects\domains\insight\bin\installNodeMgrSvc.cmd

You can manage services from :

Start Menu -> Run -> services.msc

Oracle services start with wlsvc...

Access Report Server 12C

Sometimes when browsing to http://localhost:9002/reports/rwservlet/showjobs  , It prompts you to enter User Name and Password.

To prevent such prompts:

1. open Web Browser then Goto :
   http://localhost:9002/reports/rwservlet/showjobs
2. If you prompted to enter User name and Password , then
   ** Stop WLS_REPORTS
   ** Edit  rwserver.conf in this path :D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf** Remove line which has SECURITY
   ** Remove
   word Security_Id
   ** Remove
   securityId="rwJaznSec"
   ** Save and restart WLS_REPORTS

Also if When logging to localhost:9002/reports cannot login

 It may be as a result of SSL , so you do have 7002 instead of  9002.

Configure Oracle 12C - Dual-Language interface Step-7

To Configure Oracle 12c Dual-Language Layout

1. In the Upper Left ,click the navigation Menu beside insight(server name)
   It expands to display, multiple components ,
   expand Forms , click forms1
2. In Upper left , click Forms then click Web Configuration
   In Upper right  , click yellow LOCK key
   Select  Lock & Edit
3. Select Default  , then press Create Like to make English Interface :
   *New Section Name :EN
   then press Create
4. After you finish , click APPLY,
   click yellow LOCK key
   select APPLY changes
5. Select EN , then in Upper right  , click yellow LOCK key
   Select  Lock & Edit
6. In the mid-left  of the page at the Section : default 
   change Show to: all
7.  Change the following PARAMETER VALUES:
   envFile : EN.env
   form : login.fmx
8. After you finish , click APPLY,

click yellow LOCK key

select APPLYchanges

Configure Oracle 12C - Reports Step-6

Oracle 12C Reports Configurations

Open Internet Browser  and goto: http://localhost:7001/em
Enetr Username: weblogic
Password:OrAcLe_2016

click SIGN IN

1.  In the Upper Right ,click Weblogic Domain
   It expands to display, multiple componnets ,
   click System MBean Browser
2. on the System MBean Browser page :
   expand    : oracle.reportsApp.config
   then     : Server: WLS_REPORTS
   then    : Application: reports
   then      : ReportsApp
3. Select rwservlet on  the right  Application Defined MBeans: ReportsApp:rwservlet :
   Change the following
   PARAMETER                     VALUES:
   WebcommandAccess L2
   allowhtmltags yes
   server                       Insight_Rep_Srvr
4. After you finish , click APPLY

ReportsApp:rwserver

1. From the left menu , choose rwserver
   ** from the right Application Defined MBeans: ReportsApp:rwserver
2. Choose Operations tab :
   click addEnvironment
   Value : AR
   click Invoke
3. on the same page modify AR to EN
   click Invoke
4. on the upper right , click Refresh circle arrow
5. on the left menu , expand ReportApp.Environment , you should find AR , En  variables
6. On the left menu , expand ReportApp Engine (Application Defined MBeans:ReportsApp.Engine:rwURLEng):
   click rwURLEng
   change Value of DefaultEnvId                   : EN
   change Value of JvmOptionsJvmOptions: -Xmx1024m (to avoid REP-69 : Java heap space)
7. After you finish , click APPLY,
8. On the left menu , expand ReportApp Engine (Application Defined MBeans: ReportsApp.Engine:rwEng):
   click rwEng
   change Value of DefaultEnvIdDefaultEnvId : AR
9. After you finish , click APPLY

Apply Arabic Display (Right to Left) :

1. on the left menu , expand ReportApp.Environment :
   click AR
2. Choose Operations tab :
   click addEnvVariableValue
   NLS_LANG  ARABIC_EGYPT.AR8MSWIN1256click Invoke
3. on the same page Change existing Value to  USER_NLS_LANG
   click Invoke
4. on the same page modify 
   Change existing Value to  REPORTS_TMP
   next line Value : C:\TMP
   click Invoke
5. Goto C:\ and create TMP Folder
6. on the same page modify 
   Change existing Value to  : REPORTS_BIDI_ALGORITHM
   with new line value : UNICODE
   click Invoke
7. on the same page modify 
   Change existing Value to  : REPORTS_ENHANCED_BIDIHANDLING
   with new line value : Yes
   click Invoke
8. on the same page modify 
   Change existing Value to  : REPORTS_ARABIC_NUMERAL
   with new line value : HINDI
   click Invoke
9. on the same page modify 
   Change existing Value to  : REPORTS_PATH
   with new line value : D:\Oracle\Middleware\reports\templates;D:\Oracle\Middleware\reports ; \printers;c:\Windows\Fonts;d:\WorkArea\REPORTS;
   click Invoke**open Regedit,  add the same path to the following KEY:
   HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OracleHome1\REPORTS_PATH

Apply English Display (Left to Right) :

1. On the left menu , expand ReportApp.Environment :
   click EN
2. Choose Operations tab :
   click addEnvVariable
   Value
   NLS_LANG  AMERICAN_AMERICA.AR8MSWIN1256click Invoke
3. on the same page Change existing Value to  USER_NLS_LANG
   click Invoke
4. On the same page Change existing Value to  REPORTS_TMP
   next line Value        :C:\TMP
   click Invoke
5. On the same page Change existing Value to : REPORTS_ARABIC_NUMERAL
   with new line value : ARABIC
   click Invoke
6. on the same page modify 
   Change existing Value to  : REPORTS_PATH
   with new line value : D:\Oracle\Middleware\reports\templates;D:\Oracle\Middleware\reports ; \printers;c:\Windows\Fonts;d:\WorkArea\REPORTS;
   click Invoke
   **open Regedit,  add the same path to the following KEY:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OracleHome1\REPORTS_PATH
7. On the same page modify 
   Change existing Value to  : REPORTS_BIDI_ALGORITHM
   with new line value         : UNICODE
   click Invoke
8. On the same page modify 
   Change existing Value to  : REPORTS_ENHANCED_BIDIHANDLING
   with new line value         : Yes
   click Invoke

Fixing Arabic Font doesn't display :

Replace uifont.ali in the following paths with attached uifont.ali:

1. D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\ReportsToolsComponent\INSIGHT_Rep_Tools\tools\COMMON
2. D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\ReportsToolsComponent\INSIGHT_Rep_Tools\guicommon\tk\admin

you're done :-)

 

Update #1: 

• Open Registry --> TK_PATH  ( C:\oracle\Middleware\tools\common )
• add uifont.ali file 
  

Update #2 : 

How To Access http://localhost:9002/reports/rwservlet/showjobs , it's very useful to see jobs queue , showenv, serverinfo etc....

1.  open Web Browser then Goto :  http://localhost:9002/reports/rwservlet/showjobs
2. If you prompted to enter User name and Passwrod , then
• Stop WLS_REPORTS
• Edit  rwserver.conf in this path
  D:\Oracle\Middleware\user_projects\domains\SitKSA\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf
• Remove line which has SECURITY
• Remove   word : Security_Id 
• Remove  securityId="rwJaznSec"
• Save and restart WLS_REPORTS
3. REP-52262: Diagnostic output is disabled.
• FIX Web Webcommandaccess
4. When logging to localhost:9002/reports cannot login?
• It may be as aresult of SSL , so you do have 7002 & 9002

Configure Oracle 12C - Webutil Step-5

Download The attached folder  from here .

1. From the downloaded Folder Copy theses files :  jacob.jar , ffisamp.dll  , jacob-1.18-M2-x86.dll
   to : D:\Oracle\Middleware\forms\java
2. Make sure you have installed  JDK8u151 (download from oracle )
3. Open Internet Explorer and goto : http://localhost:9001/forms/frmservlet** You should have [ Installed successfully ] message
4. In Upper left , click Forms then click Web ConfigurationIn Upper right  , click yellow LOCK key
   Select  Lock & Edit
5. In the mid-left  of the page at the Section : default
   change Show to: all
6. Change the following PARAMETER VALUES
   baseHTML : webutilbase.htm
   baseHTMLjpi : webutiljpi.htm
7. After you finish , click APPLY,
   click yellow LOCK key
   select Apply changes
8. In upper left , click the Add symbol to add parameter:
   PARMETER NAME VALUE
   WebUtilArchive         frmwebutil.jar,jacob.jar
   WebUtilLogging         off
   WebUtilLoggingDetail         normal
   WebUtilErrorMode Alert
   WebUtilDispatchMonitorInterval 5
   WebUtilTrustInternal         true WebUtilMaxTransferSize             16384

Bugs and Fixes :

When runing form includes WEBUTIL , You may face any of :

bean not found. WEBUTIL_FILE_TRANSFER.getMaxTransfer will not work ,WUT-121 File transfer error,etc

You can fix by Making sure following steps are done:

1. Goto Control Panel --> Java -->Security --> Edit Sites List --> then add full address of your application, then restart browser
2. Goto Control Panel --> Java -->General--> Settings -->Delete Files then check all,then restart browser
3. Delete webutil.ABUOUF.32.PROPERTIES  << it's located in : C:\Users\Administrator >> , then retest (to download Webutil files again)
4. Open Internet explorer --> Tools --> Options --> General --> Delete check all, then Apply , Ok, then restart browser
5. Make sure the CLIENT current Windows User is ADMINISTRATOR
6. edit webutil.cfg as followed<< which is located in :
   D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\FORMS\instances\forms1\server\webutil.cfg>>

transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
transfer.appsrv.workAreaRoot=c:\srvr
transfer.appsrv.accessControl=FALSE
#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=c:\TEMP
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=c:\srvr

Configure Oracle 12C - Starting Services Step-3

1.Start Node Manager:

After Creating Domain goto 

D:\Oracle\Middleware\user_projects\domains\insight\bin\startNodeManager.cmd

If you got message: 

<Secure socket listener started on port 5556 , host localhost/127.0.0.1>

then  you are right

2.Weblogic :

D:\Oracle\Middleware\user_projects\domains\insight\bin\startWebLogic.cmd

enter Weblogic server User name & Password

Once server state changed to RUNNING 

You are right

3.Weblogic (EM) :

1. Open Internet Browser  and goto: http://localhost:7001/emEnetr Username: weblogic
   Password:
   click SIGN IN
2. In the Upper Left ,click the navigation Menu beside insight(server name)
   It expands to display, multiple componnets ,
   expand HTTP Server, then click ohs1
3. Under Servers part in middle of page :
   Click on WLS_FORMS wait until it loads..... click start Up --upper left
4. wait until it loads.....click start Up --upper left
5. Once Oracle HTTP Server  started successfully:
   Browse to : C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle FMW 12c Domain - insight- 12.2.1.3.0** send  following Shortcuts to Desktop:
   Start Node Manager
    Stop Node Manager
   Start Weblogic Admin Server
   Stop Weblogic Admin Server
6. Inside folder Oracle Forms Services - WLS_FORMS :
   ** Send the following shortcuts to Desktop :
   Start Weblogic Server - WLS_FORMS
   Stop Weblogic Server - WLS_FORMS
   ** Make a Copy of these shortcuts on the Desktop :
   Start Weblogic Server - WLS_FORMS  and RENAME it to Start Weblogic Server - WLS_REPORTS
   Stop Weblogic Server - WLS_FORMS and RENAME it to  Stop Weblogic Server - WLS_REPORTS
   ** Change properties of  Start Weblogic Server - WLS_REPORTS  file :
   Target :D:\Oracle\Middleware\user_projects\domains\insight\bin\startManagedWebLogic.cmd WLS_REPORTS** Change properties of  Stop Weblogic Server - WLS_REPORTS  file :
   Target:D:\Oracle\Middleware\user_projects\domains\insight\bin\stopManagedWebLogic.cmd WLS_REPORTS
7. Run  : d:\Oracle\Middleware\oracle_common\common\bin\wlst.cmd
8. Wait until it loads.... , then type:connect ("weblogic" , "OrAcLe_2016" , "localhost:7001")
   --where "weblogic" is Server Name and "OrAcLe_2016" is the password press Enter to connect to Weblogic 
9. Create reports tools by typing the following code [ becareful as it's case-sensitive] :
   createReportsToolsInstance(instanceName='insight_Reports_Tools'  ,  machine='AdminServerMachine')press Enter
   ****** files must be created in this path
   D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\ReportsToolsComponent\***********************************************************
   Name Report  Server Name by typing the following code [ becareful as it's case-sensitive] :
   createReportsServerInstance(instanceName="Insight_Rep_Srvr", machine="AdminServerMachine")
   press Enter
10. Once you are finished , exit by typing:
    exit()
11. Stop all services now  from STOP shortcuts on the desktop , Enter User name and password if required
12. Open Notepad and type the following  and save file as boot.properties :
    username=weblogic
    password=OrAcLe_2016
13. Copy the boot.properties file to these destinations:
    ** D:\Oracle\Middleware\user_projects\domains\insight\servers\AdminServercreate folder : security
    Paste boot.properties file here and in the following folders too:
    D:\Oracle\Middleware\user_projects\domains\insight\servers\WLS_FORMS\securityD:\Oracle\Middleware\user_projects\domains\insight\servers\WLS_REPORTS\securityNow , you can run Weblogic , Forms and Reports too without inserting User Name even Password.
14. Goto :D:\Oracle\Middleware\user_projects\domains\insight\reports\bin\rwbuilder.batsend it as a shortcut to Desktop to run report Builder 
15. To change Icon , Goto : 
    D:\Oracle\Middleware\binand choose rwbuilder

Configure Oracle 12C - Create Domain Step-2

Create Domain:

1. Goto:D:\Oracle\Middleware\oracle_common\common\bin\config.cmd
2. Create a new domain : name it as insight (D:\Oracle\Middleware\user_projects\domains\insight) click NEXT
3. Select the following Templates

* Oracle Forms Application Deployment Service(FADS)-12.2.1.3.0[forms]

* Oracle Forms -12.2.1.3.0[forms]

* Oracle Reports Application-12.2.1[reports]

* Oracle Enterprise Manager-12.2.1.3.0[em]

* Oracle HTTP Server (Collaocated) -12.2.1.3.0[ohs]

* Oracle Reports Server -12.2.1 [ReportsServerComponent]

* Reports Bridge -12.2.1 [reportsBridgeComponenet]

* Oracle  WSM Policy Manager -12.2.1.3 [oracle_common]

* Oracle JRF - 12.2.1.3.0 [oracle_forms]

* WebLogic Coherence Cluster Extension - 12.2.1.3.0 [wlserver] click NEXT

4.Click NEXT

5.Enter weblogicuser name                      :   insight

                           Password               : insight123456

                            Confirm Password : insight123456  ,click NEXT

6.Select Domain Mode : Production ,click NEXT

7.Eneter  Host Name            :localhost

         DBMS/Service      : IAS  --the name of Database

           Schema Password : insight123456

click : Get RCU Configuration

if it's successfully done , then

click NEXT

8.On JDBC Component Schema  click NEXT

9.On JDBC Component Schema  Test , wait until end of Test

 click NEXT

10.On Advanced Configuration  :

Check  Only the following 3 items:

* Administration Server

* Topology

* System Components ,click NEXT

11.On Administration Server :

Check Enable SSL

Server Groups: WSMPM-MAN-SVR --it's the last one in drop-down list,click NEXT

12.On Managed Servers  , You do have : 

WLS_FORMS

WLS_REPORTS , click NEXT

13.On Clusters  , You do have : 

cluster_forms

cluster_reports , click NEXT

14.On Server Template page, just click  NEXT

15.On Dynamic Servers, You do have : 

cluster_forms 

cluster_reports , click NEXT

16.On Assign Servers to Clisusters , just click  NEXT

17.On Coherence Clusters , just click  NEXT

18.On Machines , just click  NEXT

19.On Assign Servers to Machines :

Add the  left AdminServer TO the right Machines 

Click on the right AdminServerMachine, Then  

Click the small arrow in the middle of screen , click  NEXT

20.On  Virtual Targets , just click NEXT

21.On  Partitions , just click NEXT

22.On System Components 

add  component: ohs

--from upper left on the screen Click the Green Add icon

-- Change new_SystemComponent_1 to : ohs1

--Select OHS from Component Type List , click NEXT

23.On OHS Server, Just click NEXT

24.On Domain Frontend Host , Just click NEXT

25.On Assign System Components to Machines :

Add ohs1 to the right Machines , click NEXT

26.On OHS Server:

enter in Listen Address: localhost

        click NEXT

27.On Deployments Targeting , just click NEXT

28.On ServicesTargeting , just click NEXT

29.On Configuration Summary , just click Create

30.On Configuration Progress , wait until it finishes

Once it's finished Click NEXT, then Finish

Congrats , you are done...... [next step is to run Node Manager]

UPDATE : If it config.cmd  does not load  , then remove all instaled JAVA (containing JDK&JRE and install other version) in my case I removed jdk-8u152-windows-x64 and installed jdk-8u181-windows-x64 .

This happened when I dropped then reCreate the RCU . That RCU was firstly created using the version of jdk-8u181-windows-x64 .

Configure Oracle 12C - RCU Step-1

Install the following software :

1.  Oracle DB 12c download link , Here's another link Archive.org
2. Forms and Reports 12.2.1.3.0  download link
3. Fusion Middleware Infrastructure installer  12.2.1.3 download link
4. Java 8u152 version(jdk-8u152-windows-x64) download link

Then start the RCU as followed.

After installation ,Create Repository using Repository Creation Utility (RCU):

1. GOTO D:\Oracle\Middleware\oracle_common\bin\rcu.bat
2. Enter required Credentials
3. Select  ALL : ORACLE AS Repository Components

Note, You can drop an existing  DOMAIN , by following these simple steps :

1. Goto D:\Oracle\Middleware\domain-registry.xmland delete the line contains Domain Name
2. Delete the folder D:\Oracle\Middleware\user_projects\applications\insight
3. Delete the folder D:\Oracle\Middleware\user_projects\domains\insight
4. Delete the file:  D:\Oracle\Middleware\user_projects\domains\insight\servers\AdminServer\tmp\AdminServer.lok

Before Starting install Forms &Reports and Fusion:

• Both of  Fusion and Forms&Reports must have the same version
• Install Fusion First then install Forms&Reports 
• Forms&Reports  are downloaded in two zipped folders, so extract first one (larger than 1.5GB) and keep the other (small zip file) inside extracted folder as the following image

Create nested JSON Array

To query all EMPLOYEES below the main Departments , and get the result in JSON format .

Connect using SCOTT user

Following are steps:
#1 Create GET method
Type : QUERY
Pagination Size: 0

#2 Add the following code :

SELECT G.Deptno,
       G.DName,
       CURSOR ( SELECT V.Empno, 
                       V.Ename
                FROM   EMP V 
       WHERE  V.Deptno = G.Deptno )  EMPLOYEES
FROM   DEPT   G

Here's the output in PLSQL/Develoepr

#9 REST Standalone batch

To Run  ORDS ,REST services must be up all time.
This can be achieved by running ORDS in standalone, deploying on Weblogic, using Apache tomcat...etc

To run ORDS in standalone mode go to this previous post 
  Here's tiny batch file to manually starting ORDS service :

1. Suppose you have installed  JDK in the path : c:\Program Files\Java\jdk1.8.0_152\bin>java
2. And you downloaded ORDS, and extracted to : d:\Oracle\ords\ords.war
3. Open Notepad and add the following code :

@echo off




CD c:\Program Files\

CD Java\jdk1.8.0_152\bin\

CALL java -jar D:\Oracle\ords\ords.war

pause

4. Save file as : Start_ORDS.bat

you are done, To run ORDS anytime you just double click this Start_ORDS.bat file

That's all it.

#7 Your first DELETE RESTful Service

Here's the case we'll work on using the following example:
The case is : How to Delete specific data from EMP_TABLE  using API ?

The Fix: Using DELETE method
Before You Begin: In contrast to GET methods,  all of POST,PUT and DELETE methods   require third party editor to run .
There are many applications for this purpose, you can install any of them using Google Chrome web store  .
YARC may be the simplest one to use , you can download it from here .

1. Using PLSQL copy the following code:

BEGIN
  -----------------
  ORDS.DEFINE_MODULE(P_Module_Name    => 'emp',
                     P_Base_Path      => 'emp_data',
                     P_Items_Per_Page => 0);
  -----------------
  ORDS.DEFINE_TEMPLATE(P_Module_Name => 'emp', 
                       P_Pattern     => 'dml/:id');
  -----------------
  ORDS.DEFINE_HANDLER(P_Module_Name    => 'emp',
                      P_Pattern        => 'dml/:id',
                      P_Method         => 'DELETE',
                      P_Source_Type    => 'plsql/block',
                      P_Source         => 'BEGIN 
                                           DELETE FROM EMP_TABLE
                                                 WHERE Id   = :id;
                                           COMMIT;
                                           :P_Status := SQLERRM;
                                           END;',
          p_mimes_allowed  => '',
          P_Items_Per_Page => 0);
  -----------------
  ORDS.DEFINE_PARAMETER(P_Module_Name        => 'emp',
                        P_Pattern            => 'dml/:id',
                        P_Method             => 'DELETE',
                        p_name               => 'id',
                        p_bind_variable_name => 'id',
                        p_source_type        => 'HEADER',
                        p_param_type         => 'INT',
                        p_access_method      => 'IN');   
  -----------------
  ORDS.DEFINE_PARAMETER(P_Module_Name        => 'emp',
                        P_Pattern            => 'dml/:id',
                        P_Method             => 'DELETE',
                        p_name               => 'P_Status',
                        p_bind_variable_name => 'P_Status',
                        p_source_type        => 'RESPONSE',
                        p_param_type         => 'STRING',
                        p_access_method      => 'OUT');
  -----------------
  COMMIT;
  -----------------
END;

In This POST Request:

• Employee Id = 1  was DELETED from  EMP_TABLE
• P_Status Parameter defined to return message after inserting data

To run POST request :

1. Click YARC extension from google chrome
2. In the URL add: http://localhost:8080/ords/trest/emp_data/dml/1
3. Choose from the list : DELETE

Once you have finished, click Send Request.

you should get reply of  200 and the following message: 

 {
  "P_Status": "ORA-0000: normal, successful completion"
}

In the next post, we'll export all REST Defined Services

#4 Your first GET RESTful Service

Here's the case we'll work on using the following example:
The case is : How to Fetch specific data from EMP_TABLE  using API ?
The Fix: Using GET method

1. Using PLSQL copy the following code:

BEGIN
  -----------------
  ORDS.DEFINE_MODULE(P_Module_Name    => 'emp',
                     P_Base_Path      => 'emp_data',
                P_Items_Per_Page => 0);
  -----------------
  ORDS.DEFINE_TEMPLATE(P_Module_Name => 'emp', 
                       P_Pattern     => 'dml/:P_Emp_Id');
  -----------------
  ORDS.DEFINE_HANDLER(P_Module_Name    => 'emp',
                      P_Pattern        => 'dml/:P_Emp_Id',
        P_Method         => 'GET',
        P_Source_Type    => Ords.Source_Type_Collection_Feed,
        P_Source         => 'SELECT * FROM EMP_TABLE WHERE Id = :P_Emp_Id',
        P_Items_Per_Page => 0);
  -----------------
  ORDS.DEFINE_PARAMETER(P_Module_Name        => 'emp',
                        P_Pattern            => 'dml/:P_Emp_Id',
                        P_Method             => 'GET',
                        p_name               => 'P_Emp_Id',
                        p_bind_variable_name => 'P_Emp_Id',
                        p_source_type        => 'HEADER',
                        p_param_type         => 'INT',
                        p_access_method      => 'IN');   
  COMMIT;
  -----------------
END;
/

You now have created your first REST API , the URL IS: http://localhost:8080/ords/trest/emp_data/dml/1

To get Employee Number 1 , add 1 at the end of URI

#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