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
Connection error
Re: Connection error
hello,
Please make sure that you have inserted the SQLNET.ALLOWED_LOGON_VERSION=12 line to both client and server SQLNet.ora files.
Please make sure that you have inserted the SQLNET.ALLOWED_LOGON_VERSION=12 line to both client and server SQLNet.ora files.
Re: Connection error
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
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
Re: Connection error
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
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
Re: Connection error
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.
When I tried running it on the server with an 11.2.0.3 client, that seemed to work just fine.
When would this protocol be used? Only when client and server are different machines?Presently, ODAC doesn't support authentication protocol 12, this protocol will be supported later.
Re: Connection error
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)
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)
Re: Connection error
Oh, OK. Thank you for your help!