Thursday, October 3, 2019

How to Configure ORDS in Apache Tomcat with oracle Apex

1. All folder Create in same directory 
2. Version : apache-tomcat-8.5.11.exe 
                    jre-8u221-windows-x64.exe
                    ords-18.3.0.270.1456.zip

or check apache-tomcat what do want it..

3. All Java/ Apache - Tomcat File Clear from your PC Regedit/  C Drive etc and 

4. Restart PC

Start Now 

 Conn Sys as sysdba

alter user apex_public_user acount unlock;

alter user apex_public_user identified by Databsae#1;

alter user ORDS_PUBLIC_USER identified by Databsae#1;



Open CMD  
Microsoft Windows [Version 10.0.17134.1006]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\AbdulQuium>cd..

C:\Users>cd..

C:\>cd C:\Oracle\Apex_listener     ---Ords Location 

C:\Oracle\Apex_listener>java -jar ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts

Enter the location to store configuration data:C:\Oracle\Apex_listener
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2
Enter the database SID [xe]:orcl
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:

Retrieving information.
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 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
Sep 27, 2019 3:16:10 AM
INFO: reloaded pools: []
Sep 27, 2019 3:16:10 AM oracle.dbtools.rt.config.setup.SchemaSetup install
INFO: Oracle REST Data Services schema version 18.3.0.r2701456 is installed.
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

C:\Oracle\Apex_listener>


///
Open CMD 

Microsoft Windows [Version 10.0.17134.1006]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\AbdulQuium>cd..

C:\Users>cd..

C:\>cd C:\Oracle\apex_19.1\apex

C:\Oracle\apex_19.1\apex>sqlplus sys as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 27 04:32:26 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @apex_rest_config.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Enter a password for the APEX_LISTENER user              []
Enter a password for the APEX_REST_PUBLIC_USER user              []
...set_appun.sql
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users

PL/SQL procedure successfully completed.
........
............

////

OPEN CMD

C:\Oracle\apex_19.1\apex>sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 27 02:53:39 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> start apxconf.sql

      PORT
----------
      8383

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [quium2@gmail.com]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.
Enter a port for the XDB HTTP listener [      8383] 0
...changing HTTP Port




_____________________
star apxconf.sql scripts

enter admin_name email, & password
XDB HTTP listener [8080] :--0

pw : $Abcd_1234
____________________

////


C:\Oracle\Apache_Tomcat_8.5\Tomcat 8.5\webapps\ Paste ORDS.war File
C:\Oracle\apex_19.1\apex\images  all iamges file paste TO
C:\Oracle\Apache_Tomcat_8.5\Tomcat 8.5\webapps\i 

Change 
C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\server.xml

     <Host name="localhost"  appBase="webapps"
            unpackWARs="true" autoDeploy="true">

   <!----image pathname -->
      < Context docBase="C:\apex\images" path="/i" />
     <!----< Context docBase="C:\Oracle\apex_19.1\apex\images" path="/i" /> -->


Check :
Apache tomcat  : http://localhost:8080/
Apex                 : http://localhost:8080/ords

Thanks 
https://www.youtube.com/watch?v=I814NV_dzNs

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...