华尔思Oracle OCM直通车课程大纲教材

oracle培训大纲1. 培训目标本次Oracle培训旨在通过系统的学习和实践，使学员能够全面掌握Oracle数据库的基本概念、常用功能以及高级技术，提升学员在数据库开发和管理方面的能力。

2. 培训内容2.1 数据库基础知识- 数据库概述- 数据库管理系统（DBMS）的概念和特点- 关系数据库管理系统（RDBMS）简介- Oracle数据库的特点和优势2.2 SQL语言基础- SQL语言的作用和应用范围- SQL语法规则和基本结构- 数据查询、更新和删除操作- 数据库表的创建和管理- 索引的使用和效果优化- 视图、存储过程和触发器的应用2.3 数据库高级技术- 高级SQL查询和优化- 复杂查询的应用- 数据库设计和规范化- 数据库安全性和权限管理 - 备份和恢复策略- 性能监控和调优2.4 PL/SQL编程语言- PL/SQL语言的概述- 变量、条件和循环语句 - 游标和异常处理- 存储过程和函数的开发 - 包和触发器的应用2.5 数据库性能优化- SQL优化技巧和策略- 索引和查询优化- 统计信息和执行计划分析- 优化器参数配置和调整- 性能监测和评估工具3. 培训方式本次培训将采用多种方式，包括讲座、案例分析、实际操作演练和练习题等。

学员将通过实际操作和练习，巩固所学知识，并提高实际应用能力。

4. 培训师资我们的培训师资团队由经验丰富的Oracle数据库专家组成，他们既具备扎实的理论基础，又有丰富的实际项目经验。

他们将为学员提供全方位的专业指导和支持。

5. 培训时间和地点培训时间：预计为期两个月，每周安排2-3次培训课程，每次2小时。

培训地点：我们将提供配备完善的计算机设备和数据库环境的培训场所。

6. 培训考核为了确保学员的学习效果和培训质量，我们将设立考核环节。

学员需要通过考试或项目实践来评估其对Oracle数据库的掌握程度。

7. 培训证书学员成功完成培训并通过考核后，将获得由我们颁发的培训证书，证明其在Oracle数据库方面的专业能力。

Oracle OCM认证考试课程大纲培训模块内容培训提纲学时6学时*（1+3）数据库创建详解◆通过手动方式创建数据库∙环境变量的设置∙密码文件的创建过程以及使用情景∙Oracle数据库中参数文件的演进过程∙参数文件的对比∙参数的修改方式介绍∙数据库启动过程时的内部原理解析◆ SGA∙SGA的内存调整∙10g自动管理的SGA∙与SGA相关的重要参数∙SGA内存的优化◆数据库创建的时候，必须的脚本∙手工创建数据库的时候，需要执行的脚本∙每一个脚本的含义以及对数据库产生的影响∙查看脚本的具体执行内容◆ DBCA建库∙图形化界面建库的优缺点∙DBCA建库的几种选项∙建库过程中需要注意事项◆数据库创建实战演练6学时*（1+4）数据库日常管理◆监听的管理∙listener.ora文件的使用∙tnsnames.ora文件的使用∙sqlnet.ora文件的使用∙详解监听配置文件中参数的意义∙区别动态监听注册与静态监听注册∙非默认端口的动态注册原理∙使用监听文件实现对数据库的访问控制∙对比各种监听的连接方式◆表空间的管理∙表空间的创建∙大文件表空间的使用，以及参数的介绍∙对比大文件表空间和小文件表空间∙表空间的扩展∙表空间的删除∙系统表空间的剖析∙表空间管理的演进：数据库管理表空间，本地管理表空间∙日志组的管理：添加日志组，为日志组添加成员等◆数据库默认属性的修改∙数据库的默认临时表空间，默认用户表空间的设置◆ Oracle数据库基于参数的优化◆控制文件∙控制文件的内容剖析∙控制文件的管理与备份∙控制文件的多路复用◆数据库的冷备∙冷备的概念∙冷备和热备的优缺点对比∙冷备的限制条件Enterprise Manager Grid Control◆ Grid Control体系结构◆部署Enterprise Manager Grid Control◆部署配置Enterprise Manager Grid ControlAgent◆使用Grid Control对数据库进行性能监控◆使用Grid Control创建表空间◆使用Grid Control对数据库进行日常运维∙创建job∙设置表空间警告阈值∙进行参数的调整◆使用Grid Control进行RMAN相关的备份∙创建Catalog∙配置Target∙一些参数的调整◆使用Grid Control创建分区表以及分区索引◆使用Grid Control创建含有特殊字段的表◆使用Grid Control 进行传输表空间的操作6学时*（1+3）◆ Grid Control的删除方法6学时*（1+3）备份恢复◆逻辑备份◆物理备份◆备份方式的对比◆ RMAN∙配置RMAN工作环境∙RMAN Catalog的原理∙配置恢复目录数据库∙RMAN 中常用参数的介绍以及作用∙压缩备份∙备份集与备份片的比较∙用RMAN备份/恢复数据库◆ Flashback闪回数据库技术∙Oracle数据库闪回技术浅析∙闪回技术分类∙对比各种闪回技术∙设置Flashback参数∙配置闪回区域∙监视Flashback数据库日志和统计信息∙执行Flashback Database操作∙配置闪回区域6学时*（1+3）数据库仓库◆对某种故障的处理∙问题所展示出来的现象描述∙所包含的原理∙该故障的解决方案◆系统表空间剖析◆物化视图∙物化视图的刷新及其原理∙物化视图的参数介绍∙物化视图的去重∙物化视图的跨库更新∙用物化视图进行备份∙物化视图重写◆ DB link的剖析◆ SQLLDR解析∙sqlldr中参数的含义∙sqlldr的使用方式∙案例演示sqlldr的使用过程∙sqlldr在使用过程中需要注意的知识点◆外部表∙外部表实现原理∙外部表的参数介绍∙对比sqlldr与datapump两种驱动方式∙跨库读取数据库运维◆传输表空间技术∙数据泵要点剖析∙表空间的状态以及各自的使用场景∙约束检查∙Directory的创建、授权∙EXPDP/IMPDP的参数透析∙用交互式命令行实现传输表空间技术◆分区技术∙分区表的创建∙分区表的分类∙分区索引的创建∙分区索引的分类∙全局索引与本地索引的对比∙对索引的维护◆ Oracle数据库的特殊字段∙几种常用的特殊字段∙每一种特殊字段的使用情景∙使用特殊字段的注意事项∙创建含有CLOB，BLOB字段的表∙创建含有时间戳字段的表∙创建引用rowid字段的表◆审计∙审计的用途∙细粒度审计的深入剖析∙触发审计的条件∙查看审计的触发记录◆索引监控6学时*（1.5+4）∙使用情景∙开启监控∙查看监控，了解索引的使用情况∙关闭监控◆闪回技术的案例精解∙案例：闪回查询∙案例：闪回删除∙案例：不完全恢复数据库优化◆检查点∙检查点的原理∙检查点的分类∙检查点对数据库性能的影响∙检查点的优化◆ Oracle内存优化∙优化共享池∙优化缓冲区高速缓存∙自动共享内存∙优化I/O∙优化PGA◆索引∙对各种索引的解析∙不同索引的使用情景∙索引的优缺点◆在线重定义技术∙内部原理∙对比在线重定义与Move操作◆优化工具介绍∙最根本的性能信息工具：数据库数据字典和动态性能视图∙Alert Log与Trace Files对性能故障诊断的帮助∙诊断性能问题的法宝：Statspack与AWR∙Statspack安装与使用∙AWR使用∙10g新增加的自动化监控、调优工具——ADDM 6学时*（1.5+4）◆ I/O优化∙数据库数据文件∙重做日志文件、∙归档文件的I/O性能特点分析和优化原则∙存储级的I/O性能考虑∙使用多DBWR进程增加I/O能力∙异步I/O的性能考虑∙LGWR与ARC进程的优化∙加速归档的方法◆竞争优化∙锁存器（LATCH）竞争优化∙锁竞争的解决∙回滚段竞争优化◆应用存储优化∙应用存储参数的优化∙选择合适的数据存储方法◆应用语句优化∙SQL语句的处理过程∙SQL语句解析的优化∙锁定执行计划Oracle Clusterware的安装◆简介6学时*（1+3）◆ Oracle Clusterware安装和配置∙Oracle RAC 安装说明∙执行RAC预安装任务∙手工建立信任关系的方法∙设置集群的环境变量∙安装Oracle Clusterware◆ Oracle software的安装◆ RAC软件安装∙安装和配置自动存储管理(ASM)∙安装Oracle数据库软件∙执行数据库创建前任务◆创建RAC数据库∙创建集群数据库∙执行创建数据库之后的任务◆在RAC中管理备份和恢复∙配置RAC数据库，以使用ARCHIVELOG模式和快速恢复区∙为RAC环境配置RMAN◆在RAC中的日常操作∙关闭数据库∙启动数据库∙表空间和数据库文件的维护∙日志信息的查看方式∙服务的运行状况Data Guard ◆ Oracle容灾技术Data Guard6学时*（1+3）∙Oracle Data Guard技术概述∙手工方式安装、配置和管理Oracle物理Data Guard∙使用Grid Control工具安装、配置和管理Oracle物理Data Guard∙使用Grid Control工具对Oracle DataGuard进行健康检查∙Oracle Data Guard三种数据保护模式之间比较及总结∙Oracle Data Guard主备Switchover切换演练∙OMF方式下Oracle Data Guard配置方式及特点∙Oracle Data Guard常见问题解析◆逻辑Data Guard的工作原理◆对比物理Data Guard与逻辑Data Guard◆对比Failover与Switchover备注：6学时*（1+3）代表每天的上课时间是6学时，括号内的第一个数字1代表知识点讲授是1天，第二个数字3代表攻击训练和冲刺辅导是3天。

OCM直通车集训营2015年7月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30 讲师：刘宪军周一周二周三周四周五周六周日6月29日6月30日7月1日 2 3 4 56 7 8 9 10 11 1213 14 15 16 17 18 19OCA开班——第一门课SQL: 简单的SELECT语句SQL: 限定及排序选择的行SQL: 单行函数SQL: 分组功能SQL: 子查询SQL: 多表查询20 21 22 23 24 25 26SQL: 使用集合操作符SQL: 使用DML语句对象SQL: 使用DDL语句创建和管理表SQL: 创建和管理其它的模式27 28 29 30 31 8月1日 2OCA第二门课Oracle体系结构数据库的创建OCM直通车集训营2015年8月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30 讲师：刘宪军周一周二周三周四周五周六周日7月27日28 29 30 31 8月1日 2安装oracle软件配置oracle网络环境管理ASM实例3 4 5 6 7 8 9数据并发与控制管理UNDO数据实施oracle数据库的审计数据库的前瞻性维护10 11 12 13 14 15 16数据库的性能管理备份恢复的概念执行用户管理的备份17 18 19 20 21 22 23 执行用户管理的恢复数据的迁移24 25 26 27 28 29 30休息休息OCM直通车集训营2015年9月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30 讲师：刘宪军周一周二周三周四周五周六周日8月31日 1 2 3 4 5 6OCA开班——第一门课SQL: 简单的SELECT语句SQL: 限定及排序选择的行SQL: 单行函数SQL: 分组功能SQL: 子查询SQL: 多表查询7 8 9 10 11 12 13SQL: 使用集合操作符SQL: 使用DML语句对象SQL: 使用DDL语句创建和管理表SQL: 创建和管理其它的模式14 15 16 17 18 19 20OCA第二门课Oracle体系结构数据库的创建21 22 23 24 25 26 27 安装oracle软件配置oracle网络环境管理ASM实例28 29 30 10月1日 2 3 4OCM 直通车集训营 2015年10月 课表知春路校区晚班上课时间：周一、三 晚：19:00-21:30 讲师：刘宪军数据并发与控制 管理UNDO 数据实施oracle 数据库的审计 数据库的前瞻性维护节假日 节假日 节假日 节假日周一 周二 周三 周四 周五 周六 周日 567891011节假日节假日节假日12131415161718数据库的性能管理备份恢复的概念 执行用户管理的备份192021222324 25执行用户管理的恢复数据的迁移26272829303111月1日休息休息OCM直通车集训营2015年11月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30：刘宪军周一周二周三周四周五周六周日2 3 4 5 6 7 8OCP第三门课配置oracle数据库的恢复能力使用恢复目录配置备份设置创建RMAN备份转储和恢复任务使用RMAN完成恢复9 10 11 12 13 14 15监视和调整RMAN 诊断数据库使用闪回技术116 17 18 19 20 21 22使用闪回技术2实施闪回数据库管理内存23 24 25 26 27 28 29OCM 直通车集训营 2015年12月 课表知春路校区晚班上课时间：周一、三 晚：19:00-21:30 讲师：刘宪军管理数据库的性能 通过SQL 调整性能管理资源 使用调度3012月1日23456管理数据库的存储空间复制数据库周一 周二 周三 周四 周五 周六 周日 78910111213休息休息14151617181920OCM: RACOCM: RAC21222324252627OCM: RACOCM: RAC28 29 30 31OCM: RAC OCM: RACOCM直通车集训营2016年1月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30 讲师：刘宪军周一周二周三周四周五周六周日1 2 3节假日节假日节假日4 5 6 7 8 9 10OCM: RAC OCM: RAC11 12 13 14 15 16 17OCM: RAC OCM: RAC18 19 20 21 22 23 24 OCM: DataGuard OCM: DataGuard25 26 27 28 29 30 31OCM: DataGuard OCM: DataGuardOCM直通车集训营2016年2月课表知春路校区晚班上课时间：周一、三晚：19:00-21:30 讲师：刘宪军周一周二周三周四周五周六周日1 2 3 4 5 6 7 OCM: DataGuard OCM: DataGuard 节假日8 9 10 11 12 13 14节假日节假日节假日节假日节假日节假日15 16 17 18 19 20 21 OCM: DataGuard OCM: DataGuard22 23 24 25 26 27 28 OCM: DataGuard OCM: DataGuard29。

ORACLE 10G课程介绍：OCP全称为Oracle认证数据库专家，是Oracle公司的Oracle数据库DBA认证课程，OCP是开启Oracle所有产品线的钥匙，Oracle还有ERP、中间件等更多的高端产品，都可以从OCP开始学习和熟悉。

一个OCP认证工程师不仅仅可以从事DBA，还可以进一步进行学习成为ERP实施、中间件管理、BI（商业智能）等企业最高薪酬的IT类专家。

Oracle10g认证体系均分为三级认证：即Oracle 10g数据库认证专员（OCA）、Oracle 10g数据库认证专家（OCP）和Oracle 10g数据库认证大师（OCM）。

要获得Oracle 10g OCA认证，需要通过1Z0-047和1Z0-042这两门OCA考试；要获得Oracle 10g OCP认证，需要在获得Oracle 10g OCA 认证的基础上，再在Oracle授权考场通过1Z1-043的OCP考试后，就可获得Oracle 10g OCP认证。

要获得Oracle 10g OCM认证，需要在获得Oracle 10G OCP认证的基础上，通过Oracle大学的上机动手实验，就可获得Oracle 10G OCM认证。

OCA是Oracle认证体系的入门认证，证明你已掌握数据库的基本知识，可以日常维护Oracle,创建用户、分配权限；管理数据文件、管理控制文件、管理日志文件；常用的备份、恢复方法。

OCP是Oracle认证体系的中级认证，证明您已经全面掌握数据库恢复技术、掌握基本的调优方法。

东方瑞通作为Oracle中国WDP计划最佳合作伙伴，东方瑞通的OCP培训在Oracle WDP的规范指导下，携手北京、上海、广州、天津四地分公司面向全国Oracle OCP提供Oracle认证OCP\OCM系列培训。

为方便学员学习，东方瑞通的OCP培训现开设脱产班、周末班、晚班等班型，北京、上海、广州还开设远程直播，让您足不出户也能参加OCP培训。

数据库OCM认证培训大纲（oracle认证大师）Oracle DBA大师班（10g OCM方向）1. 超过90%的Oracle认证专家认为Oracle认证增加了他们的专业可信度2. 超过90%的认证专家认为Oracle认证提高了他们的工作效率3. 89%的认证专家认为Oracle认证使他们有能力提供更高水准的客户服务4. 超过88%的认证专家认为Oracle认证使他们更有实力承担复杂的IT任务5. 92%的认证专家认为Oracle认证使他们的事业得到了更好的发展OCM培训介绍Oracle Certified Master (OCM) -Oracle认证大师，是Oracle认证的最高级别，是对数据库从业人员的技术、知识和操作技能的最高级别的认可。

Oracle OCM是解决最困难的技术难题和最复杂的系统故障的最佳Oracle专家人选，也是IT行业衡量IT专家和经理人的最高专业程度及经验的基准。

OCM不但有能力处理关键业务数据库系统和应用，还能帮助客户解决所有的Oracle技术困难，将成为企业内的资深专家和顾问。

通过这个课程使ORACLE数据库专家掌握了大型Oracle数据库在Linux/Unix平台上的网格、集群、灾备、调优、数据仓库、安全等高级维护技术，有资格成为大型数据中心行业权威。

OCM培训适合对象欲挑入年薪在15万-25万行业的在职者欲从事的Oracle 技术专家职位在校大学生（计算机相关专业）欲转行为企业ERP顾问的软件开发人员欲进入外企、银行、软件公司、国企从事IT信息技术职位的某职者OCM培训学习时间&培训班型OCM培训课程内容课程一：Oracle10g 服务器配置课程简介：通过本课程使的数据库工程技术人员能够了解OCM认证的考试形式、时间安排和注意事项，帮助学员掌握手工创建数据库和表空间，配置数据库监听器等任务。

课程内容：1. OCM考试简介2. 运用脚本创建数据库2. 确定和设置有关数据库架构的参数3. 条带化数据文件4. 创建与管理复用控制文件5. 大文件表空间管理6. 创建与管理多网络配置文件7. 监听器配置8. 共享数据库服务器的监听器配置9. 网络跟踪配置10. 管理Oracle 网络进程11．优化数据访问性能12. 临时、永久、UNDO表空间管理工具软件：Oracle 10g/11g Database 、Listener、SQL/PLUS课程二：Oracle10g网格计算与控制课程简介：Oracle网格计算使多组联网计算机能够组织到一起并按需进行共享，以满足不断变化的业务需求。

ANNUAL PROJECT REVIEW REPORTProject Number RE4007 Project Acronym MECCANO Project title Multimedia Education and Conferencing Collaborationover ATM Networks and OthersProject ManagerName Roy BennettDepartment Computer ScienceOrganisation University College LondonAddress Gower Street, London WC1E 6BTCountry- Code City GB - LondonTelephone +44 (0)20 7679 7934Fax +44 (0)20 7679 1397E-mail R.Bennett@List of PartnersOrganisation Role Country University College London C1 GB Academic Computer Centre CYFRONET C PL Communications Research Centre C CA Hewlett Packard Limited C GB Institut National de Recherche en Informatique et Automatique C FR Universitetet i Oslo C NO Universitaet Stuttgart C DE TELES AG C DEThis section should not normally exceed 20 pages in length and should draw the attention of the Annual Project Review to the key elements of the project. Supporting information should be included in annex.A.1 Objectives of the projectHow the work done has contributed to meeting the project objectives, whether the original objectives needrefocussing etc., to what extent have overall project objectives been met.The project objectives are reproduced below with our comments on the work done to meet them in italic.The objective of the project is to provide all the technology components, other than the data network itself, to support collaborative RTD through the deployment of enhanced tools for multimedia collaboration in Europe. The project will improve and deploy the existing toolsets with a particular application aim of distance education and of conferencing. The improvements will occur in many important aspects:• Better integration of the multimedia conferencing tools to make them easier to use by untrained users;Work has continued on the conference bus which is installed in RAT, Vic and the new gateway tool AudioGate. We have released a new version of the integrated interface for Windows, SGI and Solaris platforms.• Capability for optimum video, audio, shared workspace and applications sharing over heterogeneous bandwidths;Our approach to this has been twofold: in the video and audio tools we have introduced layered codecs which allow the tools to adapt to varying network conditions; in the network we have deployed gateways which can deliver media at rates to suit the bandwidth available to individual users.We have released a version of the video tools Vic and Rendez-Vous with layered codecs; Rendez-Vous has the capability to adapt dynamically to changing network changing. We have redesigned the UCL Transcoding Gateway (UTG) and are developing a new gateway at UiO. Major changes to the transcoder/multiplexer in RAT have contributed to both this and the new telephone to multicast gateway, AudioGate, which we have delivered this year.• Identify the additional support and management facilities required to meet and enhance the end-user applications;We have delivered R3.1 which describes the architecture of the MECCANO tools and other component and have completed R3.2, the preliminary report on their usability.• Inter-operable cross-platform support for many systems - UNIX workstations and PCsWe continue to provide support for almost all of our tools on Microsoft, Solaris and Irix platforms; many are also available on Linux and FreeBSD. We maintain the documentation for the tools, including Installation and User guides, in English, German and Polish.• Better support for the introduction and recording of multimedia information in conferences;We have developed an improved user interface for the MultiMedia Conference Recorder (MMCR) with a self-installing binary for the Windows platform. We have developed a CORBA wrapper for the Sun Media Centre content manager which is undergoing testing.• Support for network reservation and multicast deployment over concatenated networks technologies - mainly using IP - including packet-switched, ATM, SMDS, Direct Broadcast Satellite, mobile and ISDN;Some initial work has been done on network reservation in local research networks, but most of our work to address this objective has been in the area of multicast deployment over ATM and DBS networks. We are starting to work with wireless networks for mobile devices.• Improved inter-operation between workstations running the multicast Internet and normal ITU-T procedures;This activity, the start of which was initially delayed due to recruiting problems at UB and TELES, has made significant progress during this year with the introduction of the AudioGate gateway.• Integration of low-speed access facilities via intelligent packet filtering, multiplexing and transcoding gateways with distributed, secured, control;We have redesigned the UTG and are currently implementing the new design. A new RTSP-controlled gateway has been developed at UiO.• Capability of interworking between Internet multicast and ITU-T styles of end-station.We have developed and delivered an initial gateway to allow a user on the telephone network to join multicast multimedia conferences. We plan to extend this to allow interaction between H.323 workstations with video as well as audio communication.• Facilities for secure conferencing - with the keys distribution compatible with a large-scale CA infrastructure;We have delivered an improved version of secure SDR (2.6.1) as part of the first major software deliverable D.2 and have a later version (2.9) for delivery in D.3. In addition we have developed, and are using, a secure web server to launch secure conferences. This server, the Secure Conference Store, will be delivered in D.3. It is currently accessible from the UCL web site at https:///home/• Distributed measurement, monitoring and management of Resource Reservation and Quality of Service:Some initial work has been done on resource reservation in local research networks, but there is no European wide area testbed to which we have access. We are participating in the TF-TANT Quantum project in this area.• Conference announcement and invitation - including of private sessions - integrated with booking systems.We have continued to develop SDR, especially the secure version. The new gateway, AudioGate, has made use of the control features available with the Mbus to enable users of the telephone network to participate in multicast conferences. Our work in this area has recently concentrated on the provision of a secure, web-based server to allow the authenticated announcement of secure conferences with authenticated participants. This server can also be used for non-secureannouncement. We have participated fully in the work of the IETF on developing the invitation protocol SIP.Verification activities will be pursued both inside the project and in other Telematics projects which stress each of the technical activities. The following test all the tools over various network technologies and geographic regions.• Regular research seminars given from the sites of the partners - including North America We have delivered a number of seminars despite very adverse conditions in the European multicast network. The first series was reported in R8.1 and we have subsequently delivered a series of four recorded seminars during the summer.• Use in the research community, including over the national research networks of UKERNA, DFN, UNINETT, and CA*Net II of seminars, lectures, research collaboration and home working.Despite many difficulties with the European multicast infrastructure, we have continued to use the tools for meetings and seminars. Sometimes this has been possible only by the use of reflectors and such gateways as the UTG.• Use by at least 8 other Telematics, ESPRIT and ACTS projects and several national ones.Besides tools from MERCI and ICETEL projects, it will utilise results from ICE-CAR, current National, and EC projects.During the past year, the MECCANO tools have been used by many groups; the following have been supported by the project: CAIRN, ICB, ICE-CAR, Jagielonian University, K nowledge Network, PIPVIC, REDISE, Virtual Coffee Room, VIROR..Analysis of whether this year's objectives have been met.A.2 Work doneDescription of the main activities of the project in the reporting period. Give a brief description of the workundertaken within each of the work packages, with reference to the technical deliverables (list included in annex4) where the methodology and results are described in more detail. The executive summaries of all Public andProgramme level deliverables should be included in Annex 5.Describe any impact of current or emerging standards on the project's work and the actual or likely contribution of the project on the work of standardisation bodies.Use of budget resources will be summarised in the annex 1, 2 and 3.Workpackage 1: ManagementLeader: Peter Kirstein, UCLWe have held regular on-line meetings using the MECCANO tools – project meetings at 4-weekly intervals and technical meetings weekly. These have been less productive than we would have expected from our experiences with previous projects due to the continuing poor state of the European multicast infrastructure which we discuss below. We held project meetings at Hewlett-Packard Laboratories Bristol in January, at INRIA Sophia Antipolis in April, at the University of Bremen in June and at ACC Krakow in October. We have completed and delivered all deliverables to date, some a little later than we would have wished due to the difficulty of obtaining peer reviews. We have delivered all the bi-monthly management reports and the second Progress report, due in July.Problems encounteredNew Learning AS, an associate partner through UiO, has experienced a number of problems since the spring of this year and has been unable to contribute to the project as a result. The company expects to resume work on its contribution in the near future and we do not see this as having a major impact on the deliverables or their timing. We have brought this to the attention of the Commission over a period of months in the management reports.The multicast connectivity between the main European partners remains problematical, notwithstanding the new TEN-155 interconnects. Also, we have had consistent problems recently in connecting to ACC in Poland and to our Canadian partner, CRC, which has been unable to join our management meetings for many months.Workpackage 2: Activity with External GroupsLeader: Roy Bennett, UCLWe have continued our activities this year in the three main areas of interaction with external groups: demonstrations at relevant events, working with other projects to develop and/or validate our tools and working with international standards bodies. We were unfortunately forced to withdraw from our planned high quality conferencing demonstration prepared for the IST 99 event in Helsinki due to a lack of adequate bandwidth provision.Demonstrations30 November - 2 December 1998: IST 98 Vienna Information Society TechnologiesConference & Exhibition25-26 February 1999: The Launch of TEN 155 at the launch of the Fifth Framework programme, Essen (details in WP5 below).7-10 June 1999: TERENA-NORDUnet Networking Conference, LundWe manned a stand for the duration of the conference and presented a progress report on the project.11-13 October 1999: 5th International Conference on Safety in the Port Environment Environmental Protection and Information Technology, BremenUB demonstrated the conferencing system CONTRABAND that is based on MECCANO media tools (see http://www.ptc-bremen.de/). The demonstration showed how multiparty multimedia conferencing relying on MECCANO tools can be used for accident management and remote consultation, increasing safety and efficiency in sea transport application areas.Other ProjectsREDISEAs part of our cooperation with the Esprit project REDISE (see WP9), german installation and operation manuals have been written to help people to become familiar with NetMeeting, the MECCANO toolset and VNC (the Virtual Network Computer originally developed by Olivetti Research Labs)MECCANO tools were used in combination with NetMeeting to allow the operation of an expensive software package (which had been installed on a single site only) from remote sites. Due to the successful use of MECCANO tools in this engineering environment, RUS was invited to present the tools to local SMEs during a “REDISE Workshop”.Baden-Wurttemberg Research NetworkSome time ago, a working group was founded among the big universities in Baden-Wurttemberg to install the (network, hardware and software) infrastructure required to allow “ad-hoc” desktop multimedia conferences between scientists and engineers at these universities.In the context of this working group, RUS is pushing the multicast infrastructure and has contributed software providing monitoring of the multicast network (see WP5), software and manualsTEN-155During this reporting period, the MECCANO project acted in conjunction with ERCIM in the QUANTUM project as an alpha-tester for the Ten-155 Managed Bandwidth Service. This collaboration is elaborated in the report on Workpackage 5 below.During the official launch of the 5th Framework Programme and the opening of TEN-155 a presentation of MECCANO tools and concepts was given to Edelgard Bulmahn, the german minister for science and education, using the new TEN-155 VPN links. This presentation was given in cooperation with DANTE.Standards bodiesIETFWe provide co-chairs of the AVT, MMUSIC, SIP and UDLR Groups of the IETF.The project was represented at all four meetings of the IETF during the reporting period: 43 (7-11.12.98), 44 (15-19.3.99), 45 (12-16.7.99), 46 (8-12.11.99).We have helped to develop many Internet Drafts during this reporting period. Here we list the latest versions only, since many have been through several revisions. The following were submitted on work partially carried out in the MECCANO context: Duros, Dabbous, Izumiyama, Fujii, Zhang, “A Link Layer Tunneling Mechanism for Unidirectional Links”, draft-ietf-udlr-lltunnel-00.txt, February 1999Robinson, Stewart, “RTP Payload format for Shared Multicast Virtual Worlds (SMVW)”, draft-stewart-avt-00.txt, 25 June 1999.Ott, Kutscher & Bormann, "Capability description for group cooperation", draft-ott-mmusic-cap-00.txt , June 1999Ott, Perkins & Kutscher, "Requirements for Local Conference Control", draft-ott-mmusic-mbus-req-00.txt, June 1999Ott, Perkins & Kutscher, "A Message Bus for Conferencing Systems", draft-ott-mmusic-mbus-transport-00.txt, June 1999Ott, Perkins & Kutscher, "The Message Bus: Messages and Procedures", draft-ott-mmusic-mbus-semantics-00.txt, June 1999Perkins, “RTP Interoperability Statement”, draft-ietf-avt-rtp-interop-01.txt, 15 August 1999.Handley, Perkins & Whelan, “Session Announcement Protocol”, draft-ietf-mmusic-sap-v2-03.txt, 21 October 1999.Perkins, Rosenberg, Schulzrinne, “RTP Testing Strategies”, draft-ietf-avt-rtptest-02.txt, 21 October 1999.Civanlar, Basso, Casner, Herpel, Perkins, “RTP Payload Format for MPEG-4 Streams”, draft-ietf-avt-rtp-mpeg4-02.txt, 22 October 1999.Perkins, “Interactions between SDP and multicast scoping”, draft-perkins-sdp-scoping-00.txt, 22 October 1999.Casner, Schulzrinne, “RTP Profile for Audio and Video Conferences with Minimal Control”, draft-ietf-avt-profile-new-07.txt, 27 October 1999.Perkins, “RTP Audio/Video Profile Interoperability Statement”, draft-ietf-avt-profile-interop-00.txt, 28 October 1999.Handley, Crowcroft, Bormann, Ott, “The Internet Multimedia Conferencing Architecture”, draft-ietf-mmusic-confarch-02.txt, October 1999.The following has progressed from draft to RFC:Handley, Perkins, “Guidelines for Writers of RTP Payload Format Specifications”, RFC 2736, November 1999.ITU-TWe have made a core contribution on robust/redundant/fault-tolerant H.323 components (Oct 1999), leading the ad-hoc group discussion and drafting terms of reference for future work.H.323 Annex E: We have made contributions to this documentH.323 Annex F Simple Endpoint Types: Joerg Ott completed editorship and the recommendation was approved in May 1999.H.323 Annex R: We have made contributions to this documentWe have participated in the following meetings and conferences:16.12.98 ITU Workshop Multimedia over IP-based networks10-15.2.99: ITU-T H.32318-28.5.99: ITU-T SG 162-6.8.99: ITU-T Meeting2-6.8.99: ITU-T SG16 Q.11-15 Joint Rapporteurs Meeting in Berlin, hosted by TELES.Joint workDesign for capability syntax in the MEGACO WG of the IETF and ITU-T SG16 Q.14: Contributions by TELES as member of the design team.Other standards meetings attended13-14.1.99: ETSI Tiphon24.4.99: MPEG meeting27-29.9.99: VON ConferenceWorkpackage 3: Systems Architecture and DemonstratorsLeader: Peter Kirstein, UCLThe major effort of this workpackage was the production of the deliverable R3.1: Architecture of the MECCANO tools and other components. This report benefited from the contributions of many partners who, although not funded for work in the workpackage, had specific expertise and interest.At the January MECCANO meeting at Hewlett Packard, a re-assessment of HP’s role in MECCANO, undertaken in the light of the departure of Pat Baker, resulted in the agreement that Hewlett Packard would undertake an examination of the delivery of Multicast conferencing over Firewalls. The result of this activity was a report, entitled Approaches to Multicast over Firewalls, which was completed on 30 August and is available on the MECCANO project web site.We also produced as internal deliverable D3.2, a usability assessment of the MECCANO tools. This study attempted to define some basic usability requirements for desktop video conferencing and relate this to the MECCANO tools. The report was delivered in two parts Usability Assessment of the MECCANO Tools and Usability Requirements for Collaborative Environments, which also includes a discussion of other conferencing approaches and tools.Workpackage 4: Multimedia Conference componentsLeader: Thierry Turletti, INRIAMuch effort this year has been devoted to improving the tools in the toolset, implementing the Mbus in them and porting them to other platforms and to IPv6.Audio conferencingThe experimental version of RAT (4.x) was released for D4.2 and improvements have been made throughout the year. Bug-fix releases have been made of the stable version of RAT (v3.x) to provide for the needs of the projects which we support (eg PIPVIC2)A new version of FreePhone has been released including SIP and a novel optimal joint rate/error control scheme. We have been working on the improvements of the optimal FEC algorithm, in particular, work is ongoing concerning the sensitivity of the network characteristics estimators on the performance of the algorithm.Video conferencingWe have continued work on vic and have recently released an experimental version (2.8ucl-1.1.0) with support for layered coding.Shared workspaceWe have released several new versions of NTE, the latest being 1.7.0, which included support for other character sets than English - specifically Cyrillic for Russian Language teaching. Work has continued on the development of an improved design of this tool implementing a new protocol and an experimental version has been released recently. We have improved the AOFwb and AOFrec tools, in particular, the transmitting part, the audio recording feature and the graphical interface. New versions of the tools and the corresponding documentation are available in the public domain. We have also added download packages of recorded lectures. The tools have been tested and used in several seminars and lectures.Based on experiences with the Java-based shared whiteboard tool TeleDraw, we have developed TeleStore, a concept for “generic workspace sharing”. This tool intends to simplify the development of future workspace sharing tools by offering a flexible, extensible object-oriented platform which already implements the storage and communication facilities required for such applications. A TeleStore prototype is almost finished and will be available by end of the year.We have released a new version of the ReLaTe integrated interface for IRIX, Solaris and Windows.AnnouncementWe delivered SDR 2.6.1 in D4.2 and have since released new versions to fix security problems. The latest release is now 2.9. In conjunction with ICE-CAR we havedeveloped and SDP PARser (SPAR) which is in use by the project for conference announcement along with SDR.Video serverWe have been working on the Virtual Multimedia File System. An alpha version of the Scalable Video Distribution Architecture (SVDA) has been released, providing flexible hierarchical storage, booking, caching, real-time delivery and presentation for the needs of organization, indexing and retrieval of multimedia document collections with a "video-on-demand" interface.We have also worked on a Java MPEG-1 Player. It is based on the Java Media Framework and is an important part of SVDA system which enables users to play MPEG-1 live stream received from a video server. Additionally, SDR plugin mechanism for this component has been worked out and tested, enabling SDR users with installed plugin to receive MPEG-1 audio/video stream over multicast networks.Work has continued on the development of the user interface to the Multicast Conference Recorder (MMCR) and a redesign of the core recorder is under consideration.Multicast-Unicast ReflectorWe have been working on the RTSP-controllable multicast-to-unicast reflector architecture described in Deliverable R3.1 of WP3. It includes the following tools:1. Reflector engine and control unit ("reflector") which performs the actual packetforwarding between a multicast group and a set of unicast addresses.2. Announcement collector which is a simple session announcement database.3. Modified RTSP server having reflector control functionality, it forms a bridge toWWW integration of the multicast-unicast reflector.4. RTSP control unit ("Rtspc") is an RTSP client with a simple graphical interface. Tools 1-3 need to coexist and are referred to as "service provider tools", while only Rtspc must be installed on the user's system. A detailed description is included as Annex 6.1.Interfaces to other toolsWe have developed an Mbus interface to Microsoft Netmeeting, allowing the re-use and remote control of Netmeeting-feature such as T.128 application sharing in integrating conferencing applications. As a foundation for these activities the Mbus protocol library, developed by UB, has been ported to MS Windows. An initial set of Mbus commands for a Netmeeting-Mbus API have been developed; we are currently in the process of completing and documenting this API.We have also implemented AudioGate, an abstraction layer enabling audio communication via ISDN on top of the Linux ``modem emulation'' driver for ISDN boards. The abstraction layer is designed in a way that the ISDN device can be treated like a sound device so that seamless integration with RAT is possible. A separate control channel is provided for controlling ISDN features as well as placing and accepting calls.IPv6 portingIPv6 versions are now available for the following tools: RAT, VIC, NTE, and SDR.Cross platform support for toolsRelevant publicationsJ-C. Bolot, S. Fosse-Parisis, D. Towsley, “Adaptive FEC-Based error control for Internet Telephony”, In Proceedings of Infocom '99, New York, NY, March 1999N. Faerber, K. W. Stuhlmueller and B. Girod, “Analysis of Error Propagation in Hybrid Video Coding with Application to Error Resilience”, ICIP, Kobe, Japan, October, 1999.K.W. Stuhlmueller, N. Faerber, M. Link and B. Girod, “Analysis of Video Transmission over Lossy Channels”, IEEE Journal on Selected Areas of Communication, Special Issue on Error Resilient Image and Video Transmission, 1999.L. Lambrinos, P. T. Kirstein & V. Hardman, “Improving the Quality of Recorded Mbone Sessions using a Distributed Model”, Proc. 4th International Distributed Conference, Madrid, September 1999.U. Horn, K. W. Stuhlmueller, M. Link, & B. Girod, “Robust Internet Video Transmission Based on Scalable Coding and Unequal Error Protection”, Image Communication, Special Issue on Real-Time Video over the Internet, 1999.Workpackage 5: Network supportLeader: Colin Perkins, UCLConnectivity and Network MonitoringThe project has continued to expend a significant amount of effort in monitoring the quality of the multicast network, and in attempting to work around the limitations of the network in order to conduct our project management videoconferences.With only few exceptions, the international multicast connectivity has turned out to be of very bad quality during the whole reporting period. This is in contrast with the national infrastructure, which has – on the whole – been of good quality.In order to better isolate the problem, a MeshTrace script was written at RUS which allows to observe the multicast distribution paths between every two MECCANO partners during a running session. While the output of this script had to be evaluated manually until recently, a new version of this script is now able to perform this tedious task automatically. Examples of the output of this script from a recent project meeting are included as Annex 6.2. Due to the lack of professional multicast network monitoring tools, this script will soon also be used to monitor the network in Baden-Württemberg! Evaluation of MeshTrace outputs have identified routing problems as the primary reason for the poor multicast connectivity in Europe. While sufficient network capacity seems to be available and most multicast routers (with a few, but important exceptions) seem to be powerful enough to handle the current traffic, MeshTrace observations have shown massive failures in finding the proper routes between conference participants. While this problem seemed to be solved in spring 1999, the migration to PIM-SM and MBGP/MSDP in the Ten-155 core seems to have caused new problems which still wait to be solved (note: we applaud the decision to migrate to PIM-SM/MSDP, since this will – in the long term – result in a much more maintainable network, despite the short-term problems it causes). MECCANO sessions were heavily affected by these problems, although we were often able to point out problems which weren't even known to the network operators at that time.A number of measures were tried, as workarounds for the problems with international multicast connectivity:• In order to be able to have regular conferences and seminars, UCL and RUS had to set up RTP/RTCP packet reflectors at their sites which could also be used by other partners and allowed for audio/video conferences with decent quality (but without NTE which does not cooperate with such reflectors, since it is not RTP-based). In order to simplify the handling of such reflectors, RUS has written a (Java-based) reflector which doesn't have to be pre-configured for every unicast participant but includes a remote site as soon as an unicast packet comes in from that participant • In order to allow our partner in Krakow to participate in the regular MECCANO sessions, a direct DVMRP tunnel was set up between RUS and ACC. This tunnel worked well until MBGP was installed in the German multicast backbone. This protocol drops packets from sites with addresses outside the configured MBGP "cloud" (thus avoiding routing loops) and therefore inhibits ACC to *send* traffic。

课程概述：本课程适合于Oracle10g用户，尚观将向学员提供数据服务器的详细扩展介绍。

课程涉及的概念包括面向关系和面向对象数据库，以及强大的SQL编程语言。

授课目标：课程将向学员教授创建和维护数据库对象，以及存储、获取和操作数据。

同时学员将学会使用像ROLLUP、CUBE、Set运算符和分级获取等高级技术获取数据。

学员将学会使用iSQL*Plus工具编写SQL和SQL*Plus脚本文件产生类似报表的示例和动手实践以增强基础概念。

目标学员：在校学生中，想以后从事数据库管理、数据库开发，数据库测试，等数据库最终用户。

入学条件：有较强的计算机基础，了解部分数据基础，最好有基本的操作系统使用经验，熟悉数据处理概念和技术。

第一门课Oracle 10g数据库管理IOracle产品数据库管理员管理工业界最先进的信息系统和拥有业界最高薪水。

本课程是迈向成为一名Oracle专家的第一步，设计用于巩固熟悉基本的数据库任务。

学员将学会设计、创建和维护Oracle数据库。

学员将会了解Oracle数据库架构的基本概念，以及这些组件如何工作和相互交互。

学员将学会如何创建关系数据库和以一种有效和高效率的方式管理各种架构。

1、Oracle 10g数据库体系结构；2、安装Oracle数据库软件；3、创建Oracle数据库；4、管理Oracle例程；5、管理数据库存储结构；6、管理用户安全性；7、管理方案对象；8、管理数据和并发处理能力；9、管理撤销数据；10、实施Oracle数据库安全性；11、配置Oracle Network环境；12、积极维护；13、性能管理；14、备份和恢复的概念；15、执行数据库备份；16、执行数据库恢复；17、执行闪回；18、移动数据。

学习后，学员可以从事Oracle数据库服务器的数据操作和管理等工作。

第二门课Oracle 10g数据库管理II本课程为管理工业界最先进的信息系统的数据库管理员开发能力，学员将学会备份和恢复Oracle数据库，动手实验将会给你带来真实技术环境中的体验，开发基本的网络管理技巧，使用Oracle恢复管理器简化职责。

oracle ocp培训内容Oracle OCP培训内容Oracle OCP（Oracle Certified Professional）是针对Oracle数据库管理和开发技术的专业认证，对于想要在数据库领域发展的人来说，具有重要的意义。

在Oracle OCP培训中，学员将学习到一系列关于Oracle数据库的知识和技能，以及如何应用这些知识来解决实际问题。

下面将介绍一些常见的Oracle OCP培训内容。

一、数据库基础知识在Oracle OCP培训的开始阶段，学员将学习数据库的基础知识。

这包括数据库的概念、结构和原理，以及SQL语言的基本语法和常用命令。

学员将了解到如何创建数据库、表和索引，以及如何插入、更新和删除数据。

二、数据库管理数据库管理是Oracle OCP培训的重要内容之一。

学员将学习到如何管理数据库的安全性、性能和可靠性。

这包括用户管理、权限管理、备份和恢复、性能调优等方面的知识和技能。

学员将了解到如何设置用户权限、监控数据库性能、优化SQL查询等。

三、高级数据库开发在Oracle OCP培训的后期阶段，学员将学习到一些高级的数据库开发技术。

这包括存储过程、触发器、函数和包等方面的知识和技能。

学员将了解到如何使用PL/SQL语言来编写复杂的数据库逻辑和业务规则。

四、高可用性和故障恢复高可用性和故障恢复是Oracle数据库管理的重要内容。

在Oracle OCP培训中，学员将学习到如何配置和管理Oracle数据库的高可用性解决方案，以及如何进行故障恢复。

学员将了解到如何配置数据保护、故障转移和灾备解决方案，以及如何应对数据库故障和灾难。

五、性能调优性能调优是Oracle数据库管理的关键技能之一。

在Oracle OCP培训中，学员将学习到如何识别和解决数据库性能问题。

学员将了解到如何使用Oracle性能监视工具和诊断工具，以及如何优化SQL 查询、调整数据库参数和配置硬件资源。

六、安全管理数据库安全管理是Oracle OCP培训的重要内容之一。

oracle课程教学大纲一、课程概述1.1 课程背景1.2 课程目标1.3 适用对象1.4 课程时长二、课程内容2.1 模块一：Oracle数据库介绍2.1.1 数据库基本概念2.1.2 Oracle数据库的特点与优势2.1.3 Oracle数据库架构2.2 模块二：SQL基础2.2.1 SQL的概述与发展历程2.2.2 SQL的语法规则与基本命令2.2.3 数据查询与过滤2.2.4 数据排序与分组2.2.5 数据增删改操作2.3 模块三：PL/SQL编程2.3.1 PL/SQL的概述与特点2.3.2 PL/SQL的语法规则与基本结构 2.3.3 变量与数据类型2.3.4 控制流程与条件语句2.3.5 异常处理与事务控制2.4 模块四：高级数据库应用2.4.1 触发器与存储过程2.4.2 游标与游标变量2.4.3 动态SQL与游标FOR循环2.4.4 PL/SQL包与函数2.4.5 数据库调优与性能优化2.5 模块五：数据备份与恢复2.5.1 数据库备份策略与方法2.5.2 数据库恢复与故障处理2.5.3 数据库容灾与高可用性三、教学方法与学习资源3.1 教学方法3.1.1 理论讲解3.1.2 实例演示3.1.3 实践操作3.1.4 课堂讨论3.2 学习资源3.2.1 教材推荐3.2.2 在线文档与教程3.2.3 实验环境与工具四、考核要求4.1 平时作业4.2 实验报告4.3 期中考试4.4 期末论文五、参考书目六、教师简介七、备注这是一个基于Oracle数据库的课程大纲，旨在为学生提供全面而系统的Oracle数据库知识和技能。

通过该课程的学习，学生将掌握Oracle数据库的基本概念、SQL语言的使用、PL/SQL编程技术、高级数据库应用等方面的知识，并具备数据库备份与恢复的能力。

本课程分为五个模块，依次介绍了Oracle数据库的基础知识、SQL语言的使用、PL/SQL编程技术、高级数据库应用和数据备份与恢复等内容。