asked on

cannot connect oracle database to developer

Hello,

I installed oracle database 12c and installed oracle developer 6i
on windows 8 operating system.
When I try to connect developer to database the following error appeared

ora-28040: no matching authentication protocol

how to solve this error and connect developer to database?

ASKER CERTIFIED SOLUTION

David VanZandt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gerwin Jansen

But Oracle Developer 6i is very old, right? Considered upgrading?

David VanZandt

Author, any update to my comment please.

abuabdallah

ASKER

sorry for delay but i tried this option and i added this line

SQLNET.ALLOWED_LOGON_VERSION = 10

to sqlnet in server and client but same error appeared again

and i using developer 6 from long time i will upgrade as soon as possible.

abuabdallah

ASKER

just i want to know some body connect developer 6i to oracle database under windows 8 or it is not compatible with windows 8 and cannot connect it to oracle 12c under windows 8

abuabdallah

ASKER

The problem solved

the parameter value must be 8
SQLNET.ALLOWED_LOGON_VERSION=8

on server only

Bug 14575666

In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.

This will cause a 10.2.0.5 Oracle RAC database creation using DBCA to fail with the ORA-28040: No matching authentication protocol error in 12.1 Oracle ASM and Oracle Grid Infrastructure environments.

Workaround: Set SQLNET.ALLOWED_LOGON_VERSION=8 in the $crs_home/network/admin/sqlnet.ora file.

abuabdallah

ASKER

thank you for your help