My Oracle Support Banner

EM13c : ASM Instance Alert Log Metrics Causing "ORA-12533: TNS:illegal ADDRESS parameters" (Doc ID 2670787.1)

Last updated on MAY 26, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.2.0.0 to 13.4.1.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

After Upgrading the Enterprise Manager (EM) Cloud Control to 13.4 Version, ASM Instance related alert log metrics like  'db_alert_log', 'asm_alert_log_rollup_11g' execution causing below errors.

 ./emctl control agent runCollection <ASM Target name>:osm_instance asm_alert_log_rollup_11g
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
asm_alert_log_rollup_11g:db_alert_log:Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
em_error=Could not connect to /(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(Port=))(CONNECT_DATA=(SID=+ASM))): ORA-12533: TNS:illegal ADDRESS parameters (DBD ERROR: OCIServerAttach)

Error stack observed form <Agent_Inst>/sysman/log/gcagent.log file:

2020-02-25 12:06:56,771 [95:8928EC7E] INFO - >>> Reporting exception: oracle.sysman.emSDK.agent.client.exception.GetMetricDataException: Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
em_error=Could not connect to /(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(Port=))(CONNECT_DATA=(SID=+ASM))): ORA-12533: TNS:illegal ADDRESS parameters (DBD ERROR: OCIServerAttach)
(request id 1) <<<
oracle.sysman.emSDK.agent.client.exception.GetMetricDataException: Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
em_error=Could not connect to /(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(Port=))(CONNECT_DATA=(SID=+ASM))): ORA-12533: TNS:illegal ADDRESS parameters (DBD ERROR: OCIServerAttach)
at oracle.sysman.gcagent.dispatch.cxl.GetMetricDataAction.satisfyRequest(GetMetricDataAction.java:295)
at oracle.sysman.gcagent.dispatch.ProcessRequestAction._call(ProcessRequestAction.java:145)
at oracle.sysman.gcagent.dispatch.ProcessRequestAction.call(ProcessRequestAction.java:106)
at oracle.sysman.gcagent.dispatch.InlineDispatchCoordinator.dispatchRequest(InlineDispatchCoordinator.java:237)
Caused by: oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
Usage: grep [OPTION]... PATTERN [FILE]...
Try 'grep --help' for more information.
em_error=Could not connect to /(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(Port=))(CONNECT_DATA=(SID=+ASM))): ORA-12533: TNS:illegal ADDRESS parameters (DBD ERROR: OCIServerAttach)

  

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
References


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