ORACLE DB connection error

Anon

Hi all.

I'm working on a web site wich is installed on a SUN machine with Apache and ORACLE DB.

Here the text of an error that appears RANDOM, I mean that when I work on the site, sometimes happen, sometime not. And usually I have to close and re-open the browser and hope that the error will not occure again:

Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-12154) in nodalis_db_oracle.inc on line 52

Database error: Link-ID == false (), ora_plogon failed
ORACLE Error: 0 ()
Session halted.

Please help me!

Thanks,
VDP

punkdba

Vittorio,

 ORA-12154 error are almost ALWAYS related to your tnsnames.ora file (please see Oracle's explanation, below).  I suggest that you blow-away your sqlnet.ora file if possible. Also, you should try using SID identifiers in your tnsnames.ora (i.e., not SERVICE_NAME identifiers).  The other side of the equation is, of course, your listener.ora setup.  If possible, test your connection to your instance from another box running sqlplus (e.g., sqlplus uname/pswd@myinstance) -- if you're able to sqlplus from a client machine, but unable to access via the web browser, then perhaps your problem lies in your PHP code. Obviously.  You should also be able to connect using sqlplus, locally.

Although I'm not using that function, I'm able to run Apache/PHP on Solaris 2.7 & 8. Good luck...

punkdba

12154, 00000, "TNS:could not resolve service name"
// Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.