oracle 11g EM Dbconsole重建教程

概述：oracle数据库的日常管理可以使用命令行及图形化界面进行管理；命令行的命令工具有sqlplus 、srvctl 、 crsctl 等命令，图形化界面有10g版本的EM dbconsole、11g版本的EM dbconsole、grid control 集中管理、12c版本中的EM express、cloud control集中管理；本文将对11g中的EM dbconsole工具进行简单安装介绍。

实验思路：

1、重建em

2、打开em管理界面进行查看

实验：

emca的具体命令

emca -help

[oracle@cube ~]$ emca

/u01/app/oracle/product/11.2.0/db_1/bin/emca [operation] [mode] [dbType] [flags] [parameters]

-h | --h | -help | --help: prints this help message 

-version: prints the version

-config dbcontrol db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure Database Control for a database

-config centralAgent (db | asm) [-cluster] [-silent] [parameters]: configure central agent management

-config all db [-repos (create | recreate)] [-cluster] [-silent] [-backup] [parameters]: configure both Database Control and central agent management

-deconfig dbcontrol db [-repos drop] [-cluster] [-silent] [parameters]: de-configure Database Control

-deconfig centralAgent (db | asm) [-cluster] [ -silent] [parameters]: de-configure central agent management

-deconfig all db [-repos drop] [-cluster] [-silent] [parameters]: de-configure both Database Control and central agent management

-addNode (db | asm) [-silent] [parameters]: configure EM for a newly added node for a database

-deleteNode (db | asm) [-silent] [parameters]: de-configure EM for for a database on node getting deleted

-addInst (db | asm) [-silent] [parameters]: configure EM for a new RAC instance

-deleteInst (db | asm) [-silent] [parameters]: de-configure EM for a specified RAC instance

-reconfig ports [-cluster] [parameters]: explicitly reassign Database Control ports

-reconfig dbcontrol -cluster [-silent] [parameters]: reconfigures RAC Database Control deployment

-displayConfig dbcontrol -cluster [-silent] [parameters]: displays information about the RAC Database Control configuration

-migrate -from dbcontrol -to centralAgent  [-repos drop] [-cluster] [-silent] [parameters]: migrates EM configuration from Database Control to central agent

-upgrade (db | asm | db_asm) [-cluster] [-silent] [parameters]: upgrades an earlier version of the EM configuration to the current version

-updateTargets crs [-silent] [parameters]: updates new crs home for all dbcontrol and central agents on crs upgrade

-restore (db | asm | db_asm) [-cluster] [-silent] [parameters]: restores the current version of the EM configuration to an earlier version

Parameters and Options:

[parameters]: [ -respFile fileName ] [ -paramName paramValue ]* 

db: perform configuration operation for a database (including databases that use ASM)

asm: perform configuration operation for an ASM-only instance

db_asm: perform upgrade/restore operation for a database and an ASM instance

-repos create: create a new Database Control repository

-repos drop: drop the current Database Control repository

-repos recreate: drop the current Database Control repository and recreate a new one

-cluster: perform configuration operation for a RAC database

-silent: perform configuration operation without prompting for parameters

-backup: configure automatic backup for a database

Parameters for single instance databases

ORACLE_HOSTNAME: Local hostname

SID: Database SID

PORT: Listener port number

ORACLE_HOME: Database ORACLE_HOME

LISTENER_OH: Listener ORACLE_HOME

HOST: Listener Host

HOST_USER: Host username for automatic backup

HOST_USER_PWD: Host user password for automatic backup

BACKUP_SCHEDULE: Automatic backup schedule (HH:MM)

EMAIL_ADDRESS: Email address for notifications

MAIL_SERVER_NAME: Outgoing Mail (SMTP) server for notifications

ASM_OH: ASM ORACLE_HOME

ASM_SID: ASM SID

ASM_PORT: ASM port

ASM_USER_ROLE: ASM user role

ASM_USER_NAME: ASM username

ASM_USER_PWD: ASM user password

SRC_OH: ORACLE_HOME for the database to be upgraded

DBSNMP_PWD: Password for DBSNMP user

SYSMAN_PWD: Password for SYSMAN user

SYS_PWD: Password for SYS user

DBCONTROL_HTTP_PORT: Database Control HTTP port

AGENT_PORT: EM agent port

RMI_PORT: RMI port for Database Control

JMS_PORT: JMS port for Database Control

EM_SWLIB_STAGE_LOC:  Software library location

PORTS_FILE: Path to a static file specifying the ports to use (Default value : ${ORACLE_HOME}/install/staticports.ini).

Additional Parameters for cluster databases

CLUSTER_NAME: Cluster name

DB_UNIQUE_NAME: Database unique name

SERVICE_NAME: Service name

EM_NODE: Database Control node name

EM_NODE_LIST: Agent Node list [comma separated]

Note: For Desktop Class Install always pass parameter ORACLE_HOSTNAME 

      as "localhost" to any emca command

重建em

[oracle@cube ~]$ emca -config dbcontrol db -repos recreate 

STARTED EMCA at Dec 27, 2017 2:44: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: CUBE

Listener port number: 1521

Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_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/db_1

Local hostname ................ cube

Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Listener port number ................ 1521

Database SID ................ CUBE

Email address for notifications ............... 

Outgoing Mail (SMTP) server for notifications ............... 

-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

INFO: Securing Database Control (this may take a while) ...

Dec 27, 2017 2:56:55 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control secured successfully.

Dec 27, 2017 2:56:55 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Dec 27, 2017 2:58:12 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Dec 27, 2017 2:58:12 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is https://cube:1158/em <<<<<<<<<<<

Dec 27, 2017 2:58:19 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/db_1/cube_CUBE/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 Dec 27, 2017 2:58:19 PM

至此，重建EM完成 可以通过浏览器访问管理监控oracle数据库运行状态。。