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
