Connecting to a remote Oracle database

Anon

I am trying to connect to an Oracle database on another machine. My web server is running Apache on a Linux box with PHP. The Oracle 8i database is on an NT Server. The address of the NT box is //Ches_csu_nt1. The database name is DIT1. Am I able to connect to the Oracle database? I've seen a lot of articles on using PHP with Oracle, but they always seem to be on the same box.

Anon

It should be possible. You need to install the Oracle Client libraries on your linux box and configure it to connect to the Server on the NT box.

You should then be able to reference the correct ORACLE_SID and have it point to the remote box.

Anon

just setup correctely your tnsnames.ora for your SID :
someting like :
YOUR_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = YOUR.world)
(PROTOCOL = TCP)
(Host = IP_ADDRESS)
(Port = 1521)
)
)
(CONNECT_DATA =
(YOUR_SID = O734D1)
)
)

make sure your listener is up and running and listens for this database. ( check listener.ora and do a lsnrctl status)

Test your oracle connection outside php ( with sql*plus for example ).

Compile php with oracle enabled ( --with-oracle or --with-oci8 ) ( that is the tricky bit )

add your php module to apache.
stop/start apache

try to connect to oracle with php :
for ex :
<?
$conn = ora_logon('USER@YOUR_SID', 'PASSWORD );
$curs = ora_open( $conn );
ora_parse( $curs, "SELECT count(*) FROM USER_OBJECTS" );
ora_exec( $curs );
ora_fetch( $curs );
$result = ora_getcolumn($curs, 0 );
ora_close( $curs );
echo "RESULT :" . $result;
?>

BAsically, oracle does not have to be on the same machine as apache/oracle. The only thing is that you have to set up correctely your env. If u can use your remote database outside php, u will be able to use it inside.

Anon

hi all

I am trying to do the same, ie
I am using php3, with apache_1.3.6 on sun solaris.
My oracle database is on an other sun solaris machine.
I configure my php with following option,
--with-oci8

because if I want to configure with
--with-oracle option , it cannot find files like oci.h ( i do not know why).

But with the oci8, my installation goes on fine.
but when i write my php scirpt and try to use the oci8
functions, I get an error that "call to unsupported or undefined function".

Please help, thanks in advance

-rehan
tahir.2@osu.edu

Anon

hi,
for oci.h : it tries prob to read it from $ORACLE_HOME/rdbms/public as it is in $ORACLE_HOME/rdbms/demo. Put the include files where it wants them to be.
You may after that have to add the option -lclntsh to EXTRA_LIBS in config_vars.mk in order to link the libclntsh.so library.
Do it after running configure.
After that should be OK
For oci8, send more details pls.
hope this helps.
frenchhud

rehan wrote:

hi all

I am trying to do the same, ie
I am using php3, with apache_1.3.6 on sun solaris.
My oracle database is on an other sun solaris machine.
I configure my php with following option,
--with-oci8

because if I want to configure with
--with-oracle option , it cannot find files like oci.h ( i do not know why).

But with the oci8, my installation goes on fine.
but when i write my php scirpt and try to use the oci8
functions, I get an error that "call to unsupported or undefined function".

Please help, thanks in advance

-rehan
tahir.2@osu.edu

Anon

thanks for your reply.

But where is oci.h, oratypes.h
Is it supposed to come with the PHP
installation. My oracle server resides on
a different solaris machine than where my web
server exist. I currently have JDBC on
my web server machine. TO make the PHP,
Oracle connection do I need someother driver, or does the PHP installation allready
has one. Can you please tell me which driver
I need. From where can I get it.

I have allready started working on JSP, after
days of futile struggle with PHP. 🙂

When I use the OCI configuration option,
my configuration goes on fine, and so does
the PHP , Apache compliation and installation. But when I try to use the
OCI fucntions, PHP grumbles that it does
not support that function.

I am using PHP3 with apache_1.3.6

Thanks, your mail added a ray of hope
to my miserable PHP experience.

-rehan

Anon

Hi,
if u still ask that, it prob means u do not have any oracle layer on your linux box.
U need at least an oracle client on your machine.
Did try access oracle with another tool , i.e. JSP or simply sql*plus ?
If it does not work, find an oracle client for your distribution ( oracle technet may help , but u can find some on the net or mail me ).
After that do a find in the oracle env, for your includes and do as stated in previous mails.
take care
frenchhud

ahsanrauf

hi frenchud

i have read ur way to connect to oracle remote DB . i have same thing like my application which is on php is running on unix which doesnt have oracle. but i want to connect to oracle DB which is on a remote server so what things i need to make it possible that i can connect remote db the remote DB is on nt . please if u can help me it will highly appreciated

ahsan