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
