RE: ords/tomcat help

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Thu, 6 Sep 2018 13:58:11 -0700 (PDT)
Message-ID: <412a2f23-54eb-4177-ae64-7dc2e2223079_at_default>



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 <HYPERLINK "mailto:jeff.d.smith_at_oracle.com"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 <HYPERLINK "mailto:backseatdba_at_gmail.com"backseatdba_at_gmail.com> Sent: Thursday, September 6, 2018 3:27 PM To: Mark Bobak <HYPERLINK "mailto:mark_at_bobak.net"mark_at_bobak.net> Cc: Stefan Knecht <HYPERLINK "mailto:knecht.stefan_at_gmail.com"knecht.stefan_at_gmail.com>; oracle-l-freelist <HYPERLINK "mailto:oracle-l_at_freelists.org"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 <HYPERLINK "mailto:mark_at_bobak.net"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 <HYPERLINK "mailto:knecht.stefan_at_gmail.com"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 <HYPERLINK "mailto:knecht.stefan_at_gmail.com"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 <HYPERLINK "mailto:backseatdba_at_gmail.com"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

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 | _at_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/





 

-- 

//

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 | _at_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/

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 06 2018 - 22:58:11 CEST

Original text of this message