If your oracle database is on a remote system within your local network and you don't want to worry about the tnsnames file you can try this.
$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XX.XXX)(PORT = 1521)))(CONNECT_DATA=(SID=XXXX)))";
$c1 = ocilogon("name","password",$db);
Hope this helps someone.
説明
この関数は次の関数のエイリアスです。 oci_pconnect().
ociplogon
M0no at ethonfusino dot com
22-Nov-2002 03:04
22-Nov-2002 03:04
kakukkfu at mailbox dot hu
27-Sep-2002 03:09
27-Sep-2002 03:09
Better to insert needed variables into apache(!) (or your webserver - respectively) start script.
For example on UNIX systems /etc/init.d/apache would contain following lines before anything else:
#!/bin/bash
if [ -f ~oracle/.profile ]; then
source ~oracle/.profile
fi
The ~oracle/.profile has the appropiate settings to start an Oracle database so it is always up-to-date for PHP, too. (If settings are changed, don't forget to restart your webserver.) This way you just no need to worry what to include or define for PHP.
e dot v dot wijk at hetnet dot nl
06-Apr-2001 11:26
06-Apr-2001 11:26
The solution for not being able to connect to an Oracle database usually is setting the right system variables (ORACLE_HOME, etc...). However, it often happens that you are still not able to connect, even though these settings are correctly set.
If this is the case, try the following:
Instead of refering to the entry in the tnsnames.ora, use the actual string from the tnsnames.ora:
$User = "john"
$Password = "doe"
$Database = "(DESCRIPTION = ADDRESS_LIST (ADDRESS = (PROTOCOL= TCP (Host= yourhost) (Port= 1526)))(CONNECT_DATA = (SID = YourTnsSID )))";
OCIPLogon($User, $Password, $Database)
I hope this is helpfull for those strugling to connect to an Oracle database.
Edwin van Wijk
steve at stevedix dot de
08-Feb-2001 12:17
08-Feb-2001 12:17
IF you're wondering exactly what you are dealing with, here's a brief explanation: Oracle is NOT like mysql, which makes it very easy to connect between databases. Oracle uses a product called sql*net to control connection between remote machines, clients and databases. It is capable of operating on multiple different network protocols, and requires listeners to be configured for the network protocol you plan to use (usually tcp). This system has its own domain name system which rationalises database names with machines (which is why you don't have a host variable in the OCIPlogin). Configuring these listeners is not easy and requires the editing of two files tnsnames.ora and sqlnet.ora. Even more important is to make sure that the oracle environment variable TNS_ADMIN points to the place where you put tnsnames.ora and sqlnet.ora
A good place to start reading about this is
http://www.atr.net/faq/software/FRONT_END/faqnet.htm
A more detailed version can be found at :
http://www.orafaq.net/faqnet.htm
Bear in mind that this is an incredibly complex product and not something that you should really be playing with if you don't know what you're doing. I've seen (otherwise) experienced oracle admins baulk at configuring sql*net. Pat solutions (like the one above) cannot be used verbatim - you will need to know and substitute several symbolic names.
HTH
michel at diefirma dot de
02-Aug-2000 04:03
02-Aug-2000 04:03
After hours of weird searching and "try an error"-games with oracle and php I've got my working system with connection to a remote oracle server. Yeah! Documentation is very bad for this topic and the posts in all the mailing lists are very confusing. But now...
cheers. it works!
here my working sample code (php4 on debian, oracle 8.1.5.0.2 client, oracle 8i enterprise server on win2k)
michel
<?php
$user = "scott";
$pass = "tiger";
$tns_name = "my_service_name_in_tnsnames.ora";
// set ORACLE Dir to get the NET8 name resolver working
// tnsnames.ora has to be in $ORACLE_HOME/networking/admin/
putenv("ORACLE_HOME=/home/oracle01/app/oracle/product/8.1.5");
// log on to oracle server using data above
$db_id = OCILogon ($user, $pass, $tns_name);
?>