My Oracle Support Banner

EM13c : Trying To Login To V19 (after Upgrade), OEM Is Throwing Popup Box That Says ERROR (Doc ID 2806562.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, when tying to connect to database 19c (after upgrade) EM is throwing popup box that says ERROR.

Following stack is observed from <EM_INSTANCE_HOME>/em/EMGC_OMS1/sysman/log/emoms.trc file:

2021-08-25 13:20:20,970 [MetricCollector:HOMETAB_THREAD600:60] DEBUG conn.SiDbTargetConnectionFactory exiting.157 - Exiting oracle.sysman.emInternalSDK.db.conn.SiDbTargetConnectionFactory.getConnectDesccriptor() with result: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED)))
2021-08-25 13:20:20,971 [MetricCollector:HOMETAB_THREAD600:60] DEBUG conn.DBConnectionUtil exiting.157 - Exiting oracle.sysman.emInternalSDK.db.conn.DBConnectionUtil.getConnectDescriptor() with result: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED)))
2021-08-25 13:20:20,971 [MetricCollector:HOMETAB_THREAD600:60] DEBUG credstore.EMCredentialUtil getMonitoringCredential.3723 - Entry: setnameDBCredsMonitoring
2021-08-25 13:20:20,973 [MetricCollector:HOMETAB_THREAD600:60] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBPassword
2021-08-25 13:20:20,973 [MetricCollector:HOMETAB_THREAD600:60] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBRole
2021-08-25 13:20:20,973 [MetricCollector:HOMETAB_THREAD600:60] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute DBUserName
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG credstore.EMCredentialUtil getMonitoringCredential.3774 - Exit: return username:dbsnmp
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG rt.DbMetricCollectorTarget logp.251 - ----DbMetricCollectorTarget.getTargetConnection Getting Non-Pooled Connection: ABC,oracle_database
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG db.TargetUtils entering.133 - Entering oracle.sysman.emInternalSDK.db.TargetUtils.isPaaSTarget(): [ABC][oracle_database]
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG db.TargetUtils exiting.157 - Exiting oracle.sysman.emInternalSDK.db.TargetUtils.isPaaSTarget() with result: false
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.834 - Attempt to connect with following Properties:
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property oracle.net.encryption_client : REQUESTED
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property oracle.net.encryption_types_client : ( AES256, AES192, AES128, 3DES168, 3DES112, DES56C, DES40C, RC4_256, RC4_128, RC4_40, RC4_56 )
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property oracle.net.CONNECT_TIMEOUT : 30000
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property oracle.net.crypto_checksum_client : REQUESTED
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property v$session.program : OMS
2021-08-25 13:20:20,974 [MetricCollector:HOMETAB_THREAD600:60] DEBUG jdbc.ConnectionFactory createConnection.842 - Property oracle.net.crypto_checksum_types_client : ( MD5, SHA1 )
2021-08-25 13:20:20,981 [Symptom-Diagnosis:Symptom-Diagnosis Admin] DEBUG workmanager.Work logp.251 - Work:Starting work for BackGround Work Instance :Symptom-Diagnosis Admin
2021-08-25 13:20:21,075 [MetricCollector:HOMETAB_THREAD600:60] ERROR rt.DbMetricCollectorTarget logp.251 - Caught Exception in DbMetricCollectorTarget.getMonitorringConnection() ABC oracle_database
java.nio.BufferUnderflowException
at java.nio.HeapByteBuffer.get(HeapByteBuffer.java:151)
<TRUNCATED>
at java.lang.Thread.run(Thread.java:748)
2021-08-25 13:20:21,076 [MetricCollector:HOMETAB_THREAD600:60] DEBUG rt.DbMetricCollectorTarget logp.251 - ---DbMetricCollectorTarget.getConnection m_connectionErrorMessage: null,ABC,oracle_database
2021-08-25 13:20:21,076 [MetricCollector:HOMETAB_THREAD600:60] ERROR rt.DbMetricCollectorTarget logp.251 - Exception in getConnection()ABC:oracle_databasejava.nio.BufferUnderflowException

Optionally, check:

1. Test the connection to the database from EM Console
     Navigate to Target Setup -> Monitoring Configuration - click on Test Connection  -->  Verify if the Connection completes without errors.

2. Also verify if the connection using the sqlplus completes without errors.

>sqlplus sysman@"((DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED)))"

>sqlplus dbsnmp@"((DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)(PORT = 1521))(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED)))"

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.