

注意:据最新内部消息,11g的OCM最晚考试时间延迟到2020年4月底,所以,想考11g OCM的同学可以抓紧时间报名。
Oracle 11g ocm第19期将于今天晚上20点在腾讯课堂免费上课,第2场考试免费培训,包过,题库100%覆盖,提供和考试环境一样的练习和模拟环境。
Oracle 11g OCM免费上课培训网上报名连接: https://ke.qq.com/course/316136
或手机扫描以下二维码即可报名:
小麦苗的微信二维码如下所示:
另外,据Oracle官网最新消息,11g的OCM将于2019年12月31日取消考试,所以,需要考11g的OCM的学员请尽快参加培训考试。目前来说,考11g的OCM最划算,价格最低,通过率100%,但是,直考12c的OCM通过率非常低,目前依然不建议直考。
注意:据最新内部消息,11g的OCM最晚考试时间延迟到2020年4月底,所以,想考11g OCM的同学可以抓紧时间报名。
1、考试环境?数据库版本?有哪些数据库实例? 2、考几天? 3、考试内容有哪些? 4、能否使用图形化界面工具? 5、能否查询官方文档? 6、报名OCM的条件是什么? 7、目前最合适的考OCM的途径是什么? 8、是否报名任意一个培训机构都能考过OCM?如何判断报名的机构的题库是否最新的,是否100%覆盖?是否提供和考试环境一样的练习模拟环境? 9、如何准备11g OCM考试? 10、11g OCM何时取消考试?
【通知•OCM】想考11g和12c OCM的小伙伴可以加我微信(lhrbestxh)私聊。11g OCM可以保证最低学费、最快训练速度和100%的通过率,非诚勿扰。
11g OCM 成绩喜报:
11g OCM升级12C OCM喜报:
赵老师11g OCM认证考试公开课视频(https://v.qq.com/x/page/x06219806ex.html):
https://v.qq.com/x/page/x06219806ex.html
第一节、 手工建库与网络配置第三节、数据保护卫士(Data Guard)第四节、管理数据库的备份配置闪回数据库第五节、数据仓库管理与配置第六节、数据管理第七节、数据库性能管理CPU资源分配)第八节、安装管理RAC数据库
Exam Environment
-
Oracle Linux Release 5.4 (32-bit)
-
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit)
-
Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0) (32-bit)
Server Configuration
-
Create the database
-
Determine and set sizing parameters for database structures
-
Create and manage temporary, permanent, and undo tablespaces
-
Stripe data files across multiple physical devices and locations
-
Configure the database environment to support optimal data access performance
-
Create and manage database configuration files
-
Create and manage bigfile tablespaces
-
Create and Manage a tablespace that uses NFS mounted file system file
-
Create and manage multiple network configuration files
-
Create and configure a listener
-
Configure the database instance to support shared server connections
-
Set up network tracing
-
Manage Oracle network processes
-
Configure the network environment to allow connections to multiple databases
-
Use configurationless connections
-
Use OPatch to install a patch
-
Use Grid Infrastructure to manage oracle databases and other resources
-
Use Enterprise Manager Configuration Assistant(EMCA) utility
-
Enterprise Manager Grid Control
-
Install and Patch Enterprise Manager Grid Control software
-
Configure the Enterprise Manager repository
-
Create Enterprise Manager Grid Control users
-
Use Enterprise Manager to modify a database configuration
-
Configure Enterprise Manager to modify database availability
-
Create and manage jobs
-
Create and monitor alerts
-
Create notifications
-
Implement Grid Control and Database Control
-
Choose the appropriate tablespace type for the intended use
-
Create Scheduler jobs
-
Create schedules
-
Assign jobs to windows
-
Create programs
-
Create job classes
-
Install the Enterprise Manager Grid Control infrastructure
-
Deploy Enterprise Manager Grid Control agents
-
Configure Grid Control for business requirements
Managing Database Availability
-
Mantain recovery catalogs
-
Configure Recovery Manager
-
Use Recovery Manager to perform database backups
-
Use Recover Manager to perform complete database restore and recovery operations
-
Configure RMAN
-
Create different types of RMAN backups to cater for different performance and retention requirements
-
Set Flashback Database parameters
-
Configure a Fast Recovery Area
-
Perform various recovery operations using Flashback technology
Data Management
-
Manage Materialized Views to improve rewrite and refresh performance
-
Configure and manage distributed materialized views
-
Create and Manage encrypted tablespaces
-
Manage Transport of tablespaces across platforms
-
Configure a schema to support a star transformation query
-
Administer external tables
-
Implement Data Pump export and import jobs for data transfer
-
Implement Data Pump to and from remote databases
-
Configure and use parallel execution for queries
-
Use SQL*Loader
-
Administer, manage and tune parallel execution
Data Warehouse Management
-
Administer partitioned tables and indexes using appropriate methods and keys
-
Perform partition maintenance operations
-
Maintain indexes on a partitioned table
-
Implement securefile LOB
-
Create and manage LOB segments
-
Implement fine-grained access control
-
Create and manage contexts
-
Administer flashback data archive and schema evolution
Performance Management
-
Administer Resource Manager
-
Use Result Cache
-
Use multi column statistics
-
Gather statistics on a specific table without invalidating cursors
-
Use partitioned indexes
-
Administer and tune schema object to support various access methods
-
Interpret execution plan
-
Use SQL tuning tools and features
-
Use SQL Tuning Advisor
-
Use SQL Access Advisor
-
Use SQL Performance Analyzer
-
Configure baseline templates
-
Use SQL Plan Management feature
-
Implement instance caging
Grid Infrastructure and ASM
-
Install Oracle Grid Infrastructure
-
Create ASM Disk Groups
-
Create and manage as ASM instance
-
Implement ASM failure groups
-
Creating ACFS File System
-
Start, stop, configure and administer Oracle Grid Infrastructure
Real Application Clusters
-
Install the Oracle Database 11gR2 software
-
Configure ASM for the shared disks and create a clustered database
-
Configure archiving
-
Configure services using both Manual and Policy Managed methods
Data Guard
-
Create Physical Standby Database with real-time apply.
-
Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
-
Configure the Observer
-
Switchover and switch back
-
Configure connect time failover
-
Convert the standby to a snapshot standby
-
Configure archivelog deletion policy for the Dataguard configuration
RECOMMENDED MINIMUM SKILLS AND EXPERIENCE:
-
3-4 years of professional enterprise-level Oracle experience
-
Extensive experience with backup, restore and recovery operations
-
Proficient with SQL
-
Working knowledge of LINUX command language that includes:
-
Formatting and executing basic OS commands
-
Creating and navigating through directory structures
-
File management using copy, move, and delete
-
Linux environment text editors
-
Setting environment variables
-
-
The ability to locate and launch Oracle executables that include:
-
RMAN utility
-
Oracle Net Manager
-
Oracle Net Configuration Assistant
-
OEM
-
Listener Utility
-
OMS
-
Oracle Password Utility
-
Database Creation Assistant
-
DGMGRL (for 11g OCM)
-
-
Proficient with Oracle Enterprise Manager
-
Proficient in using Oracle Net Manager and the Oracle Net Configuration Assistant to configure networking
-
Advanced knowledge and use of Oracle Enterprise Server technology and features
-
Familiarity navigating through online Oracle documentation
-
Proficient with using Mozilla 1.6 browser software


下图是小麦苗整理的11g OCM考试内容详解,请不要盗用,也不要做非法用途:
OCP培训说明连接:https://mp.weixin.qq.com/s/2cymJ4xiBPtTaHu16HkiuA
OCM培训说明连接:https://mp.weixin.qq.com/s/7-R6Cz8RcJKduVv6YlAxJA
高可用培训说明连接:
https://mp.weixin.qq.com/s/4vf042CnOdAD8zDyjUueiw
2 网络连接说明
培训项目
连接地址
DB笔试面试历史连接
http://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w
OCP培训说明连接
https://mp.weixin.qq.com/s/2cymJ4xiBPtTaHu16HkiuA
OCM培训说明连接
https://mp.weixin.qq.com/s/7-R6Cz8RcJKduVv6YlAxJA
高可用(RAC+DG+OGG)培训说明连接
https://mp.weixin.qq.com/s/4vf042CnOdAD8zDyjUueiw
OCP最新题库解析历史连接(052)
http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA
微店地址
https://weidian.com/s/793741433?wfr=c&ifr=shopdetail
我的信息
QQ:646634621 微信号:lhrbestxh
小麦苗课堂试听内容
https://share.weiyun.com/5HnQEuL
小麦苗课堂腾讯视频内容
http://v.qq.com/vplus/71f69a319a24c6808cd6e6189ae90664
每逢法定节假日,麦老师的课程都会优惠多多的。详情请加麦老师QQ(646634621)或微信(lhrbestxh)私聊。
其它疑问,请加麦苗的微信私聊。
长按下图识别二维码或微信扫描下图二维码来关注小麦苗的微信公众号:xiaomaimiaolhr,学习最实用的数据库技术。