OEM管理数据库

原创

pianzif 2014-02-20 13:35:23 博主文章分类：oracle专题 ©著作权

©著作权归作者所有：来自51CTO博客作者pianzif的原创作品，请联系作者获取转载授权，否则将追究法律责任

--EM的管理架构：

通过IE连接EM，EM通过监听找到Oracle！

查看em状态

[oracle@centos-fuwenchao ~]$ emctl status dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
[oracle@centos-fuwenchao ~]$ echo $ORACLE_UNQNAME
[oracle@centos-fuwenchao ~]$ export ORACLE_UNQNAME=wenchaodb
[oracle@centos-fuwenchao ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://centos-fuwenchao:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/centos-fuwenchao_wenchaodb/sysman/log

-----

查看listener状态

[oracle@centos-fuwenchao ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-FEB-2014 10:25:52
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos-fuwenchao)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                19-FEB-2014 17:42:01
Uptime                    0 days 16 hr. 43 min. 51 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/centos-fuwenchao/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos-fuwenchao)(PORT=1521)))
Services Summary...
Service "wenchaodb" has 1 instance(s).
  Instance "wenchaodb", status READY, has 1 handler(s) for this service...
Service "wenchaodbXDB" has 1 instance(s).
  Instance "wenchaodb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@centos-fuwenchao ~]$

可以看到，监听找到了数据库，进而EM可以根据监听找到数据库！

如果监听没有认识到数据库，可以执行命令

sqlpuls / as sysdba;

alter system register;

exit

使用EM登录数据库

https://10.13.2.115:1158/em

账户sys 密码****** 角色sysdba