Juffermans, Jos wrote:

Some of our scripts that generate customer-facing pages, need a connection to a database. The problems is that the database is in Norway and - allthough we have a VPN setup - the connection isn't always available.

In case the connection cannot be made, we can redirect the customer to a nice error page and ask them to try again later. That's not too hard.

The issue is that it takes really really long before ocilogon returns if the

connection cannot be established. Is it possible to set a timeout on ocilogon (like you can with eg fsockopen)?


Look at the Oracle Net configuration and see if any parameters can be tweaked.

For example, with Oracle 10.1, editing the client-side sqlnet.ora
file and changing




removes an extra delay when the connection fails.  In this example you
lose the ability to use 10g Easy Connection syntax, which may not
be important to you.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to