Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Apex 4.1 , Tomcat 8.5 and ORDS 3.0.11 connection problems : Pool is not correctly configured

JeanYves BernierMar 31 2021

Hi , for one of our customer we are facing some errors since today.
In the tomcat errors logs we have :

31-Mar-2021 16:49:01.835 SEVERE [localhost-startStop-1] . *** Pool: |octal|al| is not correctly configured and will be ignored ***
31-Mar-2021 16: 49: 02.980 SEVERE [localhost-startStop-1]. The username or password for the connection pool named octal_rt is invalid, has expired, or the account is locked out
oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The username or password for the connection pool named octal_rt is not valid, has expired, or the account is locked out

and then the application is not available anymore..
What can cause this error and how to fix it ?
Regards
JeanYves

Comments

JeanYves Bernier

@thatjeffsmith-oracle , hi any help on that matter ?
Thanks
JeanYves

do what the error message tells you to do
confirm that the database user you have used to configure that pool has the correct password, or that the account hasn't been LOCKED or had it's password EXPIRED

1 person found this helpful
JeanYves Bernier

Hi Jeff, thank you for the answer.
The accounts that are LOCKED and had it's password EXPIRED are the :
APEX_040100 EXPIRED & LOCKED
ANONYMOUS EXPIRED & LOCKED
ORDS_METADATA EXPIRED & LOCKED
users.
APEX_PUBLIC_USER OPEN
ORDS_PUBLIC_USER OPEN
I did not make the configuration of this apex instance but the ords_params.properties indicates :

db.username=APEX_PUBLIC_USER

As the APEX_PUBLIC_USER is OPEN, I don't really understand why I get tgis error (which is not present anymore....)

I can't wait to finish the rewriting of theses apps to apex 20.2 and ords 20.4 .... (just some more pages to migrate...)

1 - 3

Post Details

Added on Mar 31 2021
3 comments
277 views
1 mention