njihan njihan - 6 months ago 135
Perl Question

Perl DBI connecting to Oracle 12c

I'm using Perl DBI & trying to connect to Oracle 12c. I get an error:


DBI connect('host=serverip;sid=comms;port=1521','comms',...) failed:
ORA-28040: No matching authentication protocol (DBD ERROR:
OCISessionBegin)


My connection is:


DBI->connect($connectionString, $user, $passwd,{PrintError=>1,
RaiseError=>1, AutoCommit=>1})


Would like to know if DBI can connect to Oracle 12c? Should I change to use something else?

Am new to Perl, so any help very much appreciated.

Thank You.

Answer

Seems like an issue with the sqlnet.ora file. The parameters might not be same for the sqlnet.ora file in the client-side and server-side.

Since you have not posted all the details, there could be more than one issue. however, the most common is the SQLNET.ALLOWED_LOGON_VERSION.

Read the Database Net Services Reference documentation for more details on Parameters for the sqlnet.ora File.