ociparse
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.
Descrição
Esta função é um apelido para: oci_pconnect().
add a note
User Contributed Notesociplogon
M0no at ethonfusino dot com
21-Nov-2002 10:04
21-Nov-2002 10:04
kakukkfu at mailbox dot hu
26-Sep-2002 11:09
26-Sep-2002 11: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 07:26
06-Apr-2001 07: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
07-Feb-2001 07:17
07-Feb-2001 07: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 12:03
02-Aug-2000 12: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);
?>