• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6798
  • Last Modified:

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?
0
abuabdallah
Asked:
abuabdallah
  • 4
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
You may may an issue requiring the use of a thick JDBC driver, but a number of sources suggest adding this string to sqlnet.ora on both the client and server:

SQLNET.ALLOWED_LOGON_VERSION = 10
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
But Oracle Developer 6i is very old, right? Considered upgrading?
0
 
DavidSenior Oracle Database AdministratorCommented:
Author, any update to my comment please.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
abuabdallahAuthor Commented:
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.
0
 
abuabdallahAuthor Commented:
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
0
 
abuabdallahAuthor Commented:
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.
0
 
abuabdallahAuthor Commented:
thank you for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now