Bug #6 [Com]: Cannot connect to remote Oracle machine

Edit report at https://bugs.php.net/bug.php?id=6&edit=1 ID: 6 Comment by: junxing dot lin at yahoo dot com Reported by: kennh at sierra dot com Summary: Cannot connect to remote Oracle machine Status: Closed Type: Bug Package: Oracle related Operating System: Solaris PHP Version: 3.0b3 Block user comment: N Private report: N New Comment: http://www.chishairstraighteners.net chi flat iron http://www.chishairstraighteners.net chi flat irons http://www.chishairstraighteners.net chi hair straightener http://www.chishairstraighteners.net chi hair straighteners Previous Comments: ------------------------------------------------------------------------ [2010-11-09 04:28:39] aharvey@php.net Automatic comment from SVN on behalf of aharvey Revision: http://svn.php.net/viewvc/?view=revision&revision=305216 Log: Updated example per doc bug #53269 (Fatal error in Example #6). ------------------------------------------------------------------------ [1998-01-29 07:53:54] ssb I never heard any "success reports" on SQL*Net. Checking if he is able to connect with sqlplus. Okay, it turns out that he was using the wrong logon name (should use "username@WG73"). This should be added to the documentation for Ora_Logon. ------------------------------------------------------------------------ [1998-01-26 16:09:07] kennh at sierra dot com I am not sure if this is a bug or if I am doing something, wrong. Here is the email that I previously sent to the email list: I am banging my head against the wall on this one. How do I need to set the environmental variables to connect to a remote Oracle machine? Note that the actual machine is behind a firewall, but I have a static IP route to it. I have already tried: PutEnv("ORACLE_HOME=/db/oracle7/"); PutEnv("ORACLE_SID=WG73"); PutEnv("WGSHOST=dbmachine.foo.com"); and: PutEnv("ORACLE_HOME=/db/oracle7/"); PutEnv("ORACLE_SID=WG73@dbmachine.foo.com"); and: PutEnv("ORACLE_HOME=/db/oracle7/"); PutEnv("ORACLE_SID=WG73_tcp_dbmachine.foo.com"); and: PutEnv("ORACLE_HOME=/db/oracle7/"); PutEnv("ORACLE_SID=WG73_tcp@dbmachine.foo.com"); but none seem to work. Thanks, Kenn Herman Assistant Technical Webmaster Sierra Online Services ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=6&edit=1