Link to home
Create AccountLog in
Oracle Database

Oracle Database

--

Questions

--

Followers

Top Experts

Avatar of abuabdallah
abuabdallah

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?

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION
Avatar of David VanZandtDavid VanZandt🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of Gerwin JansenGerwin Jansen🇳🇱

But Oracle Developer 6i is very old, right? Considered upgrading?
Avatar of David VanZandtDavid VanZandt🇺🇸

Author, any update to my comment please.
Avatar of abuabdallahabuabdallah

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.
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of abuabdallahabuabdallah

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
Avatar of abuabdallahabuabdallah

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.
Avatar of abuabdallahabuabdallah

ASKER

thank you for your help
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Oracle Database

Oracle Database

--

Questions

--

Followers

Top Experts

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.