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. -- //www.freelists.org/webpage/oracle-l