技术知识
Oracle EM启动故障处理一列
emctl start dbconsole
系统环境
系统版本 AIX 6.1
数据库版本：Oracle 11.0.2.3
==================================================
故障现象：emctl start dbconsole 启动正常，查看trace日志，有如下错误信息：
………………………………………………
FATAL_ERROR::500|ORA-20603: Updating timezone region of a target is not supported.
………………………………………………
2021-01-04 09:31:21,634 Thread-2088 WARN upload: Truncating value of "COLUMN_LABEL" from "Age of the first message in persistent queue per subscriber (seconds)" to "Age of the first message in persistent queue per subscriber (sec"
2021-01-04 09:31:21,635 Thread-2088 WARN upload: Truncating value of "COLUMN_LABEL" from "Age of the first message in the buffered queue per queue (seconds)" to "Age of the first message in the buffered queue per queue (second"
2021-01-04 09:31:21,704 Thread-2088 WARN collector: Regenerating all DefaultColls
2021-01-04 09:31:21,827 Thread-2088 ERROR upload: Failed to upload file A0000001.xml: Fatal Error.
Response received: 500|ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = sydbzs:3938)(target type = oracle_emd)(new tzrgn = Asia/Chungking)(old tzrgn = Asia/Shanghai)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 92
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'
2021-01-04 09:31:21,827 Thread-2088 ERROR upload: 3 Failures in a row or XML error for A0000001.xml, retcode = -6, we give up
2021-01-04 09:31:21,827 Thread-2088 ERROR upload: Exceeded max. amount of upload data: 51 files, 26.492092 MB Data. 80.71% of disk used. Disabling collections.
2021-01-04 09:31:21,827 Thread-2088 WARN collector: Disable collector
2021-01-04 09:31:23,504 Thread-1071 WARN upload: FxferSend: received fatal error in header from repository:
https://sydbzs:1158/em/upload/
FATAL_ERROR::500|ORA-20603: Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.(target name = sydbzs:3938)(target type = oracle_emd)(new tzrgn = Asia/Chungking)(old tzrgn = Asia/Shanghai)
ORA-06512: at "SYSMAN.CHECK_DUPLICATE_TARGETS", line 92
ORA-04088: error during execution of trigger 'SYSMAN.CHECK_DUPLICATE_TARGETS'
2021-01-04 09:31:23,504 Thread-1071 ERROR upload: number of fatal error exceeds the limit 3
2021-01-04 09:31:23,504 Thread-1071 ERROR upload: agent will shutdown now
2021-01-04 09:31:23,504 Thread-1071 ERROR : Signalled to Exit with status 55. Too many fatal upload failures
2021-01-04 09:31:23,504 Thread-1 ERROR main: EMAgent abnormal terminating
2021-01-04 09:51:47,431 Thread-1 WARN http: nmehl_connect_internal: connect failed to (sydbzs:1158): A remote host refused an attempted connect operation. (error = 79)
2021-01-04 09:51:47,435 Thread-1 ERROR pingManager: nmepm_pingReposURL: Cannot connect to
https://sydbzs:1158/em/upload/: retStatus=-1
2021-01-04 09:51:47,437 Thread-1 WARN command: Job Subsystem Timeout set at 600 seconds
2021-01-04 09:51:47,445 Thread-1 WARN upload: Upload manager has no Failure script: disabled
2021-01-04 09:51:47,488 Thread-1 WARN metadata: Metric VirtualHosts does not have any data columns
2021-01-04 09:51:47,642 Thread-1 WARN metadata: Metric hung_system_traces does not have any data columns
2021-01-04 09:51:48,290 Thread-2057 WARN TargetManager: Query
==================================================
AIX 系统层面，查看该端口是否监听了？
netstat -An |grep 1158
（端口号可以在emctl start dbconsole 的输出信息中看到，例如：https://sydbzs:1158/em/console/aboutApplication）
端口并没有open
另外，在windows cmd 命令提示符下，用工具 tcping.exe [放到C:\Windows\System32这个文件夹下],也可以来测试端口是否open
tcping.exe d的下载链接 ：https://download.elifulkerson.com//files/tcping/0.39/tcping.exe
==================================================
处理经过：
1. 执行 emctl stop dbconsole，停止 EM
2. 检查Oracle用户的 ORACLE_HOME and ORACLE_SID 环境变量
3. 相应地设置时区变量:
Unix/Linux : export TZ=<TZ value>
Windows : set TZ=<TZ value>
4. Execute the following command:
$ORACLE_HOME/bin/emctl resetTZ agent
Note: The above will show instructions simialr to the next step:
5. Connect to the database served by this DBConsole as user 'sysman', and execute:
SQL> exec mgmt_target.set_agent_tzrgn('target name','new tzrgn')
or
Connect to the database served by this DBConsole as user 'sys', and execute:
SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn('target name','new tzrgn')
These messages will be displayed automatically after execute $ORACLE_HOME/bin/emctl resetTZ agent. 然后commit
SQL > commit;
6. 启动 Oracle EM：命令：emctl start dbconsole
- 检查代理的状态: emctl status agent
- 可以执行强制上传: emctl upload
7. Oracle EM 可以正常打开了。
