Devart Forums

Hello,

Oracle Metalink ID 1492721.1 recommends setting this parameter in SQLNet.ora to fix a security issue.

However, when I try that, and attempt to make a connection to the database with a TOraSession, the connection fails with ORA-00000.

What can I do to fix this? I am using Oracle client 11.2.0.3, Oracle Server 11.2.0.3, Delphi XE2 and the current ODAC version.

Thanks,

John Dorlon

hello,

Please make sure that you have inserted the SQLNET.ALLOWED_LOGON_VERSION=12 line to both client and server SQLNet.ora files.

Hello,

I tried that but then I just get a different error. I noticed that I am having the same problems in SQL*Plus, so this is not an ODAC problem. Thanks for your help and sorry to raise the issue here.

-John

hello,

We have checked our ODAC components behaviour in the OCI mode (and with a standard SQL Plus utility) when working with Oracle server 11.2.0.3 and enabled SQLNET.ALLOWED_LOGON_VERSION=12 option (the client and the server are installed on the same PC), and the connection with the database occurs with no errors. Presently, ODAC doesn't support authentication protocol 12, this protocol will be supported later.
Maybe you are using an older Oracle client, please make sure that Oracle client 11.2.0.3 is set by default, otherwise, set it explicitly in the Home property

Thank you. I was using 11.2.0.3 server but only 11.2.0.1 client.

When I tried running it on the server with an 11.2.0.3 client, that seemed to work just fine.

Presently, ODAC doesn't support authentication protocol 12, this protocol will be supported later.

When would this protocol be used? Only when client and server are different machines?

Hello,

That meant that ODAC doesn't support this protocol in the Direct mode, this protocol is implemented in the Oracle client, so ODAC will work correctly in the OCI mode independently on what PC the client and the server are located (on one and the same or on different ones)

Oh, OK. Thank you for your help!