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.

ords autocheck connection pool

federicoNov 20 2018 — edited Nov 20 2018

Hi all,

I have this problem: I have two server, one with the database, and the second with the tomcat and the ords.

Sometimes I need to reboot both servers. When I did this, the tomcat starts "too fast" while the database server is not open.

The ords logs this:

The pool named: |apex|| is invalid and will be ignored: Error I/O: The Network Adapter could not establish the connection
 The pool named: |apex|pu| is invalid and will be ignored: Error I/O: The Network Adapter could not establish the connection
 The pool named: |apex|al| is invalid and will be ignored: Error I/O: The Network Adapter could not establish the connection
 The pool named: |apex|rt| is invalid and will be ignored: Error I/O: The Network Adapter could not establish the connection

Each time I need to restart tomcat by hand. Is there a way to instruct the ords to retry the connection pools and don't put them offline ?
This post has been answered by thatJeffSmith-Oracle on Nov 20 2018
Jump to Answer

Comments

thatJeffSmith-Oracle

we're smart

we wait 15 minutes and then try again

The first time you try hit the pool, it doesn't exist, so it'll get marked bad in the pool cache with a timeout of 15 minutes. On the next request after the timeout expires ORDS will attempt to create the pool again. If it's present and correctly configured it will succeed and from that point it will work as expected

You can config this with db.invalidPoolTimeout

federico

Hi thatJeffSmith-Oracle,

I will try this parameter. Is it documented ? Is it in minutes ?

many thanks

thatJeffSmith-Oracle
Answer

you can set it to say

1m

15s

2h

where m=minute, s=second, h=hour

Marked as Answer by federico · Sep 27 2020
federico

I will try as soon as possible.

Many thanks

1 - 4

Post Details

Added on Nov 20 2018
4 comments
694 views