S6

**Skill Set 6:**

**DESCRIBE:**

**case sensitive**

**Database Name** | **User/Password**  
**数据库名称** | **用户/密码**  
**PROD1** | `sh/sh`、`hr/hr`、`oltp_user/oltp_user1`、`sys/oracle`、`system/oracle`  
**PROD2/PROD3** | `sys/oracle`、`system/oracle`  
**PROD4** | `sys/oracle`、`system/oracle`、`rc_admin/RC_ADMIN`  
**EMREP** | `sys/Oracle123`、`system/Oracle123`、`sysman/Oracle123`

**TASKS:**

**1: Enable Grid Control to the Manage Target Database Machine**  
**1: 启用 Grid Control 来管理目标数据库机器**  
**1.1 Deploy and patch cluster-based Oracle Management Agent on your database server. The cluster and node name is same as database server name (for eg: edabr4p1). Agent registration password is Oracle123**  
** 在你的数据库服务器上部署和打补丁集群基础的 Oracle 管理代理。集群和节点名称与数据库服务器名称相同（例如：edabr4p1）。代理注册密码是 Oracle123**  
```
偶数节点检查oms agent
source profile_oms
emctl status oms
https::/192.0.2.12:

souece profile_agent
emctl status agent

1上安装agent
cd /u01/app/oracle/product/middleware/oms11g/sysman/agent_download/11.1.0.1.0/linux 
scp agentDownload.linux 192.0.2.11:/home/oracle/
PROD1/2 解锁SYSMAN
sudo chmod 755 agentDownload.linux
./agentDownload.linux –yb /u01/app/oracle 
sudo /u01/app/oracle/agent11g/root.sh
cd/u01/app/oracle/agent11g/bin/ 
./emctl status agent

未成功
./emctl secure agent
在重新安装

https://192.0.2.12:7799
targets
databases
search list

解锁所有dbsnmp 账号
alter user dbsnmp  account unlock;

confiure配置密码 全部箭头完成

```
**1.2 Create a Grid Control super user called EMADMIN with the password EMADMIN.**  
**创建一个名为 EMADMIN 的 Grid Control 超级用户，密码为 EMADMIN。**  
```
setup
Administrator
create 
Supper Administrator
```

**2: Use Grid Control**  
** 使用 Grid Control**  
**2.1. Using Grid Control, change the PGA_AGGREGATE_TARGET on your PROD1 server to 200 MB so that it will revert when the instance is restarted.**  
** 使用 Grid Control 将你的 PROD1 服务器上的 PGA_AGGREGATE_TARGET 更改为 200 MB，以便在实例重新启动时恢复到此值。**  
```
Target
database
prod1.us.oracle.com 
server 
Initialization Parameters
搜索PGA
200M 
应用点击

apply
```
**2.2. Using Grid Control, configure the instance to ensure that it will take no more than five minutes to recover your instance following an instance failure.**  
**使用 Grid Control 配置实例，确保在实例故障后恢复时间不超过五分钟。**  
```
Target
database
prod1.us.oracle.com 
server 
Initialization Parameters
搜索MTTR
300
应用点击

apply
```
**2.3. Using Grid Control, configure an alert on the SYSTEM tablespace of the PROD1 database. The alert should register as a warning at 87% full and critical at 95% full.**  
**使用 Grid Control 在 PROD1 数据库的 SYSTEM 表空间上配置警报。警报应在表空间满 87% 时注册为警告，在满 95% 时注册为严重警告。**  
```
Target
database
prod1.us.oracle.com 
server 
tablespace
system
edit
thresholds
87
98

apply
```
**2.4. Using Grid Control, set up notifications to be sent to the email address dba@ocm.com. Notification messages should be sent to this address at anytime.**  
**使用 Grid Control 设置通知，发送到电子邮件地址 dba@ocm.com。通知消息应随时发送到此地址。**  
```
左上角Preferences
general
add
apply
Administrator
edit添加邮箱
```
**2.5. Using Grid Control, create a new tablespace in the PROD1 database called REGISTRATION.**  
**使用 Grid Control 在 PROD1 数据库中创建一个名为 REGISTRATION 的新表空间。**  
**Create with one 90 MB data file. Make sure that this data file can grow to 120 MB. Configure the tablespace for optimal block space utilization.**  
**创建一个 90 MB 的数据文件，确保该数据文件可以增长到 120 MB，并配置表空间以实现最佳的块空间利用率。**  
```
targets
database
1
server
tablespaces

datafile
90
2 
120

```

**3: Implement Schedules and Jobs**  
**3: 实施计划和作业**

**3.1. Using Grid Control, create a schedule for the PROD1 database.**  
**使用 Grid Control 为 PROD1 数据库创建一个计划。**  
**Call this schedule DAILYREBUILD. Configure it to run at 2 PM every day.**  
**将此计划命名为 DAILYREBUILD。配置为每天 2 PM 运行。**  
```
server
Scheduler
create
name--DAILYREBUILD
Schedule Attributes
by days
2 PM
ok

```
**3.2. Using Grid Control, create a program for the PROD1 database called EMP_IND_REBUILD that rebuilds all indexes on the HR.EMPLOYEES table.**  
**使用 Grid Control 为 PROD1 数据库创建一个名为 EMP_IND_REBUILD 的程序，该程序重建 HR.EMPLOYEES 表上的所有索引。**  
```
server
programs
create 
name --EMP_IND_REBUILD
yes
source--
begin
for i in (select index_name from user_indexex where table_name like '%EMPLOYEES%' ) loop\
execute immediate 'alter index' || i.index_name || 'rebuild';
end loop;
end;
```
**3.3. Using Grid Control, create a window called USR_WINDOW1 that uses the DAILYREBUILD schedule and DEFAULT_PLAN resource manager plan.**  
**使用 Grid Control 创建一个名为 USR_WINDOW1 的窗口，该窗口使用 DAILYREBUILD 计划和 DEFAULT_PLAN 资源管理计划。**  
```
server
programs
create 
windows
create 
name
计划选择DAILYREBUILD
```
**3.4. Using Grid Control, create a job called REBUILD_JOB that uses the DAILYREBUILD schedule and EMP_IND_REBUILD program.**  
**使用 Grid Control 创建一个名为 REBUILD_JOB 的作业，该作业使用 DAILYREBUILD 计划和 EMP_IND_REBUILD 程序。**
```
server
job
create
NAME-REBUILD_JOB
SCHEMA HR

CHANGE COMMAND TYPE 
program  --EMP_IND_REBUILD
schedule use-pre-defind schedule   --DAILYREBUILD
ok
```

DBLOG

导航1234

最近发表

友情链接