ORA-28040: No matching authentication protocol

Hi!

 

After updating  datebase to version 12.1.0.2.2 RDBMS, stopped working job.
Error below:

  File "<string>", line 2, in ?
  File "SCRIPT_TEST", line 92, in DiscoveryMain

line 2: from java.util import Properties

ERROR class = "java.sql.SQLException">
<Message> [CDATA&colon; [Oracle] # 3 ORA-28040: No matching authentication protocol] </ message>
<Stacktrace>
<Frame class = "com.inet.ora.OraDriver" method = "a" file = "unknown" line = "- 1" />
<Frame class = "com.inet.ora.n" method = "a" file = "unknown" line = "- 1" />
<Frame class = "com.inet.ora.n" method = "long" file = "unknown" line = "- 1" />
<Frame class = "com.inet.ora.n" method = "& lt; init & gt;" file = "unknown" line = "- 1" />
<Frame class = "com.inet.ora.OraDriver" method = "connect" file = "unknown" line = "- 1" />
<Frame class = "com.hp.ucmdb.discovery.library.clients.protocols.sql.SqlUtil $ ConnectionThread" method = "run" file = "SqlUtil.java" line = "140" />
</ Stacktrace>
Version UCMDB 9.05
Version DDM Probe 9.05CUP14

Java: Version 7 Update 40
 
In the discovery job, there is a connection to the database, collect the necessary information and UCMDB created CI.
Connect using SQL Developer and perform the necessary inquiries with DDMProbe obtained.

Parents
  • Verified Answer

    Sorry for this post

     

    Solution:

    Bug 14575666

    In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.

    This will cause a 10.2.0.5 Oracle RAC database creation using DBCA to fail with the ORA-28040: No matching authentication protocol error in 12.1 Oracle ASM and Oracle Grid Infrastructure environments.

    Workaround: Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle/network/admin/sqlnet.ora file.

  • Hi, we are using 11.20 Sitescope Version and trying to configure alerts for 12.1.0.2 DB, receving the error:ORA-28040: No matching authentication protocol

     

Reply Children
No Data