my $port = '1521';
my $orcs = "dbi:Oracle:host=$host;port=$port;sid=$dbname";
Works here,
HTH
"Christian Merz" <[EMAIL PROTECTED]> wrote in message
012101c2a69c$faecff20$[EMAIL PROTECTED]">news:012101c2a69c$faecff20$[EMAIL PROTECTED]...
> Hi folks,
> my 'perldoc DBD::Oracle' says in 'CONNECTING TO ORACLE':
> 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.
> but I don't know how to specify a port number. But I would like to do so
> as we are using different ports.
>
> I tried both:
> $host = 'my_host.my_domain 1521';
> $host = 'my_host.my_domain:1521';
> $dbh = DBI->connect( "dbi:Oracle:host=$host;sid=$sid", $user, $passwd )
> || die "cannot connect to oracle\n $DBI::errstr\n";
> I only get: ORA-12545: (DBD ERROR: OCIServerAttach)
> (without the port specification the connection works fine.)
>
> Any suggestions?
> Is the only solution TWO_TASK via SQL*Net V2?
> ---------------------------------------------------------
> Landeshauptstadt M�nchen
> Direktorium - AFID 3.3 - Oracle DBA
> C.A. Merz
>
