oracle资源管理器

最新推荐文章于 2021-04-15 10:43:56 发布

weixin_34007020

最新推荐文章于 2021-04-15 10:43:56 发布

阅读量108

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/wangzilong/blog/807748

版权

2019独角兽企业重金招聘Python工程师标准>>>

资源管理器的功能：
1. 可以限制用户使用cpu的百分比
2. 执行语句的并行操作，可以制定多个进程操作
3. 限制活动会话的数量
4. 语句执行时间
5. 限制使用undo空间的大小
6. 限制用户链接的空闲时间
资源管理器的创建
1. 创建资源组
2. 创建资源计划，默认只能使用一个资源计划
3. 编辑资源指令。资源指令就是上面指的资源管理器的所有功能
4. 将资源组下的用户权限更改
5. 启用资源计划
6. 验证资源计划是否可用

创建资源管理器

1 创建资源管理器oem

emctl start dbconsole

如果启动不起来需要重新创建一次

emca -deconfig dbcontrol db -repos drop

[oracle@dghost ~]$ emca -repos drop

STARTED EMCA at Mar 27, 2017 10:13:16 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
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
Mar 27, 2017 10:13:50 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/PORCL/emca_2017_03_27_10_13_15.log.
Mar 27, 2017 10:13:50 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Mar 27, 2017 10:19:02 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 27, 2017 10:19:02 AM

emca -config dbcontrol db -repos create

[oracle@dghost ~]$ emca -config dbcontrol db -repos create

STARTED EMCA at Mar 27, 2017 10:21:14 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/oracle/11g ]: 
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN 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/oracle/11g

Local hostname ................ dghost
Listener ORACLE_HOME ................ /u01/oracle/11g
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Mar 27, 2017 10:21:45 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/PORCL/emca_2017_03_27_10_21_12.log.
Mar 27, 2017 10:21:47 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 27, 2017 10:32:45 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Mar 27, 2017 10:32:56 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 27, 2017 10:34:38 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Mar 27, 2017 10:34:46 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Mar 27, 2017 10:35:01 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Mar 27, 2017 10:35:01 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 27, 2017 10:36:19 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Mar 27, 2017 10:36:19 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://dghost:5500/em <<<<<<<<<<<
Mar 27, 2017 10:36: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/oracle/11g/dghost_PORCL/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 Mar 27, 2017 10:36:26 AM
[oracle@dghost ~]$ 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://dghost:5500/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /u01/oracle/11g/dghost_PORCL/sysman/log