OCM考试指南
概述：
第一天：
ction 0：创建一个数据库 45 分钟
ction 1：数据库和网络配置 120 分钟
ction 2:Gridcontrol 安装配置 120 分钟
ction 3：数据库备份恢复 60 分钟
ction 4：数据仓库 90 分钟
第二天：
ction 5：数据库管理 120 分钟
ction 6：数据库性能管理 120 分钟
ction 7：部署Oracle RAC 数据库 90 分钟
ctoin 8：部署Dataguard 数据库 60 分钟
奇数机（edsir5p1）与偶数机（edsir5p2）：在真正考试时，每个人面前会有
两台机器，一台称为奇数机（ODD），一台称为偶数机（EVEN），要你在ODD 机器上做什么或者在 EVEN 机器上做什么，偶数还是奇数是依靠机器的hostname 最后一位或者两位数字来定的，通常会要求你在奇数机上创建数据库，在偶数机上安装Grid Control 的OMS。偶数机上是没有Oracle 软件的，因此OMS 需要的Repository 这个数据库也需要创建在奇数机上，再加上之后第二天会要求创建的Standby 实例。
Oracle_home
/u01/app/oracle/product/10.2.0/db_1
/u01/app/oracle/oradata/PROD/disk1……disk5
文档路径
have是什么词/stage/doc/english/
Gridcontrol安装文件
/stage/gc/Disk1/
除rac外都在奇数机edsir5p1和偶数机edsir5p2上完成，并且root密码不告诉你，oracle用户密码ocm123
Rac用奇数机上的虚拟机host1和host2，root用户和oracle用户密码都是oracle
使用Sudo命令
Section 0 手工建库Section 0 ：创建数据库(即手动建库)【在odd 机】
1. Create a databa the sid name is PROD
2. Don't run the Script catalog.sql and catproc.sql
步骤：
1、搞参数文件
2、搞spfile
3、启动数据库到nomount
4、搞生成数据库命令并执行之
同班同学英语参考联机文档：主机托管
Reference ==> Basic Initialization Parameters
Administrator's Guide ==> Step 7: Issue the CREATE DATABASE Statement
考试的时候有个参数文件，但是有些参数有问题是低版本的参数，最好不要用
Section 1：数据库和网络的配置【在odd机操作】
1.Databa tup and undo management
1.1Run the minimum required scripts to complete the basic configuration of the PROD
Databa.
1.2Setup automatic undo management in the PROD databa to support the following
requirements
1.2.1Avoid ORA-01555 Snapshot too old errors for queries running up to 90 minutes
on average.
1到20的序数词1.2.2The number or concurrent OLTP urs will be approximately 120 during normal
business hours.
1.2.3The number or concurrent batch process that will run in the evenings will
approximately 12 to 15.
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
@?/rdbms/admin/dbmspool
alter system t undo_retention=5400;
alter system t process=135 scope=spfile;
alter system t job_queue_process=15;
shutdown immediate;
startup;
2.Server-side Network configuration
2.1Create a listener using the default listener name.
2.1.1The TCP/IP protocol will be ud for all connections.U the machine (not the IP
address) for host.
2.1.2This listener will listen on the default port.
2.2Add a cond listener, named LSNR2, which will listen on figure this
listener to support only automatic instance registrations.
2.2.1Set up the PROD instance to automatically register with the LSNR2.
2.3Start Both listeners.
参考联机文档：
Net Services Reference ==> 7 Listener Parameters (a)
3.Shared Server configuration
3.1Configure the PROD databa to support up to 300 ssions, rerving 100 for decicated
connections.
3.2Configure the PROD databa to support:
3.2.1Default of 3 TCP dispatchers
3.2.2Maximum of 10 dispatchers
3.3Configure the PROD databa to support:
3.3.1Minimum of 10 shared rver process重生小说古代
3.3.2Maximum of 30 shared rver process
alter system t process=300 scope=spfile;
alter system t shared_rver_ssions=200 scope=spfile;
alter system t dispatchers = '(PROTOCOL=TCP)(DISPATCHERS=3)';
alter system t max_dispatchers = 10;
alter system t shared_rvers = 10;
alter system t max_shared_rvers = 30;
shutdown immediate;
startup
参考联机文档：
英文鬼故事regainReference ==> DISPATCHERS
Reference ==> SESSIONS
Reference ==> SHARED_SERVERS
4.Client-side Network configuration
4.1Create the client-side network configuration files providing connect descriptors to your
databa using local naming and easy connect methods.
4.1.1The prod alias should connect to the PROD instance using the default listener
and always u a dedicated rver connection.
电脑慢的快速解决办法
4.1.2The prod _s alias should connect to the PROD instance using LSNR2 and u a
shared rver connection.
4.2The racdb alias should connect to the RACDB rvice (created later) with a dedicated
rver conncection.
4.2.1The RACDB rvice will be running on your RAC cluster
4.3The emrep alias should connect to the EMREP instance (created later) with a dedicated
rver connection.
创建a，内容如下：
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
参考联机文档：
Net Services Reference ==> 6 Local Naming Parameters (a)
