Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I am not able to connect to oracle database even though i am using following syntax $dbh = DBI->connect('dbi:Oracle:host=<host>;sid=<sid name>;port=1523','user name','password', { RaiseError => 1, AutoCommit => 0 }); i am getting following error failed: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) Can anybody help me please?

Replies are listed 'Best First'.
Re^4: RFC: Oracle Perl Connection
by Corion (Patriarch) on May 30, 2012 at 07:49 UTC

    This is a database problem. Ask your database administrator about the error number and the causes. Most likely, you got the wrong SID name, as the error message says.

[reply]

Back to Seekers of Perl Wisdom