Re: ords/tomcat help
Date: Fri, 7 Sep 2018 11:14:38 +0700
Message-ID: <CAP50yQ8QJyLj_kth0x+3DpkfbxHmyjq5D6wAMctdhARUgCfF7Q_at_mail.gmail.com>
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_at_gmail.com> 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_at_oracle.com> wrote:
>
>> You could run the install again – but also make sure the apex public user
>> is ALSO unlocked
>>
>>
>>
>> *From:* Jeff Chirco <backseatdba_at_gmail.com>
>> *Sent:* Thursday, September 6, 2018 4:25 PM
>> *To:* Jeff Smith <jeff.d.smith_at_oracle.com>
>> *Cc:* Mark Bobak <mark_at_bobak.net>; Stefan Knecht <knecht.stefan_at_gmail.com>;
>> oracle-l-freelist <oracle-l_at_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 <jeff.d.smith_at_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 <backseatdba_at_gmail.com>
>> *Sent:* Thursday, September 6, 2018 3:27 PM
>> *To:* Mark Bobak <mark_at_bobak.net>
>> *Cc:* Stefan Knecht <knecht.stefan_at_gmail.com>; oracle-l-freelist <
>> oracle-l_at_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 <mark_at_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 <knecht.stefan_at_gmail.com> wrote:
>>
>> Restart ORDS after setting them to true, BTW.
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Sep 7, 2018 at 12:37 AM, Stefan Knecht <knecht.stefan_at_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 <backseatdba_at_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
>>
>> 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=> |
>> _at_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=> |
>> _at_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 | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/ -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 07 2018 - 06:14:38 CEST