Code broken after upgrading from Oracle 10.1.0.4 to 10.2.0.1
| From: | Chuck | Date: | Wed, 28 Sep 2005 19:06:31 +0000 |
| Subject: | Code broken after upgrading from Oracle 10.1.0.4 to 10.2.0.1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-223377@lists.php.net to get a copy of this message | ||
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