RE: PERL DBI connection to Remote Oracle Database
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 28 Aug 2007 10:33:13 -0700 (PDT)
Ron
It is working and I am trying to understand as how it is making connection
even the Port is not defined. On Remote DB server, I am running two listener.
How this program use SID defined in Perl to connect to correct instance.
"Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:
My guess is it won't make a connection except for the default ports.
What happens if you try it yourself with a small program?
Ron Reidy
Lead DBA
---------------------------------
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sanjay Mishra
Sent: Tuesday, August 28, 2007 8:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: PERL DBI connection to Remote Oracle Database
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 to see what's on,
when. This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.
Other related posts:
