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.
On Fri, Sep 7, 2018 at 4:09 AM, Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
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
On Thu, Sep 6, 2018 at 1:58 PM Jeff Smith <jeff.d.smith@xxxxxxxxxx> wrote:
You could run the install again – but also make sure the apex public user
is ALSO unlocked
*From:* Jeff Chirco <backseatdba@xxxxxxxxx>
*Sent:* Thursday, September 6, 2018 4:25 PM
*To:* Jeff Smith <jeff.d.smith@xxxxxxxxxx>
*Cc:* Mark Bobak <mark@xxxxxxxxx>; Stefan Knecht <knecht.stefan@xxxxxxxxx>;
oracle-l-freelist <oracle-l@xxxxxxxxxxxxx>
*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 <jeff.d.smith@xxxxxxxxxx>
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 <backseatdba@xxxxxxxxx>
*Sent:* Thursday, September 6, 2018 3:27 PM
*To:* Mark Bobak <mark@xxxxxxxxx>
*Cc:* Stefan Knecht <knecht.stefan@xxxxxxxxx>; oracle-l-freelist <
oracle-l@xxxxxxxxxxxxx>
*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 <mark@xxxxxxxxx> 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 <knecht.stefan@xxxxxxxxx> wrote:
Restart ORDS after setting them to true, BTW.
On Fri, Sep 7, 2018 at 12:37 AM, Stefan Knecht <knecht.stefan@xxxxxxxxx>
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 <backseatdba@xxxxxxxxx>
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
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=>