今天我登陆我们10rac 网页oem,发现页面打不开,检查db1 dbconsole状态发现无故停掉了。emctl start dbconsole也无法启动,检查/opt/oracle/app/prod102/db1_racdb1/sysman/log/emdctl.trc跟踪文件,发现记录很多ssl错误:
2010-07-01 15:37:20 Thread-4136069888 ERROR http: 5: Unable to initialize ssl connection with server, aborting connection attempt
2010-07-01 15:38:51 Thread-4136069888 ERROR ssl: nzos_Handshake failed, ret=29024
2010-07-01 15:38:51 Thread-4136069888 ERROR http: 5: Unable to initialize ssl connection with server, aborting connection attempt
2010-07-01 15:40:22 Thread-4136069888 ERROR ssl: nzos_Handshake failed, ret=29024
经搜索,网上有解决方法:
**********************************************
这个在749243.1中有相应的解决方法:
首先执行下述命令:
$ emctl unsecure dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Configuring DBConsole for HTTP... Done.
DBConsole is already unsecured.
然后执行:
$ emctl secure dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root password :
Enter a Hostname for this OMS : p690ca
DBCONSOLE already stopped... Done.
Agent successfully stopped... Done.
Securing dbconsole... Started.
Checking Repository... Invalid Password.
这里oracle提示让我输入Enterprise Manager Root用户的密码,其实就是让我输入sysman的密码,我记得这个库的sysman的密码就是oracle,但当我输入oracle后这里提示我密码不对。
这种问题的解决方法很简单,只需要去改如下两个地方就可以了:
1、以sys用户登陆后把sysman用户的密码改为oracle
2、执行emctl setpasswd dbconsole将sysman用户的密码oracle登记到emoms.properties中去,如下所示:
$ emctl setpasswd dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Please enter new repository password:
Repository password successfully updated.
执行完上述两步后,现在可以执行emctl secure dbconsole了:
$ emctl secure dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root password :
Enter a Hostname for this OMS : p690ca
DBCONSOLE already stopped... Done.
Agent is already stopped... Done.
Securing dbconsole... Started.
Checking Repository... Done.
Checking Em Key... Done.
Checking Repository for an existing Enterprise Manager Root Key... Done.
Fetching Root Certificate from the Repository... Done.
Updating HTTPS port in emoms.properties file... Done.
Generating Java Keystore... Done.
Securing OMS ... Done.
Generating Oracle Wallet Password for Agent.... Done.
Generating wallet for Agent ... Done.
Copying the wallet for agent use... Done.
Storing agent key in repository... Done.
Storing agent key for agent ... Done.
Configuring Agent...
Configuring Agent for HTTPS in DBCONSOLE mode... Done.
EMD_URL set in /u01/app/oracle/product/10.2.0/p690ca_ipratest/sysman/config/emd.properties
Done.
Configuring Key store.. Done.
Securing dbconsole... Sucessful.
执行完上述步骤后,dbconsole现在终于可以起来了:
$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control .............. started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/p690ca_ipratest/sysman/log
感觉dbconsole的相关问题弄起来还是挺麻烦,有兴趣的朋友可以仔细去看一下549079.1
********************************************************************************
按照上述方法操作,在我的rac上面无法实现,
[oracle@db1 log]$ emctl unsecure dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Configuring DBConsole for HTTP... Done.
DBConsole is already unsecured.
[oracle@db1 log]$ emctl secure dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root password :
Enter a Hostname for this OMS : db1
Failed to stop dbconsole...
[oracle@db1 log]$
检查sysman用户状态正常,没有lock,从新设定sysman用户密码,也无法emctl secure dbconsole
:
[oracle@db1 log]$ emctl secure dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root password :
Enter a Hostname for this OMS : db1
Failed to stop dbconsole...
[oracle@db1 log]$
检查db2节点,发现其dbconsole正常运行,于是将db2节点dbcosole停掉,在db1上启动dbconsole:
[oracle@db1 log]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
[oracle@db1 log]$ emctl status dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/prod102/db1_racdb1/sysman/log
[oracle@db1 log]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[oracle@db1 log]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control .................................. started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/prod102/db1_racdb1/sysman/log
[oracle@db1 log]$
正常启动, 正常登陆,
然后在db2上在启动dbcosole,也是正常启动,
[oracle@db2 ~]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Starting Oracle Enterprise Manager 10g Database Control ........... started.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/prod102/db2_racdb2/sysman/log
[oracle@db2 ~]$
不明原因,难道是必须顺序启动rac节点的dbconsole?