Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PERL DBI connection to Remote Oracle Database

Re: PERL DBI connection to Remote Oracle Database

From: Mike Bates <sxmwb_at_comcast.net>
Date: Tue, 28 Aug 2007 12:51:01 -0600
Message-ID: <46D46E95.8070306@comcast.net>


Can you access this database via SQLPlus from the machine you are running Perl DBI on? SQLPlus does not work then Perl DBI will not work.

Mike

Sanjay Mishra wrote:
> Hi
>
> I am working on exsiting Perl program and found that it is usinf DBI
> to connect to Remote Database . The string used to connect the
> Remote database doesn't have PORT. Connection is going fine. Remote
> database is listening on PORT 1523 and not the Default 1521.
>
> I checked the Manual and it says the following but still not clear
> as if it only check on 1521 and 1526 or others. Any ideas as how it
> will work if Port is not specified like even shown below in the Doc
> statement
>
>
> Connecting without environment variables or tnsname.ora file
>
> If you use the |host=$host;sid=$sid| style syntax, for example:
> $dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user,
$passwd);
> then DBD::Oracle will construct a full connection descriptor string
> for you and Oracle will not need to consult the tnsname.ora file.
> If a |port| number is not specified then the descriptor will try
> both 1526 and 1521 in that order (e.g., new then old). You can check
> which port(s) are in use by typing "$ORACLE_HOME/bin/lsnrctl stat"
> on the server.
>
> Sanjay
>
> ----------------------------------------------------------------------
> Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge
> <http://us.rd.yahoo.com/evt=47093/*http://tv.yahoo.com/collections/222>to
> see what's on, when.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 28 2007 - 13:51:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US