概述: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 bac