Re: [cx-oracle-users] Connecting to a database in a way that doesn't stop a shutdown

[Amaury F. D A. <Ama...@Ub...>]

Hello,

> Is there any way of creating a cx_Oracle connection which doesn't
> block a SHUTDOWN NORMAL? The Oracle Intelligent agent seems to work
> like this (agent connections are present in the database, but SHUTDOWN
> NORMAL still works), so I suspect it's possible, but I can't find
> anything in the documentation which tells me how.

I've never used the Intelligent agent, but it seems on the contrary
that a running agent is one of the causes which prevent
SHUTDOWN NORMAL to work.
A quick Google search reveals that some DBAs include a
"agentctl stop" command in their shutdown procedures.

You should try to solve your case differently. Here are some ideas:

- replace SHUTDOWN NORMAL by SHUTDOWN TRANSACTIONAL, which closes
the connection after COMMIT or ROLLBACK.

- Implement some kind of connection pooling, where the connection
object is closed after 10 minutes of idle time.
For this you will need another thread to close the connection.

- Use the Oracle "Profiles" feature, and limit the "idle time"
for the session.

Hope this helps,

--
Amaury Forgeot d'Arc
Ubix Development
www.ubitrade.com