admin 管理员组文章数量: 1086019
2023年12月23日发(作者：smart油耗和续航)
Oracle11g启动配置OEM
Oracle11g的企业管理器，不在是oracle9那样的UI界面，主要是浏览器网页界面了。使用时，用http不行，要用https。
例如：
localhost:1158/em
127.0.0.1:1158/em/console/
127.0.0.1:1158/em/console/aboutApplication
运行命令
Windows的话看oracledbconsole这个服务有没有启动
Linux的话这样看
emctl status dbconsole
如果没启动
emctl start dbconsole
另外侦听器也需要启动l
lsnrctl start
然后在浏览器中输入地址
localhost:1158/em
DBCA建库的时候，启动OEM就有了
操作步骤如下
C:/Documents and Settings/Administrator>emctl start dbconsole
提示
Environment variable ORACLE_SID not defined. Please define it.
C:/Documents and Settings/Administrator>set ORACLE_SID=TEST11G
无提示
C:UsersRuibron>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
127.0.0.1:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
Logs are generated in directory D:appRuibronproduct11.1.0db_1/
---------
oracle11g启动OEM
OracleEnterpriseManager(Oracle企业管理器,简称OEM)是通过一组Oracle程序，为管理分布
式环境提供了管理服务。OEM包括了一组DBA工具，一个repository，以及一个图形化显示的控制台。OEM控制台与每一个服务器上的智能化**(IntelligentAgent)相对应,oracle11g中OEM默认是关闭的状态，下面步骤如何启动OEM工具。
1.查看OEM状态
[oracle@oracle11g ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
oracle11g:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
-----------------------------------
Logs are generated in directory /u01/oracle/product/oracle11g_orcl/sysman/log
2.启动OEM
[oracle@oracle11g ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
oracle11g:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ......... started.
-----------------------------------
Logs are generated in directory /u01/oracle/product/oracle11g_orcl/sysman/log
3.启动监听
[oracle@oracle11g ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 20-MAY-2014 09:42:14
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/oracle/product/bin/tnslsnr:
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/oracle/product/network/admin/
Log messages written to /u01/oracle/diag/tnslsnr/oracle11g/listener/alert/
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11g)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11g)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 20-MAY-2014 09:42:16
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/network/admin/
Listener Log File /u01/oracle/diag/tnslsnr/oracle11g/listener/alert/
Listening
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle11g)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
4.访问OEM
127.0.0.1:1158/em
用户:sys
密码:password
以sysdba身份进入OEM
版权声明：本文标题：Oracle11g启动配置OEM 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1703293584a445817.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论