11gOCM_practice_s2.pdf
免费下载
腾科 11g OCM
第 1 页 共 3 页
2: Grid Control Installation and Configuration
1. Install and Patch Enterprise Manager Grid Control software
1.1 Install database software
1.2 Create database EMREP.oracle.com
1.3 Install Weblogic Server
1.4 Install OEM Grid Control
2. Configure the Enterprise Manager repository
(NULL)
3. Create Enterprise Manager Grid Control users
3.1 Create a Grid Control super user called EMADMIN with the password EMADMIN
4. Use Enterprise Manager to modify a database configuration
4.1 Using Grid Control, change the PGA_AGGREGATE_TARGET on your PROD1 server to 300MB so that it will revert
when the instance is restarted.
4.2 Using Grid Control, configure the instance to ensure that it will take up to five(5) minutes to recover your instance
following an instance failure.
5. Configure Enterprise Manager to modify database availability
5.1 Using Grid Control, stop and start the database PROD1
5.2 Using Grid Control, enable the flashback database setting of database PROD1
5.3 Configure an alert on the SYSTEM tablespace of the PROD1 database. The alert should register as a warning at
87% and critical at 95% full.
5.4 Using Grid Control, create a new tablespace in the PROD1 database called REGISTRATION
5.4.1 Create with one 90MB datafile
5.4.2 Make sure this datafile can grow to 120MB if need be
6. Create and manage jobs
6.1 Create a job to run the OS command ”date >> /tmp/job_output.tmp” repeat 1 minutes on both hosts. Check the
result and then drop the job.
6.2 Create a job to block the ODD host’s agent. Check the result and then unblock the agent.
6.3 Create a job to run the SQL script ‘select column_does_not_exist from dual’ on EMREP database, if the SQL script
return error then run the OS command ‘date >> /tmp/job_output.tmp’ on the ODD host. Check the result of the job.
7. Create and monitor alerts
7.1 In EMREP database, set a warning alert when Tablespace Space Used > 10% after 5 minutes. Check the
tablespaces’ usage. Then reset to default setting (warning threshold to 85% and repeat time to 30 minutes).
7.2 Create a User-Defined Metrics
7.2.1 Use the following SQL query for threshold, set the warning>150,critical>200,repeat every 5 min:
SELECT MAX(A.VALUE) "MAXCURSORS"
FROM V$SESSTAT A, V$STATNAME B
WHERE A.STATISTIC# = B.STATISTIC# AND B.NAME='opened cursors current'
ORDER BY A.VALUE;
腾科 11g OCM
第 2 页 共 3 页
7.2.2 Drop the User-Defined Metrics
7.3 Setting the Basic Metrics
7.3.1 Change Basic Metrics for number of transactions (per second): Critical=Very high (0.99), warning=High(0.95)
8. Create notifications
8.1 Setup notifications to be sent to the email address 'dba@ocm.com' Notification messages should be sent to this
address at anytime.
8.2 Configure to use OS command and local log file as notification method.
9. Implement Grid Control and Database Control
(NULL)
10. Choose the appropriate tablespace type for the intended use
(NULL)
11. Create Scheduler jobs
11.1 Configure a job ‘GATHER_STATS_HR’ on PROD1 DB . Run the following PL/SQL statement at 12:00am on day 25
each month. Run it to check the result and then drop it.
begin
dbms_stats.gather_schema_stats(
ownname=>’HR’,
method_opt=>’for all indexed columns size auto’,
degree=>2,
cascade=>true,
no_invalidate=>false);
end;
11.2 Configure a job ‘TEST_EXEC’ on ODD host to run the executable script ‘/tmp/test_exec.sh’. Check the job’s result.
#!/bin/bash
date >> /tmp/test_exec.out
12. Create schedules
12.1 Configure a schedule ‘MONTHLY_STATS_HR’ on ODD host, repeat on day 25 each month.
12.2 Configure a job ‘GATHER_STATS_HR’, run the above PL/SQL statement ‘GATHER_STATS_HR’ at the schedule
MONTHLY_STATS_HR
12.3 Drop the above jobs and schedule.
13. Assign jobs to windows
13.1 Configure a job ‘GATHER_STATS_HR’ on ODD host to run the following PL/SQL statement at the
MAINTENANCE_WINDOW_GROUP. The job must stop when the maintenance window close.
begin
dbms_stats.gather_schema_stats(
ownname=>’HR’,
method_opt=>’for all indexed columns size auto’,
degree=>2,
cascade=>true,
no_invalidate=>false);
of 3
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论