Getting ORA-28040 during HDBSetup

Document ID:  TEC1696576
Last Modified Date:  07/03/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Harvest Software Change Manager

Releases

  • CA Harvest Software Change Manager:Release:13.0

Components

  • CA Harvest Software Change Manager:CCCHV
Problem:

When running the "CR" option in HDBSetup, getting error message: 28040 [CA Harvest SCM][ODBC 20101 driver]ORA-28040: No matching authentication protocol

Cause:

Seems to be related to having differing versions of Oracle database and/or Oracle Client and/or ODBC software.

Here’s a link from the Oracle community that gives us a hint: https://community.oracle.com/thread/2349728

Resolution:

DBA updated the sqlnet.ora file on the Oracle server machine and added the following line:

SQLNET.ALLOWED_LOGON_VERSION=8

This should allow older versions of the Oracle ODBC driver to connect to Oracle server.  After restarting the Oracle server the error message did not appear again.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing