ORDS installation

[Roshan]

Hi Erman,

I have configured ORDS for APEX 5.0 Embedded PLSQL Gateway on Apache Tomcat.
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7

When I access the URL I am getting the pop up show below:
IMG_20072016_202906.png

Do you think the URL is ok?

Regards,
Roshan

[ErmanArslansOracleBlog]

First, check this note;

APEX Login Problem Using Embedded PL/SQL Gateway (EPG) (Doc ID 604859.1)

[ErmanArslansOracleBlog]

Also check this one :
XDB login popup window appears when running APEX (Doc ID 1556047.1)

[ErmanArslansOracleBlog]

Also please read the documentation..

Check this also:

https://docs.oracle.com/database/121/HTMDB/start_login.htm#HTMDB01006

It says:

if your setup uses the Oracle Application Express Listener, go to:

<a href="http://hostname:port/apex/apex_admin">http://hostname:port/apex/apex_admin

If your setup uses the embedded PL/SQL gateway, go to:

<a href="http://hostname:port/apex/apex_admin">http://hostname:port/apex/apex_admin

If your setup uses Apache and mod_plsql, go to:

<a href="http://hostname:port/pls/apex/apex_admin">http://hostname:port/pls/apex/apex_admin

On the Login page:

In Username, enter admin.

In Password, enter the Oracle Application Express administrator account password you specified when you installed Oracle Application Express.

Click Login.

[Roshan]

If my APEX url is erpvision.sunresort.local:8080/apex/apex_admin, ords has been installed on the database, what is the purpose of making the deployment on Tomcat?

[ErmanArslansOracleBlog]

Please give all the details about the installation you just did and then ask your question clearly.

20 Tem 2016 21:05 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

If my APEX url is erpvision.sunresort.local:8080/apex/apex_admin, ords has been installed on the database, what is the purpose of making the deployment on Tomcat?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ORDS-installation-tp1191p1195.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

I have followed the steps from
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7

I access Apache Tomcat from http://erpvision.sunresort.local:8080

When I access ords from http://erpvision.sunresort.local:8080/ords/,
 I am getting the error

Capture.PNG

[Roshan]

I have configured the URl(PLSQL) from https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-configure-multiple-databases
 
Do I need to add the URL in the xml file after doing the mapping?
 
plsqluser-pdb1.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Thu Jul 21 11:07:42 MUT 2016</comment>
<entry key="db.password">@0576D7F1F516BCFD7030DB872CBD6428001046B49E1F5B7741</entry>
<entry key="db.username">plsqluser</entry>
</properties>

[ErmanArslansOracleBlog]

follow this url and check all that you have done: https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7064
->
Follow : "1.8 Deploying to Apache Tomcat" and check your configuration/the actions you have taken for the installation.

Check this for understanding the configuration file ->
REST Data Services Installation and Configuration Guide
https://docs.oracle.com/cd/E37099_01/doc.20/e25066/config_file.htm#AELIG7162


Enable debug if necessary -> https://docs.oracle.com/cd/E37099_01/doc.20/e25066/trouble.htm#AELIG7172

[ErmanArslansOracleBlog]

For example:

A.4.1 Understanding the url-mapping.xml File Format

The url-mapping.xml file stores the rules that route requests to the
appropriate database when more than one database is configured. The
following is an example of a url-mapping.xml file:

<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
 <pool name="sales_db"
   uri-pattern="/sales"
   type="base-path"
   workspace-id="sales_rest"/>
</pool-config>

2016-07-21 11:45 GMT+03:00 ErmanArslansOracleBlog [via Erman Arslan's
Oracle Forum] <[hidden email]>:

> follow this url anc check all that you have done:
> https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7064
> Follow : "1.8 Deploying to Apache Tomcat" and check your configuration/the
> action you have taken for the installation.
>
> Check this for understanding the configuration file
> REST Data Services Installation and Configuration Guide
> https://docs.oracle.com/cd/E37099_01/doc.20/e25066/config_file.htm#AELIG7162
>
>
> Enable debug if necessary ->
> https://docs.oracle.com/cd/E37099_01/doc.20/e25066/trouble.htm#AELIG7172
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ORDS-installation-tp1191p1199.html
> To start a new topic under Database, email
> [hidden email]
> To unsubscribe from Erman Arslan's Oracle Forum, click here.
> NAML

--
Erman Arslan

Applications and Database Operations Manager


Oracle Certified Expert

Certified Exadata Administrator

Certified Linux Administrator

Author for Apress

MBA


Blog:      ermanarslan.blogspot.com

Forum:  http://ermanarslan.blogspot.com/p/forum.html



M: 05301567803

[Roshan]

Hi,

the issue got solved.
I had to specify the full path for the config directory


Please see link below:
http://sanjeev-oracle-world.blogspot.com/2015/08/installing-apex5-with-ords3-on-apache.html

section Then set up the config directory using following command,

initially I specified only the folder name

Regards,
Roshan