Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2192
  • Last Modified:

PHP setting Oracle Connection : Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name

Helo Evreyone... I am novice when it comes to PHP.
In need to access an Oracle database from a PHP form ..(queries will come later but I am unable to create a connection in the first place)

I have programmed iin Java JDBC before and the connection string is as below

url=jdbc:oracle:thin:@server:1521:db

And from The Oracle client(Toad) I connect by using the  
username@server.db

I tried this with PHP but failed to connect
*****************************************************************************************************
<?php
$connection = ora_logon("username@server.db","password");

if ($connection == false){
  echo Ora_ErrorCode($connection).": ".Ora_Error($connection)."<BR>";
  exit;
}  

$cursor = Ora_Open ($connection);
if ($cursor == false){
  echo Ora_ErrorCode($connection).": ".Ora_Error($connection)."<BR>";
  exit;
}  

Ora_Commit ($connection);
Ora_Close ($cursor);
Ora_Logoff ($connection);
?>
*****************************************************************************************************

Thanks for your time
0
micro_learner
Asked:
micro_learner
1 Solution
 
UmeshMySQL Principle Technical Support EngineerCommented:
0
 
micro_learnerAuthor Commented:
Hello ... I figured out that the earlier error was a TNSoraname error.I resolved it but I still get the error

Warning: Oracle: Connection Failed: Error while trying to retrieve text for error ORA-12514 in /home/i/html/test2.php on line 6
 Oracle Connect Error Error while trying to retrieve text for error ORA-12514

I suspect that the error is due to how I am giving the connection string

say

:Username is  bob
:Password is  man
:Server (of DB)  earth
:database name    planet

if ($c=ora_logon("bob@earth","man","planet")) {
echo "Successfully connected to Oracle.\n";
  ora_commitoff($c);
  ora_logoff($c);
} else {
  echo "Oracle Connect Error " . ora_error();
}

Is this right ...please guide me in this so that I can atleast get teh connection string right .
Appreciate your time and effort
0
 
e-tsikCommented:
Hi :-)

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.
earth - in this case should have been a TNS server rather than a server.
You might  have a problem with the ORACLE_HOME variable.

You might want to replace ora_logon with ocilogon
http://il2.php.net/manual/en/ref.oci8.php

$db = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db.ip.address)(PORT = db.port)) ) (CONNECT_DATA = (SID = YOUR_DB_SID) ) )";
$con = OCILogOn("user", "password",$db);

This, of course requires you to switch the functions you use to the new library.

Hope it helps...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now