Oracle Community Network
Learn database technology with Oracle Senior DBA Group. The group will feature latest updates, knowledge blogs, events and job postings. Contribute your oracle experience
Latest Activity: Nov 30, 2015
Started by Boyce Helgren. Last reply by Louie Ormand Jan 30, 2014. 1 Reply 0 Likes
Hi All,Sorry if I asked more questions below, please help to understand this.1. I have 2 ora databases in one server, have different SID and TNS.The backup for DB1 with SID1 in rman script is…Continue
Hi.. when i am log in through PLSQL developer at that time i am getting error " ORA-28040: NO MATCHING AUTHENTICATION PROTOCOL " Oracle Database 12C Enterprise Edition Release 220.127.116.11.0 - 64bit production Thanks..
What version of JDBC driver you have. It has to be at least 11G JDBC driver.
I have windows8 operating system so JDBC driver is not installed.
Then how do you setup Oracle connection?
Actually it is connecting through sql plus but from plsql developer (third party) it is not connection and showing ORA-28040: NO MATCHING AUTHENTICATION PROTOCOL).
Then, most likely, third party tool is nor certified for 12C/11G. You could try adding SQLNET.ALLOWED_LOGON_VERSION to both client and server side SQLNET.ORA.
we are using plsql developer tool of Allround Automations as well as oracle forms 6i and after adding SQLNET.ALLOWED_LOGON_VERSION to both client and server side SQLNET.ORA. i am getting same error mesg...
using plsql developer tool of Allround Automations as well as oracle forms 6i
You might be using an Oracle 8i client. It wouldn't be certified with a 12c database.
I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi.
Forms 6i doesn't use a 10g client.
Check if Allround Automation and Forms 6i are using the same Oracle Client Home or two different Oracle Client Homes.
I presume, then, that Allround Automation is using the 10g client.