PERL DBI connection to Remote Oracle Database

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 28 Aug 2007 07:42:24 -0700 (PDT)
Message-ID: <481613.75536.qm@web51305.mail.re2.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 28 2007 - 09:42:24 CDT