Hello
We've had DBI/DBD::Oracle scripts working for many years
now doing a local connect like this:
my $db_handle = DBI->connect( $ENV{'ORACLE_SID'}, $username, $password,
"Oracle");
Now, after an Oracle upgrade (7.3.4->8.1.6), this statement fails
with the message:
ORA-12154 TNS: Could not resolve service name (DBD ERROR: OCIServerAttach)
The program now seems to think that the ORACLE_SID string is a remote
database identifier in tnsnames.ora rather than a SID for a local database.
We find that these solutions work:
my $db_handle = DBI->connect( "", $username, $password, "Oracle");
my $db_handle = DBI->connect( "dbi:Oracle:", $username, $password);
Question is - did the ability to supply an Oracle SID for a local
connection become obsolete in DBI/DBD::Oracle? Or is there some setting
or configuration that will still allow this feature?
Thanks,
Steve Turner
