ora-28040 while connecting to 19c database

nikos74nikos74 Posts: 10 New member
edited June 26, 2020 8:35AM in Source Control for Oracle
hallo, Connecting to 19c database  I am getting ora-28040 , Is a problem of ojdbc and if so is there a property file where I can add ojdb8.jar? Inside the OracleClient11g folder there is the ojdb6.jar

Thanks in advance
Tagged:

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi, thank you for your forum post.

    You can download the ojdbc8.jar file from here. Once downloaded copy it into your OracleClient11g folder.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • nikos74nikos74 Posts: 10 New member
    edited June 29, 2020 9:17PM
    I did it and I am stil getting the same error. I just copied without changing anyhting else (e.t.c path, environment variable) or sth that is used  from Oracle source control to use the Oracleclient11g
  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi Nikos74,

    Does the advice in this Internet article help to resolve the problem?

    Under $ORACLE_HOME/network/admin Set the parameter  SQLNET.ALLOWED_LOGON_VERSION_SERVER to 11, in case sqlnet.ora file is not exist under  $ORACLE_HOME/network/admin then create it.

    [On the Database Server by the oracle user]
    Add SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 to sqlnet.ora file:

    vi $ORACLE_HOME/network/admin/sqlnet.ora

    SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • nikos74nikos74 Posts: 10 New member
    We installed client OracleBD_12c and the issue has been resolved
Sign In or Register to comment.