Oracle Connection Error

[Rahmon]

Hi guys,

Please I need to know how to solve this problem while trying to connect to oracle database from my PHP script.

I am using linux Redhat AS.

Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12154

Thanks and regards.

[Frederick]

Setup your connection like this to see what kind of detail error message you get so you can have a better understanding of the issue.

<?php
$conn = @ora_logon("user@wrongTNS", "pass");

if (!$conn) {
   echo "Unable to connect to the database.<BR>\n";
   echo ora_error(), "\n";
}
?>

This will output:

Unable to connect to the database.<BR>
ORA-12154: TNS:could not resolve service name