ORACLE DBCONSOLE 启动的问题

本文记录了一次解决Oracle Enterprise Manager DBConsole启动时遇到的时区配置不一致问题的过程。通过使用emctl命令重置时区设置,并执行特定SQL语句更新数据库中的时区信息,最终成功解决了启动错误。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

启动dbconsole,提示错误,emdb.nohup日志内容

# more emdb.nohup
----- Fri Mar  8 15:25:45 2013::DBConsole. Monitoring Agent+Console -----
----- Fri Mar  8 15:25:45 2013::Console Launched with PID 14811576 at time Fri Mar  8 15:25:45 2013 -----
13/03/08 15:25:48 Error starting ORMI-Server.  Unable to bind socket: The socket name is already in use.
----- Fri Mar  8 15:27:19 2013::The agentTZRegion value in /home/product/10.2.0/loopback_ncoa/sysman/config/emd.properties is not in
 agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the
 last start of the agent.
If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute t
he script 'mgmt_target.set_agent_tzrgn' to get the value propagated to repository -----

字面意思,是时区的错误。网上有帖子说,要设置时区 export TZ = RPC,再启动,还不行,日期格式还变成了12小时的,只要又设置回来 export TZ=BEIST-8

后来想想,直接重新设置

$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0  
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
Updating /home/product/10.2.0/loopback_ncoa/sysman/config/emd.properties...
Time zone set to +08:00.


To complete this process, you must either:


connect to the database served by this DBConsole as user 'sysman', and execute:


SQL> exec mgmt_target.set_agent_tzrgn('loopback:3938','+08:00')


                        -- 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('loopback:3938','+08:00')


按上面提示的内容执行,再次启动dbconsole,成功

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值