Connecting to Oracle 9i with no listener

From: John (isofroni_at_cc.uoi.gr)
Date: 03/18/04 

To: "DBI-Users" <dbi-users@perl.org>
Date: Thu, 18 Mar 2004 11:37:52 +0200

How to get connected to an oracle server with not listener?

Which one is the correct?

         $dbh = DBI->connect('dbi:Oracle:T:Machine:SID','username','password')

         $dbh = DBI->connect('dbi:Oracle:','username@T:Machine:SID','password')

         $dbh = DBI->connect('dbi:Oracle:','username@DB','password')

         $dbh = DBI->connect('dbi:Oracle:DB','username','password')

         $dbh = DBI->connect('dbi:Oracle:DB','username/password','')

         $dbh = DBI->connect('dbi:Oracle:host=foobar;sid=ORCL;port=1521', 'scott/tiger', '')

         $dbh = DBI->connect('dbi:Oracle:', q{scott/tiger@(DESCRIPTION=
         (ADDRESS=(PROTOCOL=TCP)(HOST= foobar)(PORT=1521))
         (CONNECT_DATA=(SID=ORCL)))}, "")

The script and the Oracle is on the same server and i don't want to use listener to do the job.

Thanks for you help in advance.