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