Tuesday, August 11, 2015

ORA -28040 no matching authentication protocol

Effect - JDeveloper/FormBuilber/ReportBuilder are not able to connect database(12c only)
Solution -
1) cd $ORACLE_HOME (Database)
2) cd network/%SID%/admin
3) vi sqlnet.ora
add following parameters
SQLNET.ALLOWED_LOGON_VERSION_server=8
SQLNET.ALLOWED_LOGON_VERSION_client=8
4) Retest the issue
Posted by at
Location: Doha, Qatar

3 comments:

  1. பகத் | BHAGATH | சிங் | SINGHAugust 11, 2015 at 5:49 PM

    Hi Aditttya..Thanks for the post. It resolved all my issues. You look gr8 !!!

    ReplyDelete
  2. Aditya SinghAugust 12, 2015 at 10:58 AM

    Thanks Bhagath, That's great the post is helpful to you. For any other DBA related issues you can post me ,i'll try to add those as well in the blog.

    ReplyDelete
  3. Oracle e-Business SuiteMay 5, 2017 at 12:52 PM

    Thank you Aditya...It resovled my issue...

    ReplyDelete

Subscribe to: Post Comments (Atom)

Oracle Database Administrator