php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: christoph dot hofstetter at bit dot admin dot ch
New email:
PHP Version: OS:

 

 [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: Sat Dec 21 13:01:31 2024 UTC