SAP Knowledge Base Article - Preview

1840919 - Solution Manager system log (SM21) shows database connection error

Symptom

When a managed system goes down for a regularly scheduled offline backup, or if the monitored system/database is completely deactivated, many errors might show up in the system logs (transaction code SM21) of the SAP Solution Manager. 
For example:

01:10:34 DIA  010 200 SOLMAN_BTC    BY  2 Database error 12154 at CON
01:10:34 DIA  010 200 SOLMAN_BTC    BY  0 > con=2(databasehost:41521/SOL): ORA-12154: TNS:could not resolve
01:10:34 DIA  010 200 SOLMAN_BTC    BY  0 > the connect identifier specified

 

07:09:54 DIA 059 100 SM_EFWK BY 2 Database error 12170 at CON
07:09:54 DIA 059 100 SM_EFWK BY 0 > con=2 (dbhostname:1595/SID): ORA-12170: TNS:Connect timeout
07:09:54 DIA 059 100 SM_EFWK BY 0 > occurred
07:09:54 DIA 059 100 SM_EFWK BY 1 Database error 12170

For other database types, the database error code might be different.
E.g. Database error -10709 at CON.


Read more...

Environment

  • SAP Solution Manager 7.10
  • SAP Solution Manager 7.20
  • SAP Solution Manager Diagnostics

Product

SAP Solution Manager 7.1

Keywords

database errors in SM21 for SM_EFWK; Oracle, HANA, Database error -10709 at CON , KBA , ora , syslog , SV-SMG-INS-DIA , Configuration of Root Cause Analysis related infrastructure , SV-SMG-MON-ALR , Monitoring/Alerting/Reporting Infrastructure , SV-SMG-DIA-SRV-EFW , Extractor Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.