Re: ords/tomcat help

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Thu, 6 Sep 2018 13:24:46 -0700
Message-ID: <CAKsxbLquFDc36OH1EFi6bhbHrz4RYHJEEej-v9yroxgv_MmL2g_at_mail.gmail.com>





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=>
>
>





--
http://www.freelists.org/webpage/oracle-l


Received on Thu Sep 06 2018 - 22:24:46 CEST

Original text of this message