Use Enterprise Manager Configuration Assistant (EMCA) Utility


#1

Enterprise Manager -ийг бааз үүсгэх явцдаа идэвхжүүлээгүй бол дараах алхамаар идэвхжүүлнэ.
REPO д ашиглагдах хэрэглэгчдийн нууц үгийг сольж идэвхжүүлнэ.

ALTER USER DBSNMP IDENTIFIED BY oracle_4U;
ALTER USER SYSMAN IDENTIFIED BY dbsnmp;
ALTER USER DBSNMP ACCOUNT UNLOCK;
ALTER USER SYSMAN ACCOUNT UNLOCK;

Console-ийг идэвхжүүлэхийн тулд дараах коммандыг ашиглана.

[oracle@node1 ~]$
[oracle@node1 ~]$ emca -config dbcontrol db

STARTED EMCA at Feb 21, 2017 3:14:50 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: test1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_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/dbhome_1

Local hostname ................ node1.example.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ test1
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Feb 21, 2017 3:15:10 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/test1/emca_2017_02_21_03_14_50.log.
Feb 21, 2017 3:15:12 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Feb 21, 2017 3:16:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Feb 21, 2017 3:16:03 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Feb 21, 2017 3:16:03 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Feb 21, 2017 3:16:21 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Feb 21, 2017 3:16:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Feb 21, 2017 3:16:50 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Feb 21, 2017 3:16:50 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Feb 21, 2017 3:17:23 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 21, 2017 3:17:23 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://node1.example.com:1158/em <<<<<<<<<<<
Feb 21, 2017 3:17:26 AM 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/dbhome_1/node1.example.com_test1/sysman/config/emkey.ora.   Please 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 Feb 21, 2017 3:17:26 AM
[oracle@node1 ~]$

EM -ийг шалгая:

[oracle@node1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://node1.example.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/node1.example.com_test1/sysman/log
[oracle@node1 ~]$

EM HTTPS -р ажиллаж байна. HTTP -р хандахын тулд дараах коммандыг ажиллуулна.

[oracle@node1 ~]$ emctl unsecure dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://node1.example.com:1158/em/console/aboutApplication
Configuring DBConsole for HTTP...   Done.
DBCONSOLE successfully stopped...   Done.
Agent is already stopped...   Done.
Unsecuring dbconsole...   Started.
DBConsole is now unsecured...  Done.
Unsecuring dbconsole...  Sucessful.
DBCONSOLE successfully restarted...   Done.
[oracle@node1 ~]$

Шалгая.

[oracle@node1 ~]$
[oracle@node1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
http://node1.example.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/node1.example.com_test1/sysman/log
[oracle@node1 ~]$

Oracle Enterprise Manager идэвхжсэн байна.

Эхлүүлэх, Зогсоох

[oracle@node1 ~]$ emctl stop dbconsole
[oracle@node1 ~]$ emctl start dbconsole
[oracle@node1 ~]$ emctl status dbconsole

Устгах, үүсгэх

[oracle@node1 ~]$ emca -deconfig dbcontrol db -repos drop
[oracle@node1 ~]$ emca -config dbcontrol db -repos create