Friday 6 August 2010

NI cryptographic checksum mismatch error: 12599

In testing of Oracle Enterprise Manager 11g R1 Grid Control we noticed frequent ORA-12599 errors in the alert logs of the monitored databases including the repository database. Upon further investigation we found that the ORA-12599 error message, such as the one below, was generated every time a connection was made to the target database as SYSDBA through Oracle Enterprise Manager 11g R1 Grid Control.

TNS-12599: TNS:cryptographic checksum mismatch

ns secondary err code: 2526

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

Wed Aug 04 17:20:17 2010

***********************************************************************

NI cryptographic checksum mismatch error: 12599.

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

Time: 04-AUG-2010 17:20:17

Tracing not turned on.

Tns error struct:

ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch

ns secondary err code: 2526

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

Wed Aug 04 18:26:17 2010

Thread 1 advanced to log sequence 81 (LGWR switch)

Current log# 3 seq# 81 mem# 0: +DATA/bsqrac/onlinelog/group_3.259.725990619

Current log# 3 seq# 81 mem# 1: +FRA/bsqrac/onlinelog/group_3.259.725990621

Wed Aug 04 18:26:17 2010

Archived Log entry 26 added for thread 1 sequence 80 ID 0x2879dc97 dest 1:

Wed Aug 04 22:00:00 2010

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

No errors were returned back to Grid Control nor did any of the process performed fail to complete. If you are seeing these messages in your alert logs you and you are not using encryption you can see if you are experiencing the same issue by simply logging into a database as SYSDBA through Grid Control and then log out of the database. If you are experiencing the same issue you should find two ORA-12599messages in the alert log for the database one associated with the log in and one associated with the log out.

Our support ticket has been assigned Bug 9899797: 12599 ERRORS IN ALERT LOG WHEN CONNECT TO 11.2 DB AS SYSDBA IN GC 11.1. The following are bug numbers listed in My Oracle Support that are similar to what has been described in this document. All have a status of 16 – Support bug screening.

Bug 9850366: NI CRYPTOGRAPHIC CHECKSUM MISMATCH ERROR WHILE LOGGING OUT OF TARGET DB IN EM
Bug 9871805: LOGIN TO OEM CAUSES NI CRYPTOGRAPHIC CHECKSUM MISMATCH ERROR: 12599 MESSAGES IN
Bug 9844654: GC 11G REPOSITORY DB ALERT.LOG SHOWS TNS-12599
Bug 9881906: TNS ERROR IN ALERT LOG FOR 11.2 DB REPOSITORY
Bug 9830641: ORA-12599: TNS:CRYPTOGRAPHIC CHECKSUM MISMATCH

No comments: