News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Christopher Jones' Blog:
Getting Oracle Connection Errors Faster in PHP
May 04, 2006 @ 06:47:44

On his Oracle blog today, Christopher Jones has posted a simple howto on getting the feedback the PHP Oracle functions throw when they error, only faster.

When a connection fails, you want to know about it as soon as possible. With Oracle Net there are many ways to configure connection and authentication. For example a connection:

$c = oci_connect("hr", "hr", "abc");

could be evaluated by Oracle 10g as using the Easy Connect syntax to machine "abc" (using the default port and database service) or using a net alias "abc" configured in a tnsnames.ora file.

He includes some settings to add to the sqlnet.ora file to help speed thing along - setting the directory path to enable a different authentication syntax and changing a setting to restrict the types of connect methods the client can try.

To show how it all works together, he gives an example of the tnsnames.ora, sqlnet.ora, environment variables, and the commands he ran to test it all out.

1 comment voice your opinion now!
oracle connection errors faster method restrict oracle connection errors faster method restrict


blog comments powered by Disqus

Similar Posts

PHP-Coding-Practices.com: Making CakePHP's Pagination work with Model::expects()

PHP-Coding-Practices.com: Composing Methods: Introduce Explaining Variable

Brandon Savage's Blog: A Lesson In Static Methods And Late Static Binding

Community News: Zend Announces Advancements with Eclipse, Microsoft, Oracle & More

Chris Jones' Blog: Upgrading PHP Web Applications with Minimum Downtime using Oracle Editioning


Community Events





Don't see your event here?
Let us know!


developer framework testing release wordpress list experience install laravel threedevsandamaybe interview language refactor series introduction unittest opinion podcast code community

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework