DRCP at instance startup

[Patrice sur GMail]

We can start the pool using pl/sql... is there a way to ensure that the
DRCP is restarted automatically when the instance comes back up after a
server is rebooted?

i.e. is it safe to rely on a startup trigger trigger to launch it.


-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>

[Ilmar Kerm]

We do not do anything, it just starts by itself (RAC).

Post by Patrice sur GMail
We can start the pool using pl/sql... is there a way to ensure that the
DRCP is restarted automatically when the instance comes back up after a
server is rebooted?
i.e. is it safe to rely on a startup trigger trigger to launch it.
-- Patrice
My profiles: [image: Facebook]
Twitter] <http://www.twitter.com/PatriceBoivin>

[Andy Sayer]

Just to confirm using the docs (from 11.1 as that was the first google hit)
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc004.htm
“Once started, the connection pool remains in this state until it is
explicitly stopped. The connection pool is automatically restarted when the
database instance is restarted if the pool was active at the time of
instance shutdown.”

Hope that helps,
Andrew