本文主要是介绍oracle 11g 创建OEM(oracle企业管理器),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
查看主机名[oracle@orale ~]$ hostname
orale
修改主机名和IP地址
[oracle@orale ~]$ vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.22.55 orale
开始创建OEM(oracle企业管理器)
注意:BSNMP用户默认是锁定的需要解锁,如不知道密码则需要修改
注意:sysman用户如果是手动建库是没有的,需要新建用户
用户管理请看: http://blog.csdn.net/u011631923/article/details/14209563
[oracle@orale fallback]$ emca -config dbcontrol db -repos recreate (recreate:重建,create新建)
STARTED EMCA at Nov 19, 2013 11:05:43 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: mypl --实例名
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0 ]: --$ORACLE_HOME 主目录如果没错直接按回车键
Password for SYS user: oracle --sys用户密码
Password for DBSNMP user: oracle --DBSNMP用户密码
Password for SYSMAN user: oracle --sysman用户密码
Email address for notifications (optional): --可选直接按回车
Outgoing Mail (SMTP) server for notifications (optional): --可选直接按回车
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0
Local hostname ................ orale
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0
Listener port number ................ 1521
Database SID ................ mypl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]:
INFO: Database Control started successfully
Nov 17, 2013 12:02:43 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://orale:1158/em <<<<<<<<<<<
Nov 17, 2013 12:03:22 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.
The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/orale_mypl/sysman/config/emkey.ora.
Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 17, 2013 12:03:22 AM
到这就创建成功了
上面提示 >>>>>>>>>>> The Database Control URL is https://orale:1158/em <<<<<<<<<<<用浏览器登录就可以了 (最好使用把主机名换成ip)
https://orale:1158/em
https://192.168.22.55:1158/em (IP是我虚拟机的地址)
如果都没问题请执行emca -deconfig dbcontrol db -repos drop 先删除再创建
emctl status dbconsole 查看
emctl stop dbconsole 关闭
emctl restart dbconsole 打开
这篇关于oracle 11g 创建OEM(oracle企业管理器)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!