Re: RFC: Oracle Perl Connection

To avoid the need for a tnsnames.ora entry, I've been using:

my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=1521",$use
+r,$passwd);
[download]

This is working with Oracle 10.2.0.[34], DBI 1.602, and DBD::Oracle 1.17.

Comment on Re: RFC: Oracle Perl Connection Download Code

Replies are listed 'Best First'.
Re^2: RFC: Oracle Perl Connection by Anonymous Monk on Nov 25, 2009 at 12:59 UTC
I had to export SHLIB_PATH also .. export SHLIB_PATH=/usr/oracle/product/9ias/lib	[reply]
Re^2: RFC: Oracle Perl Connection by cristianabs (Initiate) on Jan 14, 2014 at 19:27 UTC
Well I did all you mentioned, but now I've this in the terminal: `DBI connect('database=10.0.249.18;sid=BDSGCOPP;port=1521','CCARVAJAL', +...) failed: Can't connect using this syntax without specifying a HOS +T and one of SID INSTANCE_NAME SERVER SERVICE_NAME` [download] :/	[reply] [d/l]
Re^3: RFC: Oracle Perl Connection by runrig (Abbot) on Jan 14, 2014 at 20:41 UTC
'host=...', not 'database=...'	[reply]
Re^2: RFC: Oracle Perl Connection by Anonymous Monk on Sep 11, 2015 at 06:31 UTC
thank you for this solution without tnsnames.ora. It works	[reply]