[PHP-DEV] PHP 4.0 Bug #8673 Updated: ora-01034 when accessing remote SID From: sniper <email protected>
Date: 01/30/01

ID: 8673
Updated by: sniper
Reported By: christoph.hofstetter <email protected>
Status: Open
Old-Bug Type: Oracle related
Bug Type: OCI8 related
Assigned To:
Comments:

reclassified

Previous Comments:
---------------------------------------------------------------------------

[2001-01-14 17:27:41] sniper <email protected>
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 <email protected>
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 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>