OCM考试指南
概述：
第一天：
section 0：创建一个数据库 45 分钟
section 1：数据库和网络配置 120 分钟
section 2:Gridcontrol 安装配置 120 分钟
section 3：数据库备份恢复 60 分钟
section 4：数据仓库 90 分钟
第二天：
section 5：数据库管理 120 分钟
section 6：数据库性能管理 120 分钟
section 7：部署Oracle RAC 数据库 90 分钟
sectoin 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
文档路径
/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 database the sid name is PROD
2. Don't run the Script catalog.sql and catproc.sql
步骤：
1、搞参数文件
2、搞spfile
3、启动数据库到nomount
4、搞生成数据库命令并执行之
参考联机文档：
reference groupReference ==> Basic Initialization Parameters
Administrator's Guide ==> Step 7: Issue the CREATE DATABASE Statement
考试的时候有个参数文件，但是有些参数有问题是低版本的参数，最好不要用
Section 1：数据库和网络的配置【在odd机操作】
1.Database setup and undo management
1.1Run the minimum required scripts to complete the basic configuration of the PROD
Database.
1.2Setup automatic undo management in the PROD database to support the following
requirements
1.2.1Avoid ORA-01555 Snapshot too old errors for queries running up to 90 minutes
on average.
1.2.2The number or concurrent OLTP users 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 set undo_retention=5400;
alter system set processes=135 scope=spfile;
alter system set job_queue_processes=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 used for all connections.Use the machine (not the IP
address) for host.
2.1.2This listener will listen on the default port.
2.2Add a second 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 database to support up to 300 sessions, reserving 100 for decicated
connections.
3.2Configure the PROD database to support:
3.2.1Default of 3 TCP dispatchers
3.2.2Maximum of 10 dispatchers
3.3Configure the PROD database to support:
3.3.1Minimum of 10 shared server processes
3.3.2Maximum of 30 shared server processes
alter system set processes=300 scope=spfile;
alter system set shared_server_sessions=200 scope=spfile;
alter system set dispatchers = '(PROTOCOL=TCP)(DISPATCHERS=3)';
alter system set max_dispatchers = 10;
alter system set shared_servers = 10;
alter system set max_shared_servers = 30;
shutdown immediate;
startup
参考联机文档：
Reference ==> DISPATCHERS
Reference ==> SESSIONS
Reference ==> SHARED_SERVERS
4.Client-side Network configuration
4.1Create the client-side network configuration files providing connect descriptors to your
database using local naming and easy connect methods.
4.1.1The prod alias should connect to the PROD instance using the default listener
and always use a dedicated server connection.
4.1.2The prod _s alias should connect to the PROD instance using LSNR2 and use a
shared server connection.
4.2The racdb alias should connect to the RACDB service (created later) with a dedicated
server conncection.
4.2.1The RACDB service will be running on your RAC cluster
4.3The emrep alias should connect to the EMREP instance (created later) with a dedicated
server connection.
创建a，内容如下：
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
参考联机文档：
Net Services Reference ==> 6 Local Naming Parameters (a)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。