search cancel

CA APM Cluster During APM Oracle Database Maintenance


Article ID: 128484


Updated On:


CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE


CA APM Database and Oracle 
Oracle Database Repair Maintenance and the DB is to be placed in Restricted Mode on a reboot/shutdown for 2-5 hours.  

Please advise if we leave the APM cluster running?
Does this impact APM monitoring? 


CA APM 10.5
Oracle APM Database 


You do not need to drop the APM cluster ; it can be running and collecting metrics from Agent.

During the down time when Database is not available, you will see the below ERROR messages on the EM log, For 5 hours it might be tons of messages.
This is used mainlyby Team Center and CEM.

[ERROR] [WrapperSimpleAppMain] [Apm.Data.Model] APM Database is not reachable. Please check the connectivity…

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

1. You could  set the AppMap property to "WARN" . To prevent the flooding of messages the following configuration setting can be made in the file on the MOM

log4j.logger.Manager.AppMap=WARN, ,console,logfile.

2. You could disable the APM Center and CEM to avoid the ERROR messages

Disabling and Enabling APM Team Center

How to disable the CEM - Introscope integration?