Pooling

[jestep]

I am using Ora 8.0.5 and IIS4
I am trying to use the internal pooling.
I create a "Master" session and set pooling to spInternal. I then create other sessions on the fly.
If Oracle is killed and restarted I receive Ora-12571 or Ora-01041 errors. When I receive these I disconnect the "Master" session and reconnect. It is succesful but my new sessions still receive the errors. Is there any workaround or do I need to do this differently. This causes major problems for the site.

Thanks,
John Estep

 

[Marco Kalter]

If you want to explicitly manage the session pool, you can use the SessionPool variable in the Oracle unit. It has a Compress function, which removes all pooled connections that are not being used at that moment. If none of the pooled connections that were killed are in use, this should fix the situation you described.

We will add some additional control for this in the next release.

------------------
Marco Kalter
Allround Automations

 

[jestep]

Thanks Marco,

That should help me a lot.