oracle EM登录出现报错：
转：
http://img.blog.itpub.net/blog/attachment/201611/2/31386161_1478070690Fze4.png?x-oss-process=style/bb
oracle中安装em有三种方法
Oracle Universal Installer (OUI)
Oracle Database Configuration Assistant (DBCA)
Enterprise Manager Configuration Assistant (EMCA)
前两种是在图形化界面中安装，最后一种是纯命令安装
这里我们就看一下emca的用法：
一、卸载 EM Database Control
[oracle@odd-PROD1 ~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Nov 2, 2016 2:17:58 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: PROD1
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:18:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_17_57.log.
Nov 2, 2016 2:18:22 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 2, 2016 2:18:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 2, 2016 2:21:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 2, 2016 2:21:18 PM
二、创建和配置EM Database Control
[oracle@odd-PROD1 ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Nov 2, 2016 2:25:18 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: PROD1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/dbhome_1
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
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/dbhome_1
Local hostname ................ odd.oracle.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ PROD1
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:26:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_25_18.log.
Nov 2, 2016 2:26:49 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 2, 2016 2:32:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 2, 2016 2:32:19 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 2, 2016 2:33:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 2, 2016 2:33:18 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for odd.oracle.com
Nov 2, 2016 2:33:23 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://odd.oracle.com:1158/em <<<<<<<<<<<
Nov 2, 2016 2:34:35 PM 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/dbhome_1/odd.oracle.com_PROD1/sysman/config/emkey.ora. 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 2, 2016 2:34:35 PM
此时可以打开网页
已经进入em
三、em的开启与关闭
停止em控制台服务
[oracle@odd-PROD1 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
... Stopped.
开启em控制台服务
[oracle@odd-PROD1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/log
查看em控制台服务的状态
[oracle@odd-PROD1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/log
其他一些emca的命令（这里不一一演示）
创建em资料库
emca -repos create
删除em资料库
emca -repos drop
重建em资料库
emca -repos recreate
配置dbcontrol
emca -config dbcontrol db
删除dbcontrol的配置
emca -deconfig dbcontrol db
文章评论