Oracle Senior DBA Group

74 members

Description

Learn database technology with Oracle Senior DBA Group. The group will feature latest updates, knowledge blogs, events and job postings. Contribute your oracle experience

Comments Discussions Members

  • Dagmar Dubois

    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 12.1.0.1.0 - 64bit production Thanks..

    Jan 21, 2014

  • Kory Wass

    What version of JDBC driver you have. It has to be at least 11G JDBC driver.

    KW

    Jan 21, 2014

  • Dagmar Dubois

    I have windows8 operating system so JDBC driver is not installed.

    Jan 21, 2014

  • Kory Wass

    Then how do you setup Oracle connection?

    KW

    Jan 21, 2014

  • Dagmar Dubois

    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).

    Jan 21, 2014

  • Kory Wass

    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.

    KW

    Jan 21, 2014

  • Dagmar Dubois

    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...

    Jan 21, 2014

  • Quincy Sunday

    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.

    Jan 21, 2014

  • Dagmar Dubois

    I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi.

    Jan 21, 2014