Oracle OEM安装配置

OEM–Oracle Enterprise Manager是一个图形化的数据库管理员工具。它为数据库管理员提供了一个集中的系统管理工具，同时它也是一个用来管理、诊断和调试多个数据库的工具.

如下是Oracle Enterprise Manager安装配置过程：

• 获取帮助

[oracle@vastdata1 admin]$ emca|grep recreate-config dbcontrol db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure Database Control for a database-config all db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure both Database Control and central agent management-repos recreate: drop the current Database Control repository and recreate a new one

• 安装OEM

[oracle@vastdata1 admin]$ emca -config dbcontrol db -repos recreateSTARTED EMCA at May 14, 2017 7:19:45 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database SID: PRODListener port number: 1521Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:Password for SYS user: Password for DBSNMP user: May 14, 2017 7:19:58 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoaclyWARNING: ORA-28000: the account is lockedPassword for SYSMAN user: Email address for notifications (optional):Outgoing Mail (SMTP) server for notifications (optional):-----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1Local hostname ................ vastdata1.us.oracle.comListener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1Listener port number ................ 1521Database SID ................ PRODEmail address for notifications ...............Outgoing Mail (SMTP) server for notifications ...............---------------------------------------------------------------------------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yMay 14, 2017 7:20:07 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD/emca_2017_05_14_07_19_44.log.May 14, 2017 7:20:07 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Dropping the EM repository (this may take a while) ...May 14, 2017 7:21:07 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedMay 14, 2017 7:21:07 AM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...May 14, 2017 7:24:27 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdMay 14, 2017 7:24:30 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) ...May 14, 2017 7:25:12 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyMay 14, 2017 7:25:15 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...May 14, 2017 7:26:24 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.May 14, 2017 7:26:24 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...May 14, 2017 7:27:04 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyMay 14, 2017 7:27:04 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://vastdata1.us.oracle.com:1158/em <<<<<<<<<<<May 14, 2017 7:27:08 AM oracle.sysman.emcp.EMDBPostConfig invokeWARNING:************************  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/vastdata1.us.oracle.com_PROD/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 successfullyFINISHED EMCA at May 14, 2017 7:27:08 AM

• 查看终端状态

[oracle@vastdata1 admin]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.4.0Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.https://vastdata1.us.oracle.com:1158/em/console/aboutApplicationOracle Enterprise Manager 11g is running.------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/vastdata1.us.oracle.com_PROD/sysman/log

• 终端控制：
  emctl status dbconsole
  emctl start dbconsole
  emctl stop dbconcole

https://vastdata1.us.oracle.com:1158/em无法打开

• 解决：
  进入C:\Windows\System32\drivers\etc
  编辑hosts文件，添加如下地址并保存
  192.168.80.11 vastdata1.us.oracle.com

再次登入即可打开~~~