PHP 4.0 Bug #8673 Updated: ora-01034 when accessing remote SID
| From: | thies@php.net | Date: | Sun, 18 Feb 2001 11:34:15 +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-46832@lists.php.net to get a copy of this message | ||
ID: 8673
Updated by: thies
Reported By: christoph.hofstetter@bit.admin.ch
Old-Status: Open
Status: Closed
Bug Type: OCI8 related
Assigned To:
Comments:
please set all oracle-specific env-vars before you start
apache!
Previous Comments:
---------------------------------------------------------------------------
[2001-01-30 04:49:14] sniper@php.net
reclassified
---------------------------------------------------------------------------
[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;
}
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=8673&edit=2