『ORACLE』设置EM应用程序（11g）

  EM是oracle提供的一个web版的应用程序，在里面可以看到oracle数据库的具体的信息，包括日志、参数、控制文件、整个的内存分配，还有一些统计数据之类的。  首先要检查一下监听，使监听处于READY状态。  [oracle@Annie ~]$ cd $ORACLE_HOME/network/admin  [oracle@Annie admin]$ ls  listener.ora  samples  shrept.lst  tnsnames.ora  [oracle@Annie admin]$ lsnrctl status

   LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-APR-2017 03:50:36

   Copyright (c) 1991, 2013, Oracle. All rights reserved.

   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Annie)(PORT=1521)))
   STATUS of the LISTENER
   ------------------------
   Alias LISTENER
   Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
   Start Date 20-APR-2017 00:38:20
   Uptime 0 days 3 hr. 12 min. 15 sec
   Trace Level off
   Security ON: Local OS Authentication
   SNMP OFF
   Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
   Listener Log File /u01/app/oracle/diag/tnslsnr/Annie/listener/alert/log.xml
   Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Annie)(PORT=1521)))
   Services Summary...
   Service "Annie" has 1 instance(s).
   Instance "Annie", status READY, has 1 handler(s) for this service...
   Service "AnnieXDB" has 1 instance(s).
   Instance "Annie", status READY, has 1 handler(s) for this service...
   The command completed successfully

   [oracle@Annie admin]$ emca -config dbcontrol db -repos  recreate

   STARTED EMCA at Apr 20, 2017 12:39:20 AM
   EM Configuration Assistant, Version 11.2.0.3.0 Production
   Copyright (c) 2003, 2011, Oracle. All rights reserved.

   Enter the following information:
   Database SID: Annie
   Database Control is already configured for the database Annie
   You have chosen to configure Database Control for managing the database Annie
   This will remove the existing configuration and the default settings and perform a fresh configuration
   ----------------------------------------------------------------------
   WARNING : While repository is dropped the database will be put in quiesce mode.
   ----------------------------------------------------------------------
   Do you wish to continue? [yes(Y)/no(N)]: yes
   Listener ORACLE_HOME [ /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 ................ Annie
   Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
   Listener port number ................ 1521
   Database SID ................ Annie
   Email 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)]: yes
   Apr 20, 2017 12:39:43 AM oracle.sysman.emcp.EMConfig perform
   INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/Annie/emca_2017_04_20_00_39_20.log.
   Apr 20, 2017 12:39:44 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
   INFO: Stopping Database Control (this may take a while) ...
   Apr 20, 2017 12:39:47 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Dropping the EM repository (this may take a while) ...
   Apr 20, 2017 12:41:13 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Repository successfully dropped
   Apr 20, 2017 12:41:14 AM oracle.sysman.emcp.EMReposConfig createRepository
   INFO: Creating the EM repository (this may take a while) ...
   Apr 20, 2017 12:46:27 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Repository successfully created
   Apr 20, 2017 12:46:30 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
   INFO: Uploading configuration data to EM repository (this may take a while) ...
   Apr 20, 2017 12:47:45 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Uploaded configuration data successfully
   Apr 20, 2017 12:47:51 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
   INFO: Securing Database Control (this may take a while) ...
   Apr 20, 2017 12:49:07 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
   INFO: Database Control secured successfully.
   Apr 20, 2017 12:49:07 AM oracle.sysman.emcp.util.DBControlUtil startOMS
   INFO: Starting Database Control (this may take a while) ...
   Apr 20, 2017 12:49:41 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
   INFO: Database Control started successfully
   Apr 20, 2017 12:49:41 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
   INFO: >>>>>>>>>>> The Database Control URL is https://Annie:1158/em <<<<<<<<<<<
   Apr 20, 2017 12:49:46 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/dbhome_1/Annie_Annie/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 Apr 20, 2017 12:49:46 AM

   从浏览器中输入https://192.168.11.3:1158/em

    SQL> grant select_catalog_role to scott;（如果用scott用户无法登录EM，输入能让scott登上EM的SQL命令）