Hi,

I have a strange problem with oracle connection. It gives a "ERROR
ORA-12154 TNS: could not resolve the connect identifier specified"
srror on the browser.

Here is my oraConnect.php ##############
<?php
$conn = OCILogon("hr", "hr", 'demo');
$query = 'select * from hr.jobs';

$stid = OCIParse($conn, $query);
OCIExecute($stid, OCI_DEFAULT);
while ($succ = OCIFetchInto($stid, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "<br>\n";
}
?>

#### OUT put
# php oraConnect.php
AD_PRES President 20000 40000 <br>
AD_VP Administration Vice President 15000 30000 <br>
AD_ASST Administration Assistant 3000 6000 <br>
FI_MGR Finance Manager 8200 16000 <br>
FI_ACCOUNT Accountant 4200 9000 <br>
AC_MGR Accounting Manager 8200 16000 <br>
AC_ACCOUNT Public Accountant 4200 9000 <br>
SA_MAN Sales Manager 10000 20000 <br>

### TNSNAME / tnsping
# tnsping demo

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 13-
OCT-2008 11:20:30

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST
= xxx.xxxx.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = demo)))
OK (0 msec)

#### browser
http://localhost/oraConnect.php
Warning: ocilogon() [function.ocilogon]: ORA-12154: TNS:could not
resolve the connect identifier specified in /opt/www/oraConnect.php on
line 2

Warning: ociparse() expects parameter 1 to be resource, boolean given
in /opt/www/oraConnect.php on line 5

Warning: ociexecute() expects parameter 1 to be resource, null given
in /opt/www/oraConnect.php on line 6

Warning: ocifetchinto() expects parameter 1 to be resource, null given
in /opt/www/oraConnect.php on line 7


Thanks mycn,
Beta

On Mon, 13 Oct 2008 11:24:17 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Stupid questions maybe, but anyway questions about this error are
always redundant as there is a plethora of resources, just *because*
people don't do anything to resolve it themselves:

Is the webserver located on the database server?
Did you run tnsping on the webserver or on the database server?
Do you have one or multiple tnsnames.ora floating around?
Did you set the TNS_ADMIN enviroment variable?
Please note similar questions have been asked to other people with the
same problem, so I have one final question:
Why didn't you bother to search the documentation or forums.oracle.com
or Usenet. Assum ing you are unioue? Or just lazy?
Just wondering...

--
Sybrand Bakker
Senior Oracle DBA

On Mon, 13 Oct 2008 11:24:17 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Stupid questions maybe, but anyway questions about this error are
always redundant as there is a plethora of resources, just *because*
people don't do anything to resolve it themselves:

Is the webserver located on the database server?
Did you run tnsping on the webserver or on the database server?
Do you have one or multiple tnsnames.ora floating around?
Did you set the TNS_ADMIN enviroment variable?
Please note similar questions have been asked to other people with the
same problem, so I have one final question:
Why didn't you bother to search the documentation or forums.oracle.com
or Usenet. Assum ing you are unioue? Or just lazy?
Just wondering...

--
Sybrand Bakker
Senior Oracle DBA

On Mon, 13 Oct 2008 11:24:17 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Stupid questions maybe, but anyway questions about this error are
always redundant as there is a plethora of resources, just *because*
people don't do anything to resolve it themselves:

Is the webserver located on the database server?
Did you run tnsping on the webserver or on the database server?
Do you have one or multiple tnsnames.ora floating around?
Did you set the TNS_ADMIN enviroment variable?
Please note similar questions have been asked to other people with the
same problem, so I have one final question:
Why didn't you bother to search the documentation or forums.oracle.com
or Usenet. Assum ing you are unioue? Or just lazy?
Just wondering...

--
Sybrand Bakker
Senior Oracle DBA

On Mon, 13 Oct 2008 11:24:17 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Stupid questions maybe, but anyway questions about this error are
always redundant as there is a plethora of resources, just *because*
people don't do anything to resolve it themselves:

Is the webserver located on the database server?
Did you run tnsping on the webserver or on the database server?
Do you have one or multiple tnsnames.ora floating around?
Did you set the TNS_ADMIN enviroment variable?
Please note similar questions have been asked to other people with the
same problem, so I have one final question:
Why didn't you bother to search the documentation or forums.oracle.com
or Usenet. Assum ing you are unioue? Or just lazy?
Just wondering...

--
Sybrand Bakker
Senior Oracle DBA

On 14 Oct, 17:32, sybra... (AT) hccnet (DOT) nl wrote:
What Sybrand's saying here is that you are not as unique as you think
you are. _Somebody_ would have had the same problem as you somewhere
at some point. Did you try searching the archives for ORA-12154?

HTH

-g

On 14 Oct, 17:32, sybra... (AT) hccnet (DOT) nl wrote:
What Sybrand's saying here is that you are not as unique as you think
you are. _Somebody_ would have had the same problem as you somewhere
at some point. Did you try searching the archives for ORA-12154?

HTH

-g

On 14 Oct, 17:32, sybra... (AT) hccnet (DOT) nl wrote:
What Sybrand's saying here is that you are not as unique as you think
you are. _Somebody_ would have had the same problem as you somewhere
at some point. Did you try searching the archives for ORA-12154?

HTH

-g

On 14 Oct, 17:32, sybra... (AT) hccnet (DOT) nl wrote:
What Sybrand's saying here is that you are not as unique as you think
you are. _Somebody_ would have had the same problem as you somewhere
at some point. Did you try searching the archives for ORA-12154?

HTH

-g

Thanks guys,

I've searched forums.oracle.com and all other places, but still no
luck. The ORA-12154 error message is very general. I am very
appreciated if you have any clues.


On Oct 15, 9:22*am, gazzag <gar... (AT) jamms (DOT) org> wrote: