电竞比分网-中国电竞赛事及体育赛事平台

分享

oracle之EMCA

 老張的菜地 2020-03-27
oracle中安裝em有三種方法
Oracle Universal Installer (OUI)
Oracle Database Configuration Assistant (DBCA)
Enterprise Manager Configuration Assistant (EMCA)
前兩種是在圖形化界面中安裝,最后一種是純命令安裝
這里我們就看一下emca的用法:

一、卸載 EM Database Control
[oracle@odd-PROD1 ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 2, 2016 2:17:58 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.


Enter the following information:
Database SID: PROD1
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  


----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:18:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_17_57.log.
Nov 2, 2016 2:18:22 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 2, 2016 2:18:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 2, 2016 2:21:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 2, 2016 2:21:18 PM




二、創(chuàng)建和配置EM Database Control
[oracle@odd-PROD1 ~]$ emca -config dbcontrol db -repos create


STARTED EMCA at Nov 2, 2016 2:25:18 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.


Enter the following information:
Database SID: PROD1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]: /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 ................ odd.oracle.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ PROD1
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 


-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 2, 2016 2:26:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD1/emca_2016_11_02_14_25_18.log.
Nov 2, 2016 2:26:49 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 2, 2016 2:32:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 2, 2016 2:32:19 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 2, 2016 2:33:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 2, 2016 2:33:18 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for odd.oracle.com
Nov 2, 2016 2:33:23 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 2, 2016 2:33:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 2, 2016 2:34:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://odd.oracle.com:1158/em <<<<<<<<<<<
Nov 2, 2016 2:34:35 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/dbhome_1/odd.oracle.com_PROD1/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 Nov 2, 2016 2:34:35 PM


此時(shí)可以打開(kāi)網(wǎng)頁(yè)







已經(jīng)進(jìn)入em

三、em的開(kāi)啟與關(guān)閉
停止em控制臺(tái)服務(wù)
[oracle@odd-PROD1 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ... 
 ...  Stopped. 
開(kāi)啟em控制臺(tái)服務(wù)
[oracle@odd-PROD1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....... started. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/odd.oracle.com_PROD1/sysman/log 
查看em控制臺(tái)服務(wù)的狀態(tài)
[oracle@odd-PROD1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://odd.oracle.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/odd.oracle.com_PROD1/sysman/log 


其他一些emca的命令(這里不一一演示
創(chuàng)建em資料庫(kù)
emca -repos create
刪除em資料庫(kù)
emca -repos drop
重建em資料庫(kù)
emca -repos recreate
配置dbcontrol
emca -config dbcontrol db
刪除dbcontrol的配置
emca -deconfig dbcontrol db

來(lái)自 “ ITPUB博客 ” ,鏈接:http://blog./31386161/viewspace-2127519/,如需轉(zhuǎn)載,請(qǐng)注明出處,否則將追究法律責(zé)任。

    本站是提供個(gè)人知識(shí)管理的網(wǎng)絡(luò)存儲(chǔ)空間,所有內(nèi)容均由用戶(hù)發(fā)布,不代表本站觀點(diǎn)。請(qǐng)注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購(gòu)買(mǎi)等信息,謹(jǐn)防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請(qǐng)點(diǎn)擊一鍵舉報(bào)。
    轉(zhuǎn)藏 分享 獻(xiàn)花(0

    0條評(píng)論

    發(fā)表

    請(qǐng)遵守用戶(hù) 評(píng)論公約

    類(lèi)似文章 更多