After upgrading my database to 10.2 I get the following error when trying to
connect: (Using Solaris 9, Apache 2.0.54, and php 5.0.5)

*Warning*: ocilogon()
[function.ocilogon<http://adcinfops01/function.ocilogon>]:
_oci_open_server: Error while trying to retrieve text for error ORA-12154 in
*/usr/local/httpd-2.0.54/htdocs/oratest.php* on line *6*

*Warning*: ociparse(): supplied argument is not a valid OCI8-Connection
resource in */usr/local/httpd-2.0.54/htdocs/oratest.php* on line *8*

*Warning*: ociexecute(): supplied argument is not a valid OCI8-Statement
resource in */usr/local/httpd-2.0.54/htdocs/oratest.php* on line *9*

*Warning*: ocifetchstatement(): supplied argument is not a valid
OCI8-Statement resource in */usr/local/httpd-2.0.54/htdocs/oratest.php* on
line *11*
DEBUG: rows=

*Warning*: array_keys()
[function.array-keys<http://adcinfops01/function.array-keys>]:
The first argument should be an array in */usr/local/httpd-2.0.54
/htdocs/oratest.php* on line *15*

*Warning*: Invalid argument supplied for foreach() in */usr/local/httpd-
2.0.54/htdocs/oratest.php* on line *16*

*Warning*: ocifreestatement(): supplied argument is not a valid
OCI8-Statement resource in */usr/local/httpd-2.0.54/htdocs/oratest.php* on
line *25*


Everything is identical. (SID, dbname, etc....)

Here is my listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = adcdm02)
(ORACLE_HOME = /u01/app/oracle/product/10.2)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adcinfops01)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = DMKEY))
)
)
)

In tnsnames.ora:
ADCDM02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =
adcinfops01.mydomain.com<http://adcinfops01.mydomain.com>)(PORT
= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = adcdm02.mydomain.com <http://adcdm02.mydomain.com>)
)
)

Here is a snippet of code I am trying:
putenv("ORACLE_SID=adcdm02");
putenv("ORACLE_HOME=/u01/app/oracle/product/10.2");

$ora = OCILogon("dm","password", "ADCDM02");

$stmt=OCIParse($ora, "select USERNAME from dba_users");
$res=OCIExecute($stmt);

Anyone have any ideas?
Thanks,
CC

Reply via email to