PHP 4.0 Bug #8673 Updated: ora-01034 when accessing remote SID
| From: | sniper@php.net | Date: | Tue, 30 Jan 2001 09:49:14 +0000 |
| Subject: | PHP 4.0 Bug #8673 Updated: ora-01034 when accessing remote SID | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-45358@lists.php.net to get a copy of this message | ||
ID: 8673
Updated by: sniper
Reported By: christoph.hofstetter@bit.admin.ch
Status: Open
Old-Bug Type: Oracle related
Bug Type: OCI8 related
Assigned To:
Comments:
reclassified
Previous Comments:
---------------------------------------------------------------------------
[2001-01-14 17:27:41] sniper@php.net
User update:
---------
I found a workaround for the ora-01034 problem: I specify the SID as the third argument to
OCILogin.
Now I get ora-01005 (no password given).
this only happens when accessing a remote db!
------------
Please, only one report per bug.
--Jani
---------------------------------------------------------------------------
[2001-01-12 07:28:00] christoph.hofstetter@bit.admin.ch
I get an ora-01034 trying to connect to a remote oracle 8.1.6.0.0 database. everything works fine
for local databases. I can access the remote database with sqlplus, but not with php.
configure line:
./configure --with-oracle=$ORACLE_HOME
--with-oci8
--enable-discard-path
--without-mysql
--enable-track-vars
code from the script:
$ORACLE_HOME="/appl/ora/product/7.3.4.3.0";
$ORACLE_SID="X010";
PutEnv "ORACLE_HOME=$ORACLE_HOME");
PutEnv "ORACLE_SID=$ORACLE_SID");
$connection = OCILogon "scott","tiger");
if ($connection == false){
echo OCIError($connection; exit;
}
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=8673