I just finish to configure an oracle environment for remote connection to Oracle.
Here is what you need
1) I install all new OS patches and update
2) install oracle client on the remote computer and test connection with SQLPLUS
3) install latest perl (i used 5.8.0)
4) install DBI and DBD::Oracle from CPAN (latest version)
5) give the good access permission to your oracle_home directory (I use 755 on unix)
6) copy your profile file from oracle to the current user (I used apache user for my apache web server)
7) test SQLPLUS from this user
8) if you intend to use apache web server to access cgi that will use DBI/DBD::Oracle you need to set your environment in the httpd.conf file. I add all oracle environment variable in my virtual host directive in the httpd.conf file.
This should work fine
Armand Brisson
Juan David Fern�ndez Garrido wrote:
I want connect to a remote Oracle server host. Into the client I don't have
install Oracle, so when I install DBD-Oracle fails because I don't have the
ORACLE_HOME... into my system. How can I do it? Must to be Oracle and Perl
into the same machine?
-----Original Message-----
From: Juan David Fern�ndez Garrido
To: '[EMAIL PROTECTED]'
Sent: 06/11/2002 17:40
Subject: Connection to remote DB
At this moment,I only have done connections to local DB. But, can I do
connections from a host without a DB, installing into the client the
correct DBD, to a host DB server? Does the S.O. must be the same into
client and server?
Thanks
