EM13c : ASM Instance Alert Log Metrics Causing "ORA-12533: TNS:illegal ADDRESS parameters"
(Doc ID 2670787.1)
Last updated on JANUARY 18, 2023
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:
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 |