ords/tomcat help

[Jeff Chirco]

I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
But when I try to go the site I get the Oracle REST Data Services page but
with a 404 Not Found.
[image: image.png]

I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.

Thanks,
Jeff

[Stefan Knecht]

Turn those two on in your defaults.xml in the ORDS installation directory:

<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>

Then you should get more information.

Post by Jeff Chirco
I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-
installation-on-tomcat
But when I try to go the site I get the Oracle REST Data Services page but
with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.
Thanks,
Jeff

[Stefan Knecht]

Restart ORDS after setting them to true, BTW.

Post by Stefan Knecht
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.

Post by Jeff Chirco
I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-
services-ords-installation-on-tomcat
But when I try to go the site I get the Oracle REST Data Services page
but with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.
Thanks,
Jeff

--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

[Mark J. Bobak]

Also, try turning ords.war in Standalone mode.

java -jar ords.war standalone

It should be clear if you're missing any Oracle DBA users, or if you have
the wrong password for any of them.

-Mark

Post by Stefan Knecht
Restart ORDS after setting them to true, BTW.

Post by Stefan Knecht
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.

Post by Jeff Chirco
I am working on setting up Tomcat/ORDS/APEX for the first time. I have
a Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
But when I try to go the site I get the Oracle REST Data Services page
but with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is
usually the cause of this?
Appreciate any help.
Thanks,
Jeff

--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

[Jeff Chirco]

Apex 18.1
ORDS 18.2ZZZ
Apacke Tomcat 9.0.10

This is the only warning I see in the logs
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 04, 2018 9:51:43 PM

I am running in standalone mode and I don't see any other errors.

Post by Mark J. Bobak
Also, try turning ords.war in Standalone mode.
java -jar ords.war standalone
It should be clear if you're missing any Oracle DBA users, or if you have
the wrong password for any of them.
-Mark

Post by Stefan Knecht
Restart ORDS after setting them to true, BTW.

Post by Stefan Knecht
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.

Post by Jeff Chirco
I am working on setting up Tomcat/ORDS/APEX for the first time. I have
a Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
But when I try to go the site I get the Oracle REST Data Services page
but with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is
usually the cause of this?
Appreciate any help.
Thanks,
Jeff

--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

[Jeff Smith]

Well that error is a pretty big one.

 

ORDS can’t establish a connection pool to run your APEX app.

 

Change the apex user password in the database to match what you have in the ords config files or vice versa.

 

From: Jeff Chirco <***@gmail.com>
Sent: Thursday, September 6, 2018 3:27 PM
To: Mark Bobak <***@bobak.net>
Cc: Stefan Knecht <***@gmail.com>; oracle-l-freelist <oracle-***@freelists.org>
Subject: Re: ords/tomcat help

 

Apex 18.1

ORDS 18.2ZZZ

Apacke Tomcat 9.0.10

 

This is the only warning I see in the logs

WARNING: The pool named: |apex|| is invalid and will be ignored: The username or password for the connection pool named apex, are invalid, expired, or the account is locked
Sep 04, 2018 9:51:43 PM

 

I am running in standalone mode and I don't see any other errors.

 

 

On Thu, Sep 6, 2018 at 11:48 AM Mark J. Bobak <HYPERLINK "mailto:***@bobak.net"***@bobak.net> wrote:

Also, try turning ords.war in Standalone mode.

 

java -jar ords.war standalone 

 

It should be clear if you're missing any Oracle DBA users, or if you have the wrong password for any of them.

 

-Mark 

On Thu, Sep 6, 2018, 13:39 Stefan Knecht <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

Restart ORDS after setting them to true, BTW.

 

 

 

On Fri, Sep 7, 2018 at 12:37 AM, Stefan Knecht <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

Turn those two on in your defaults.xml in the ORDS installation directory:

 

<entry key="debug.debugger">false</entry>

<entry key="debug.printDebugToScreen">false</entry>

 

Then you should get more information.

 

 

 

On Thu, Sep 6, 2018 at 11:14 PM, Jeff Chirco <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

I am working on setting up Tomcat/ORDS/APEX for the first time.  I have a Linux box with Tomcat installed. I followed Tim's notes for ORDS install

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e="https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat

But when I try to go the site I get the Oracle REST Data Services page but with a 404 Not Found.



 

I copied the APEX images to my /tomcat/webapps/i folder.  What is usually the cause of this?

Appreciate any help.

 

Thanks,

Jeff





 
--
//

zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

Visit us at HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e="zztat.net | @zztat_oracle | HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e="fb.me/zztat | HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e="zztat.net/blog/





 

[Jeff Chirco]

Hi Jeff, Which apex user account. I checked and APEX_PUBLIC_USER password
is matching.

Post by Jeff Smith
Well that error is a pretty big one.
ORDS can’t establish a connection pool to run your APEX app.
Change the apex user password in the database to match what you have in
the ords config files or vice versa.
*Sent:* Thursday, September 6, 2018 3:27 PM
*Subject:* Re: ords/tomcat help
Apex 18.1
ORDS 18.2ZZZ
Apacke Tomcat 9.0.10
This is the only warning I see in the logs
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 04, 2018 9:51:43 PM
I am running in standalone mode and I don't see any other errors.
Also, try turning ords.war in Standalone mode.
java -jar ords.war standalone
It should be clear if you're missing any Oracle DBA users, or if you have
the wrong password for any of them.
-Mark
Restart ORDS after setting them to true, BTW.
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.
I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
<https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e=>
But when I try to go the site I get the Oracle REST Data Services page but
with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.
Thanks,
Jeff
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>

[Jeff Smith]

You could run the install again – but also make sure the apex public user is ALSO unlocked

 

From: Jeff Chirco <***@gmail.com>
Sent: Thursday, September 6, 2018 4:25 PM
To: Jeff Smith <***@oracle.com>
Cc: Mark Bobak <***@bobak.net>; Stefan Knecht <***@gmail.com>; oracle-l-freelist <oracle-***@freelists.org>
Subject: Re: ords/tomcat help

 

Hi Jeff,  Which apex user account.  I checked and APEX_PUBLIC_USER password is matching.

 

On Thu, Sep 6, 2018 at 12:57 PM Jeff Smith <HYPERLINK "mailto:***@oracle.com"***@oracle.com> wrote:

Well that error is a pretty big one.

 

ORDS can’t establish a connection pool to run your APEX app.

 

Change the apex user password in the database to match what you have in the ords config files or vice versa.

 

From: Jeff Chirco <HYPERLINK "mailto:***@gmail.com"***@gmail.com>
Sent: Thursday, September 6, 2018 3:27 PM
To: Mark Bobak <HYPERLINK "mailto:***@bobak.net"***@bobak.net>
Cc: Stefan Knecht <HYPERLINK "mailto:***@gmail.com"***@gmail.com>; oracle-l-freelist <HYPERLINK "mailto:oracle-***@freelists.org"oracle-***@freelists.org>
Subject: Re: ords/tomcat help

 

Apex 18.1

ORDS 18.2ZZZ

Apacke Tomcat 9.0.10

 

This is the only warning I see in the logs

WARNING: The pool named: |apex|| is invalid and will be ignored: The username or password for the connection pool named apex, are invalid, expired, or the account is locked
Sep 04, 2018 9:51:43 PM

 

I am running in standalone mode and I don't see any other errors.

 

 

On Thu, Sep 6, 2018 at 11:48 AM Mark J. Bobak <HYPERLINK "mailto:***@bobak.net"***@bobak.net> wrote:

Also, try turning ords.war in Standalone mode.

 

java -jar ords.war standalone 

 

It should be clear if you're missing any Oracle DBA users, or if you have the wrong password for any of them.

 

-Mark 

On Thu, Sep 6, 2018, 13:39 Stefan Knecht <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

Restart ORDS after setting them to true, BTW.

 

 

 

On Fri, Sep 7, 2018 at 12:37 AM, Stefan Knecht <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

Turn those two on in your defaults.xml in the ORDS installation directory:

 

<entry key="debug.debugger">false</entry>

<entry key="debug.printDebugToScreen">false</entry>

 

Then you should get more information.

 

 

 

On Thu, Sep 6, 2018 at 11:14 PM, Jeff Chirco <HYPERLINK "mailto:***@gmail.com"***@gmail.com> wrote:

I am working on setting up Tomcat/ORDS/APEX for the first time.  I have a Linux box with Tomcat installed. I followed Tim's notes for ORDS install

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e="https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat

But when I try to go the site I get the Oracle REST Data Services page but with a 404 Not Found.



 

I copied the APEX images to my /tomcat/webapps/i folder.  What is usually the cause of this?

Appreciate any help.

 

Thanks,

Jeff





 
--
//

zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!

Visit us at HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e="zztat.net | @zztat_oracle | HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e="fb.me/zztat | HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e="zztat.net/blog/





 

[Jeff Chirco]

Yep I manually logged into each apex user account with the same password.
Still having same issue. I am not getting errors about apex pu, al, or rt
just this pool named |apex|

WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 06, 2018 2:07:17 PM

Post by Jeff Smith
You could run the install again – but also make sure the apex public user
is ALSO unlocked
*Sent:* Thursday, September 6, 2018 4:25 PM
*Subject:* Re: ords/tomcat help
Hi Jeff, Which apex user account. I checked and APEX_PUBLIC_USER
password is matching.
Well that error is a pretty big one.
ORDS can’t establish a connection pool to run your APEX app.
Change the apex user password in the database to match what you have in
the ords config files or vice versa.
*Sent:* Thursday, September 6, 2018 3:27 PM
*Subject:* Re: ords/tomcat help
Apex 18.1
ORDS 18.2ZZZ
Apacke Tomcat 9.0.10
This is the only warning I see in the logs
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 04, 2018 9:51:43 PM
I am running in standalone mode and I don't see any other errors.
Also, try turning ords.war in Standalone mode.
java -jar ords.war standalone
It should be clear if you're missing any Oracle DBA users, or if you have
the wrong password for any of them.
-Mark
Restart ORDS after setting them to true, BTW.
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.
I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
<https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e=>
But when I try to go the site I get the Oracle REST Data Services page but
with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.
Thanks,
Jeff
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>

[Stefan Knecht]

This usually happens when a proxy privilege is missing. One way to fix it
is in this note: 2139373.1 - however you need to be able to access APEX in
the first place to click that button.

You can also check if you have the necessary proxy users set:

PROXY
--------------------------------------------------------------------------------------------------------------------------------
CLIENT
AUT FLAGS
--------------------------------------------------------------------------------------------------------------------------------
--- -----------------------------------
APEX_REST_PUBLIC_USER
ZZ$REPO
NO PROXY MAY
ACTIVATE ALL CLIENT ROLES

APEX_REST_PUBLIC_USER
APEX_PUBLIC_USER
NO PROXY MAY ACTIVATE
ALL CLIENT ROLES


It should look something like this. If one's missing, grant it.

Post by Jeff Chirco
Yep I manually logged into each apex user account with the same password.
Still having same issue. I am not getting errors about apex pu, al, or rt
just this pool named |apex|
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 06, 2018 2:07:17 PM

Post by Jeff Smith
You could run the install again – but also make sure the apex public user
is ALSO unlocked
*Sent:* Thursday, September 6, 2018 4:25 PM
*Subject:* Re: ords/tomcat help
Hi Jeff, Which apex user account. I checked and APEX_PUBLIC_USER
password is matching.
Well that error is a pretty big one.
ORDS can’t establish a connection pool to run your APEX app.
Change the apex user password in the database to match what you have in
the ords config files or vice versa.
*Sent:* Thursday, September 6, 2018 3:27 PM
*Subject:* Re: ords/tomcat help
Apex 18.1
ORDS 18.2ZZZ
Apacke Tomcat 9.0.10
This is the only warning I see in the logs
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 04, 2018 9:51:43 PM
I am running in standalone mode and I don't see any other errors.
Also, try turning ords.war in Standalone mode.
java -jar ords.war standalone
It should be clear if you're missing any Oracle DBA users, or if you have
the wrong password for any of them.
-Mark
Restart ORDS after setting them to true, BTW.
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.
I am working on setting up Tomcat/ORDS/APEX for the first time. I have a
Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-
installation-on-tomcat
<https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e=>
But when I try to go the site I get the Oracle REST Data Services page
but with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is usually
the cause of this?
Appreciate any help.
Thanks,
Jeff
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>

[Jeff Chirco]

Thanks Anthony. I tried that and I ended up with a different error. So I
decided to just delete all the apex_xx.xml files cause some of them were
dated really old. I then ran
$JAVA_HOME/bin/java -jar ords.war
It then walked me through setup and and recreated those xml files. This
time I was getting invalid password for apex|pu. I tried your method for
encrypting the file for that one but no luck. So I just put the actual
password in the apex_pu.xml file. I can't get it to re-encrypt the file.
However after I start ords I am not getting this message on the page.
Feels like I am getting closer

[image: image.png]

Post by Jeff Chirco
Hi Jeff,
do you see this user getting locked out? APEX_PUBLIC_USER?
have you tried re-encrypting your good working password for apex public
user in apex.xml?
I think if you put an ! followed by your password and restart tomcat it
will be reencrpyted.
for example if your working password is Password you would change this
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Sun Jul 26 22:34:51 MDT 2015</comment>
*<entry
<entry key="db.username">APEX_PUBLIC_USER</entry>
</properties>
to this
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Sun Jul 26 22:34:51 MDT 2015</comment>
*<entry key="db.password">!Password</entry>*
<entry key="db.username">APEX_PUBLIC_USER</entry>
</properties>
thanks,
Anthony

Post by Jeff Chirco
Yep I manually logged into each apex user account with the same password.
Still having same issue. I am not getting errors about apex pu, al, or rt
just this pool named |apex|
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 06, 2018 2:07:17 PM

Post by Jeff Smith
You could run the install again – but also make sure the apex public
user is ALSO unlocked
*Sent:* Thursday, September 6, 2018 4:25 PM
*Subject:* Re: ords/tomcat help
Hi Jeff, Which apex user account. I checked and APEX_PUBLIC_USER
password is matching.
Well that error is a pretty big one.
ORDS can’t establish a connection pool to run your APEX app.
Change the apex user password in the database to match what you have in
the ords config files or vice versa.
*Sent:* Thursday, September 6, 2018 3:27 PM
*Subject:* Re: ords/tomcat help
Apex 18.1
ORDS 18.2ZZZ
Apacke Tomcat 9.0.10
This is the only warning I see in the logs
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
Sep 04, 2018 9:51:43 PM
I am running in standalone mode and I don't see any other errors.
Also, try turning ords.war in Standalone mode.
java -jar ords.war standalone
It should be clear if you're missing any Oracle DBA users, or if you
have the wrong password for any of them.
-Mark
Restart ORDS after setting them to true, BTW.
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
Then you should get more information.
I am working on setting up Tomcat/ORDS/APEX for the first time. I have
a Linux box with Tomcat installed. I followed Tim's notes for ORDS install
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat
<https://urldefense.proofpoint.com/v2/url?u=https-3A__oracle-2Dbase.com_articles_misc_oracle-2Drest-2Ddata-2Dservices-2Dords-2Dinstallation-2Don-2Dtomcat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=KPj0MSF4snLbyTibImr6x9psDGcy6ymSAiQOqUnluOk&e=>
But when I try to go the site I get the Oracle REST Data Services page
but with a 404 Not Found.
[image: image.png]
I copied the APEX images to my /tomcat/webapps/i folder. What is
usually the cause of this?
Appreciate any help.
Thanks,
Jeff
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=Y8EqmM2rK4LGTo8XzY5AThx6L_335NVRDF0yho1m2yM&e=> |
@zztat_oracle | fb.me/zztat
<https://urldefense.proofpoint.com/v2/url?u=http-3A__fb.me_zztat&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=V4dopSm9ciSDHqaqs3QreLUT78xZferdl20LxXi7QF0&e=>
| zztat.net/blog/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__zztat.net_blog_&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=8hz_O6HCQtyTzEIICpqaqhCr5-PypXfBkcFQg15atGM&s=O5sHs4DCl5HPNo0-jTIgqhONnSmaRVri_v7osZLpBbg&e=>

[Tim Hall]

Hi.

I've seen this when...

1) When connecting to an Oracle 11.2 or older database from ORDS 17.4 or
ORDS 18.x.

I still have some 11.2 databases and I can't use anything above ORDS 3.0.12
for them. From ORDS 17.4 onward they changed the Oracle client version used
in ORDS and it doesn't appear to be backwards compatible. I was having
loads of trouble with ORDS 18.x and eventually Colm Divily suggested I
switch back and it's fine now. I now have:

DB 11.2 : ORDS 3.0.12
DB 12.1 + : ORDS 18.2

Those are fine for me.

2) If you have done an APEX upgrade since the ORDS install you will either
have to do an ORDS validate, or reinstall ORDS to fix some permissions. The
APEX upgrade trashes some permissions ORDS needs, and 3 views won't compile.

https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat#ords-validate

3) I think it's happened when I've forgotten to run the EPG config during
the APEX installation.

https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation#epg-configuration

4) I guess the most obvious, it's happened when I've used the wrong
passwords or had locked DB users. :)

Cheers

Tim...

Cheers

Tim...

[Jeff Chirco]

Thanks Tim. I didn't realize I need to install EGP during APEX install. I
did that, then I uninstalled ORDS, verified and check all my password in
the ords param file. Installed ORDS again. Still same issues. :(
WARNING: The pool named: |apex|| is invalid and will be ignored: The
username or password for the connection pool named apex, are invalid,
expired, or the account is locked
I am running single instance 12.2 with Apex 18.1 and ORDS 18.2

Post by Tim Hall
Hi.
I've seen this when...
1) When connecting to an Oracle 11.2 or older database from ORDS 17.4 or
ORDS 18.x.
I still have some 11.2 databases and I can't use anything above ORDS
3.0.12 for them. From ORDS 17.4 onward they changed the Oracle client
version used in ORDS and it doesn't appear to be backwards compatible. I
was having loads of trouble with ORDS 18.x and eventually Colm Divily
DB 11.2 : ORDS 3.0.12
DB 12.1 + : ORDS 18.2
Those are fine for me.
2) If you have done an APEX upgrade since the ORDS install you will either
have to do an ORDS validate, or reinstall ORDS to fix some permissions. The
APEX upgrade trashes some permissions ORDS needs, and 3 views won't compile.
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat#ords-validate
3) I think it's happened when I've forgotten to run the EPG config during
the APEX installation.
https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation#epg-configuration
4) I guess the most obvious, it's happened when I've used the wrong
passwords or had locked DB users. :)
Cheers
Tim...
Cheers
Tim...