Oracle 11g EM Dbconsole reconstruction tutorial, 11 gdbconsole

Oracle 11g EM Dbconsole reconstruction tutorial, 11 gdbconsole

Overview: You can use command lines and graphical interfaces to manage the daily management of oracle databases. command lines include commands such as sqlplus, srvctl, and crsctl, the graphic interface includes 10 Gb EM dbconsole, 11 gb em dbconsole, grid control centralized management, and EM express and cloud control in 12c; this article describes how to install the EM dbconsole tool on 11g.

Tutorial ideas:

1. re-build em

2. Open the em management interface to view

Lab:

Specific emca commands

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 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 communications

MAIL_SERVER_NAME: Outgoing Mail (SMTP) server for communications

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

Rebuilding em

[Oracle @ cube ~] $ Emca-config dbcontrol db-repos recreate

Started emca at Dec 27,201 7 2:44:58

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003,201 1, 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 communications (optional ):

Outgoing Mail (SMTP) server for communications (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 communications ...............

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

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

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

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

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

INFO: Database Control secured successfully.

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

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

Dec 27,201 7 2:58:12 PM oracle. sysman. emcp. EMDBPostConfig configure mconfiguration

INFO: Database Control started successfully

Dec 27,201 7 2:58:12 PM oracle. sysman. emcp. EMDBPostConfig configure mconfiguration

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

Dec 27,201 7 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,201 7 2:58:19

At this point, you can monitor the running status of the oracle database through browser access management after re-building EM ..