Saturday, July 6, 2019

How to install ORDS and tomcat for Oracle Apex



Apex + ORDS + Tomcat

1 - Download ORDS and apache tomcat (Search in google.)
2 - Copy ORDS to c:\ and extract. and rename to ords.
3 - Rename ords.war to noorbd.war
4 - Create a folder config in c:\ords

java -jar noorbd.war

Enter the location to store configuration date: c:\ords\config

Enter the name of the database server [Localhost]: Enter
Enter the database listen port [1521]:
Enter 1 to specify the database service name,or 2 to specify the database SID : 2
Enter the database SID [xe]:
Enter the database password for ORDS_PUBLIC_USER:
Confirm Password :

Retrieving information.

Enter 1 if you want to user 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]: 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...): 1
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:

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

>>>>Now Install Apache tomcat.

copy the noorbd.war where ROOT folder exist in tomcat folder.

Create a directory 'i' here.

Copy image to i

edit server in notepad : ../Tomcat8.5/conf

Search appBase ="webapps"

Write

<Context docBase="C:\apex\images" path="/i" />

Run Apache Server.

Change the port number at : C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\server.xml  to

<Connector port="8181" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" />


---- Run in command prompt : CMD

java -jar noorbd.war validate orcl

---- SQLplus /nolog
---- conn / as sysdba

EXEC DBMS_XDB.SETHTTPPORT(8181);


0 comments:

Post a Comment