Managing Oracle Enterprise Management database Controller

Oracle Enterprise Management database controller is the Oracle Database management tool for a web interface. You can perform actions such as creating entity objects (tables, views, indexes), backing up and recovering your database, importing and exporting data, and so on.

Understanding the directory of Enterprise Manager

When you install the database, the Oracle Enterprise Manager is installed by default. It installs some columns of the Enterprise Manager directory under the $oracle_home directory.

EMCTL Tools

$ORACLE _home/sysman Common Files and shared files for all instances are stored under this directory

Enterprise Manager files that are stored $ORACLE _home/hostname_dbuniquename/Separate DB instance

Understanding the directory structure of Oracle Enterprise Manager services

Configure database controller configuration options preview during installation or after installation

The following configuration tools can help you configure the Oracle database controller

1. Oracle Unified Installation (Oracle Universal Installer)

2. DBCA

3. Database Upgrade Tool

4. Net Configuration Tool

5. Net Configuration Tool can assist you in configuring tools for listener and name methods

Configuring the database controller at installation time

When you are installing a database, you can configure your database to use an Oracle database controller or use an Oracle grid controller when you create a database.

When you install the Oracle Grid controller, you need to install Oracle Management Services (Oracle Management Service) and Oracle Management Agent (Oracle Management agent)

In most installation types, when you install a database, you must choose to install an Oracle database controller or a grid controller. However, you can not configure the database controller during the following installation process.

When installing in Enterprise or Standard Edition, you choose Advanced Configuration options

When you create a database by using DBCA

1. Create a database controller using DBCA

In the installation options, select the Configure Enterprise Manager tool with configure Database control for local management.

Note: Understand the database control and grid control for Oracle Enterprise Manager (Mesh controls)

Database control is used to manage local databases

Grid control can be used to manage local and other databases

2. In a database that already exists, you can also use DBCA to add Enterprise Manager

In the DBCA Creation Wizard, select Configure the database options

3. Configure Oracle Enterprise Management with the EMCA command

3.1 Viewing the status of an Oracle database controller

Emctl command Emctl status/start/stop dbconsole.

***************************************************************************

C:\users\administrator>set oracle_unqname=new02 # Setting Oracle_unqname

C:\users\administrator>emctl Status Dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, Oracle Corporation. All rights reserved.

Https://win-db:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

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

Logs is generated in directory C:\app\administrator\product\11.2.0\dbhome_1/win-db_new02/sysman/log

C:\users\administrator>

***************************************************************************

3.2 Configuring the Oracle Database Controller

Use the EMCA command to configure the database controller, before using the command, you need to meet the following configuration conditions

*******************************************************************************

1. Listener Port 1521 provided is incorrect. Provide the correct port.

2. Listener is isn't up. Start the Listener.

3. Database Service Dbservice is not registered with listener. Register the database service.

4. Listener is-on physical host and ORACLE_HOSTNAME environment variable are set to virtual host. Unset oracle_hostname environment variable.

5. Listener is up on virtual host. Set environment variable oracle_hostname=.

6./etc/hosts does not has correct entry for hostname.

7. $ORACLE _home/database need exist the corresponding password file

*******************************************************************************

1) The following information is to add a password file under Oracle_home/database

**************************************************************************

C:\app\administrator\product\11.2.0\dbhome_1\database>orapwd File=pwdnewdb.ora entries=20

Enter Password for SYS:

2) Use the command to create the database control

C:\app\administrator\product\11.2.0\dbhome_1\database>emca-config Dbcontrol Db-repos Recreate

STARTED EMCA at May 5 6:22:16 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, Oracle. All rights reserved.

Enter the following information:

Database SID:NEWDB # DB instance

Listener Port number:1521 #监听器端口

Listener Oracle_home [C:\app\Administrator\product\11.2.0\dbhome_1]: #监听器目录, you can use Lsnrctl status to view

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 ....... ..... C:\app\Administrator\product\11.2.0\dbhome_1

The Local hostname ... win-db, ... and so on.

Listener oracle_home ....... ..... C:\app\Administrator\product\11.2.0\dbhome_1

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

Database SID ..... newdb ....???

e-mail address for notifications .......

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

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

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

Warning:while Repository is dropped the database would be put in Quiesce mode.

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

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

Partial auto-complete information omitted

INFO: >>>>>>>>>>> The Database Control URL is https://win-db:5500/em <<<< <<<<<<<

May 5 6:29:30 PM Oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

WARNING ************************

Management Repository have been placed in secure mode wherein Enterprise Manager data would be encrypted. The encryption key has been placed in the File:c:/app/administrator/product/11.2.0/dbhome_1/win-db_newdb/sysman/config /emkey.ora. Ensure this file was backed up as the encrypted data would become unusable if this file is lost.

***********************************************************

Enterprise Manager Configuration completed successfully

Finished EMCA at May 5 6:29:30 PM

3) 1-5 information check, you can use the Lsnrctl status command to view

***************************************************************************

C:\users\administrator>lsnrctl status

Lsnrctl for 64-bit windows:version 11.2.0.3.0-production on 06-may-2017 21:58:16

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

Connecting to (Description= (address= (protocol=tcp) (host=win-db) (port=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version Tnslsnr for 64-bit windows:version 11.2.0.3.0-production

Start Date 06-may-2017 21:54:30

Uptime 0 days 0 hr. 3 min. sec

Trace level off

Security on:local OS Authentication

SNMP OFF

Listener Parameter File C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File C:\app\Administrator\diag\tnslsnr\WIN-DB\listener\alert\log.xml

Listening Endpoints Summary ...

(Description= (address= (protocol=tcp) (host=win-db) (port=1521)))

(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1521IPC)))

Services Summary ...

Service "Clrextproc" has 1 instance (s).

Instance "Clrextproc", status UNKNOWN, have 1 handler (s) for the This service ...

Service "NEW02" has 1 instance (s).

Instance "new02", status ready, have 1 handler (s) for the This service ...

Service "newdb" has 1 instance (s).

Instance "newdb", status ready, have 1 handler (s) for the This service ...

The command completed successfully

C:\users\administrator>

*******************************************************************************

4)/etc/hosts Note Add IP address and host name

192.168.56.14 win-db

Configuring the EMCA parameter with an input file

When you run EMCA, use the input file to replace the input information for some columns. You can specify the-respfile parameter to specify the file location.

EMCA config Dbcontrol db-respfile imput_file_path

Using EMCA in a RAC environment

In a RAC environment, use the EMCA configuration command EMCA config dbcontrol db-cluster em_node nodename em_node_list listname,

EMCA config Dbcontrol db-cluster

Manage database controller start and stop Oracle database controller processes

In order to access the database controller through a browser, the database console process (Dbconsole) must be in a running state.

View the status of the database console process can be viewed using the Emctl command, and you can view the Dbconsole service status for the Windows operating system.

Accessing the Oracle Database home page

In the database controller, the Oracle database home page is the primary Database administration Web page. To access the Oracle Database home page, you need the following steps:

1. Need to ensure that the dbconsole process is running

2. Access the Database Control home page HTTPS://HOSTNAME:PORTNUMBER/EM, which can be $oracle_home/install\ in the Windows operating system Portlist.ini View the port of the database configuration em

For example, use database control to enable and close the

Create a database controller administrator user

In order to make reasonable use of the security features of the database, avoid using the highest privilege Sys/system/sysman for system management. You need to create database users on Oracle and properly assign user roles and permissions to manage the database controller.

Existing user in database control, assigned to Administrators group, with administrators permission

Setup->administrators->create

A non-administrator user accesses the database control

The Select_catalog_role role is required for non-administrator users to access the database control

Delete and create a database control object

1. Delete the database control object

C:\users\administrator>emca-deconfig Dbcontrol Db-repos Drop

STARTED EMCA at May 6 4:58:58 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, Oracle. All rights reserved.

Enter the following information:

Database sid:newdb

Listener Port number:1521

Password for SYS User:

Password for Sysman User:

To create a database control object

To create a database control object

C:\users\administrator>emca-config Dbcontrol Db-repos Recreate

Invalid Username/password.

Password for Sysman User:

May 6 5:10:49 PM Oracle.sysman.emcp.util.GeneralUtil initsqlengineloacly

Managing Oracle Enterprise Management database Controller