php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8673 ora-01034 when accessing remote SID
Submitted: 2001-01-12 07:28 UTC Modified: 2001-02-18 06:34 UTC
From: christoph dot hofstetter at bit dot admin dot ch Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.4 OS: aix433
Private report: No CVE-ID: None
 [2001-01-12 07:28 UTC] christoph dot hofstetter at bit dot admin dot 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;                                                                 
}                                                                       

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-14 17:27 UTC] 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-30 04:49 UTC] sniper@php.net
reclassified

 [2001-02-18 06:34 UTC] thies@php.net
please set all oracle-specific env-vars before you start 
apache!


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 06 01:01:29 2024 UTC