Unable to connect to ORACLE (ORA-12222: .....

[fux23]

Hi!!!
Several times I get such message ... while trying to open a PHP script page that uses Oracle database (the script uses PHPLIB library)...

It is strange because earlier... it was all ok... for a few hours.... and when I got back home (with no changes to the script...) IT IS NOT WORKING .... ORA-12222 error.........

At the same time I may use other applications that are using ORACLE DATABASE (for example Designer 6i or TOAD from Quest Software...) SO THE CONNECTION STRING AND PASSWORD is good

How may I fix it....

I use PHP 4.05 - Foxserver and PHP 4.06 - Apache...
And I got the same error on Both of them...

THANK YOU FOR YOUR HELP
Przemek

[matto]

looked it up in google ...

ORA-12222: TNS:no such protocol adapter
Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adaptor is not installed.

Action: Install the protocol adapter or correct typographically error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).

http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58312/newch253.htm

if you're sure that the mentioned settings are ok, try restarting the web server; usually this helps when we encounter problems of this (TNS) kind.