Apps DBA& Architect Knowledge Warehouse

oracle dba training about Oracle Academy Teacher Training in Zhengzhou .

Thanks for all teachers!

1. Introduction
2. Installation
3. DB Creation
4. Instance
5. Storage
6. Users
7. Schema
8. Data & Concurrency
9. Undo
10. Security
11. Network
12. Proactive Maintenance
13. Performance
14. Backup & Recovery Concepts
15. Backup
16. Recovery
17. Flashback
18. Moving Data

To further protect sensitive application data residing in an Oracle Database from unauthorized access by any database user, including privileged database administrators (DBA), Oracle Database Vault now includes extensible policies for use with Oracle’s JD Edwards EnterpriseOne, Oracle announced today.

Oracle Database Vault enables JD Edwards EnterpriseOne customers to restrict access to application data by highly privileged users, enforce separation-of-duty within the Oracle database, prevent application by-pass and enforce enterprise security policies with multi-factor authorization.

Securing JD Edwards Application Data Transparently

Requiring no special modifications to the JD Edwards EnterpriseOne applications, Oracle Database Vault defends transparently against unauthorized access to application data residing in the database as well as accidental or intentionally harmful database changes by users.

Specifically, the default Oracle Database Vault policies for JD Edwards EnterpriseOne will establish an:

Application Protection Realm to prevent privileged users from accessing sensitive information;

Configuration Protection Realm to protect the application meta data against unauthorized changes; and,

Command Rule to authorize the JD Edwards application connections to the Oracle Database based on IP address and client application.

The default policies can be customized and further extended to

the Oracle Database based on IP address and client application.

The default policies can be customized and further extended to take into account other factors such as time of day, day of week, authentication, and more.

Organizations can implement Oracle Database Vault to enforce separation of duties within the database. For example, Oracle Database Vault can block privileged users with DBA rights from reading or changing critical application data while allowing a DBA to perform daily operations such as database backup and recovery, tuning, and replication.

In addition to increasing the security of existing applications, Oracle Database Vault helps organizations meet regulatory mandates such as Sarbanes-Oxley (SOX), Payment Card Industry (PCI) Data Security Standard (DSS), Health Insurance Portability and Accountability Act (HIPAA), Gramm-Leach-Bliley Act (GLBA), and similar global directives that call for separation-of-duties and other preventive controls to ensure data integrity and data privacy.

Oracle Database Vault is now certified with all JD Edwards EnterpriseOne application modules and releases version 8.12 and higher, Oracle’s Siebel CRM, the Oracle E-Business Suite, and Oracle’s PeopleSoft Enterprise.

1. 概述
2. 新手入门
3. 注册
4. 集成和自定义
5. 技术
概述
什么是Oracle iLearning？
Oracle iLearning是一种完全托管的、企业级的学习管理系统，为任何人，在任何时间，于任何地点，提供高效、易于管理、集成、可扩展以及基于Internet的学习方案。Oracle iLearning提供一种性价比极高和简便的方案，以迎接在全球范围内进行公司培训的挑战，并提供大多数学习管理系统都具有的标准功能，包括汇编、部署和跟踪学习内容；创建并运行打包和自定义的报表；部署测验并打分；以及初始化工作流通知等等。Oracle iLearning相较于其他学习管理系统的优势在于：
? 在线递送
? 有效的托管
? 自助服务访问
? 对象级访问和安全性
? 学习服务供应商支持
? 学习内容的管理和统一
? 支持不同的学习标准
谁需要使用Oracle iLearning？
在当今世界，任何正在经历电子商务转型的公司都应将e-Learning作为其电子商务策略的一部分。Oracle iLearning特别适合为那些面向学员社区（人数在50到500000人以上）的组织提供基于Web的学习方案。例子包括：
? 面向合伙人或客户社区的组织（Oracle University的Oracle Learning Network即是一例）
? 面向学员社区的的组织。学员的重点在于再教育，例如律师、医疗专家、CPA、卫生保健专家或者航空公司雇员等等。
? 正在寻找“首选”LMS（学习管理系统）的内容供应商，想通过它托管其内容
? 大公司内部的不同部门，关注的是自己的目标受众。比如销售、支持或咨询部门等等
Oracle iLearning的优点何在？
快速实现：Oracle iLearning是从头设计的一种产品，最开始便考虑到了托管的问题，在实现的速度和成本上面，具有无以伦比的优势。新社区可以快速添加到应用程序的单一安装中。Oracle iLearning的所有用户（无论学员，老师，还是管理员）都只需通过浏览器来访问Oracle iLearning应用程序（URL：http://ilearning.oracle.com/）。由于采取的是托管的方法，所以新特性可无缝地提供给客户，不必像以前那样，等待12～18个月才能有一次重大的升级版本问世。
全面的内容管理：Oracle iLearning只要求设计一次总体结构，在其中填充极其精细的内容对象块，它们特别适合跨越不同的学习路径重复使用，而且可针对单独的用户或用户组，进行全面的个人化。实际创作的内容可分布到一个或多个内容服务器上，而这些服务器可位于独立于Oracle iLearning的地方，要么在客户的防火墙之内，要么在防火墙之外。
知识递送速度：Oracle iLearning不仅支持正式的学习过程，还针对实时性颇高的主题，支持快速和准确的知识递送，因为它允许最终用户从专家那里学习，对传统意义上颇长的知识供应链进行高度压缩。
Oracle电子商务套件集成：在客户关系周期的每一个部分，都特别适合采用Oracle iLearning来提供学习功能。Oracle电子商务套件的培训是通过Oracle iLearning来提供的。对于Oracle Application的客户来说，这是一个很好的理由将Oracle iLearning定为自己的LMS标准。这样一来，只需一个集成站点，便能满足自己的全部学习需要。Oracle iLearning采用以XML／SOAP／AQ技术为基础的一个标准集成框架，可通过几种不同的方式同ERP／CRM应用程序集成。
启动和运行的速度有多快？
在Oracle iLearning内部，一个社区只需几分钟的时间即可建立。实现起来不牵涉到任何成本，因为Oracle iLearning是作为一种完全托管的服务提供的。Oracle提供了一个Oracle iLearning Quick Start计划（为期10天），提供就绪状态评估、Oracle iLearning培训以及初始内容开发策略（包括过程、模板和推荐的工具），帮助您快速启动向e-Learning的转型。
如何学习使用Oracle iLearning？如果我需要，是否能参加什么培训？
Oracle iLearning在设计时便考虑到了直观和易用的问题，特别为学员进行了大量优化。如有必要，您还可利用几个自动运行的演示，它们以在线形式提供，专门供您熟悉Oracle iLearning。任何管理员（内容汇编人员、经理、老师或具有管理职责的其他人）可参加在Oracle iLearning内部部署的自学过程，从而学习Oracle iLearning的使用。
通过Oracle University，也可参加由老师亲自讲授的Oracle iLearning培训课程。.
Oracle iLearning支持多少名用户？
Oracle iLearning基于Oracle Internet平台而构建，可从50名用户的小型社区起步，一路扩展到包含了成千上万用户的大型社区。
如何获知Oracle iLearning的增强功能？
要想知道Oracle iLearning的增强功能，可选择接收新闻电邮，其中包含了有关Oracle iLearning的更新和发行注释。另外，也可随时访问Oracle iLearning主页，查阅经常在此发布的相关公告（http://www.oracle.com/ilearning）。
我们会经常为Oracle iLearning添加新的功能，并欢迎您提出宝贵意见。
Oracle iLearning会提供多语言支持，或者会在全球范围内开设更多的站点吗？
Oracle iLearning学习界面目前有英语、荷兰语、西班牙语、意大利语、法语、德语、巴西葡萄牙膏语、韩语、日语和汉语（普通话）等几种语言。根据您的浏览器采用的语言设置，应用程序也会自动地调出相应的语言。
Oracle iLearning目前采取的是集中运行方式，由Oracle公司设在美国加州的全球总部数据中心负责技术支持。
Oracle iLearning符合哪些工业标准？
Oracle iLearning通过基于“计算机管理教育／学习管理系统”（CMI／LMS）JavaScript的API，兼容于AICC标准。所有AICC CMI兼容内容都可直接在Oracle iLearning内部播放，并提供了良好的跟踪能力。在线学习标准是由几家组织制定的，包括IMS和AICC。其中，IMS是由多家学习机构和厂商构成的协会，其中也包括Oracle公司。它们共同制定并推广开放式的在线学习规范。欲知详情，请访问IMS主页：http://www.imsproject.org/。AICC是“Aviation Industry CBT Committee”的简称，是一个面向培训专家的开放式论坛，致力于为交互式学习技术制定各种各样的指导性规则。欲知详情，请访问http://www.aicc.org/。
新手入门
如何访问Oracle iLearning？
Oracle iLearning可从以下URL访问：http://ilearning.oracle.com/。您的公司可能提供了一个单独的URL以访问Oracle iLearning。
我可以试用Oracle iLearning吗？
您可访问http://ilearning.oracle.com/demo.jsp，以学员身份，亲自体验Oracle iLearning。还可注册一个免费的、时间有限的帐号，以便试用Oracle iLearning的所有功能。请联系以下一名Oracle iLearning Account地区代表，了解详情。
地区 电子邮件
美国 ilearn_us@oracle.com
UK/EMEA ilearn_uk@oracle.com
ASIA/PAC ilearn_au@oracle.com
Oracle iLearning如何与Oracle电子商务套件集成？
Oracle iLearning可为Oracle电子商务套件部署课件。这是Oracle Applications客户将Oracle iLearning作为他们的学习管理系统标准的一个良好动机。这样一来，只需一个集成的套件，即可满足全部学习需要。
Oracle iLearning可在客户关系周期的每一个位置部署学习机制，并将其作为售前和售后策略的一部分提供给客户。
目前，用户数据可在Oracle HR或其他非Oracle应用程序中导入或导出，其中利用了基于IMS的XML模板，以简化数据传输。对我们来说，一个关键的设计目标便是实现Oracle iLearning同其他Oracle应用程序的有效集成。事实上，所有Oracle应用程序都可快速转移到相同的核心技术基础以及常规的自助服务用户界面设计。在Oracle iLearning的下一个版本中，我们会发布一个完整的、循序渐进的逐步骤指引，教您如何实现与Oracle HR／Oracle Financials的“热同步”（hot-sync）集成。
Oracle iLearning计划的集成策略将允许您使用全面的导入、导出和集成功能，以简化同其他应用程序的沟通——无论它们是您的内部应用程序，还是第三方（托管）的应用程序。
现有的数据可导入Oracle iLearning吗?
目前，用户数据和内容元数据可导入（创建、更新、删除）Oracle iLearning中。整个过程符合IMS规范，可实现用户和内容数据的顺利导入。
注册
新客户的注册过程是怎样的？
欲知详情，请联系以下Oracle iLearning Account地区代表。
地区 电子邮件
美国 ilearn_us@oracle.com
UK／EMEA ilearn_uk@oracle.com
ASIA／PAC ilearn_au@oracle.com
使用Oracle iLearning得花多少钱？
Oracle iLearning采取的是一个简单的基于用户的定价模型，每用户每年标准价格是48美元。最小的订阅期限是1年。最低的购置价格是5000美元，其中包括托管、许可证、技术支持以及每用户2MB的免费存储空间。额外的存储空间定价为每GB每月350美元。
Oracle iLearning的年度升级和维护费用是多少?
Oracle iLearning的定价模型非常简单。所有升级和维护费用都包括在基本价格中。您使用的肯定是最新版本的Oracle iLearning，没有任何附加费用。
如何重置我的密码？
通过点击Reset Password按钮，您可要求系统重置密码，并自动向您发送电子邮件，告诉您新的密码信息。
如何联络客户支持？
如果您是使用Oracle iLearning的一名学员，需要联系您的社区Helpdesk。对于管理员，作为一项电子商务，我们强烈建议您使用内建的电子表单，以获取出色的客户服务。但仍可通过电子邮件获取传统的客户支持，详情见Oracle Metalink（http://metalink.oracle.com）。
集成和自定义
Oracle iLearning可与任何合作或学习产品集成吗？
Oracle iLearning包括基本的合作工具：同步聊天、不同步论坛以及电子邮件。还支持专用同步服务器的使用，比如Mentergy的Learnlinc，Centra Symposium和Interwise等，以实现更高级、更全面的合作式学习（提供相关文档）。
Oracle iLearning可与任何类型的培训注册或资源管理系统集成吗？
Oracle培训管理（OTA）产品支持基于课堂的资源管理。在Oracle iLearning的下一个版本里，我们计划开发同OTA的集成功能。
Oracle iLearning能同收费系统集成吗？
Oracle iLearning特别适合作为面向学员社区的一种订阅服务使用。为了获得更全面的、基于Web的学习体验，一种更好的做法是让学员订阅一个课程目录，而不是针对每门课或者基本的内容模块进行单独收费。这个模型的一个非常好的例子便是Oracle学习网络（http://www.oracle.com/education/oln），它正是在Oracle iLearning的基础上运行的。
在Oracle iLearning的下一个版本中，还会提供同Oracle Financials和CRM 产品（比如Oracle iStore）集成的电子商务功能。
可为我的特定社区自定义Oracle iLearning吗？
Oracle iLearning客户可为自己的社区定义具体的属性，可自定义内容类型，搜索目录，自定义属性，管理职责，自助注册选项以及社区公告等等。
每个社区都可有单独的登录页面或入口位置，以便从此进入Oracle iLearning。此外，Oracle iLearning还允许针对每个社区，单独更改其外观与感觉——包括字体、颜色和徽标图像等等。未来Oracle iLearning升级时，不会影响这些自定义设置。
根据Oracle iLearning的设计，它已成功地将商业逻辑和核心逻辑分离，能针对每个社区都进行复杂的自定义操作。针对这些附加自定义操作的管理，定价模型将随着所需的自定义级别的变化而变化。
技术
什么是Oracle iLearning平台和基础结构？
Oracle iLearning基于面向Web应用的工业标准技术而构建，其中包括Oracle8i Internet平台和Java。Oracle iLearning多层结构由Apache服务器、JSP和Oracle8i构成。
一系列支持HTML和Servlet功能的Web服务器提供对Oracle iLearning的访问渠道。在这个级别，可提供一个或多个服务器，从而具有良好的伸缩性、可靠性和负载平衡能力（作为托客服务的一部分进行管理）。一系列JSP作为Oracle iLearning应用程序的图形界面使用。应用层负责解释用户请求，调用商业逻辑组件内的恰当行动例程，并向客户机返回HTML输出。应用程序是用Business Components for Java（BC4J）写成的。BC4J是一种百分之百纯Java、由XML提供动力的基本框架，它基于可重用的商业组件，可实现多层式数据库应用程序的生产性开发、可移植部署以及灵活的自定义。欲了解BC4J的详情，请参考BC4J白皮书。
所有用户（不管学员还是管理员）都只需在其客户机上安装一个标准的Internet浏览器，并通过HTTP访问Oracle iLearning。所有Oracle iLearning功能都是在服务器上实现的——惟一例外的便是在客户机上运行的那些简单的JavaScript校验程序。
注意：第三方内容可能需要插件程序才能播放内容文件（例如Shockwave或Real Player）。
Oracle iLearning的伸缩性如何？
Oracle Internet和BC4J体系结构设计用于突破传统技术的壁垒，可在Internet上支持非常大的数据库应用。在Oracle iLearning的开发过程中，严格的性能测试和应用程序调节是至关重要的一个步骤。Oracle iLearning在完成了性能测试后才正式投入生产，可支持数量巨大的并发用户。作为托管服务的一部分，Oracle会管理中间层和后端平台的配置，以获得最优的性能。
访问站点所需的最低浏览器级别和桌面要求如何？
没有特殊的客户端要求。我们同时支持Netscape和Internet Explorer浏览器。您至少需要这两种产品的4.X版本。Oracle iLearning可支持Win NT，95，98和Win 2000操作系统。
Oracle iLearning提供哪些安全特性？
物理安全：只有经过批准的人员才允许进入存放Oracle iLearning系统的数据中心区域。
应用程序安全：采用加密密码和用户名登录Oracle iLearning，并在此进行身份验证。在Oracle iLearning的所有被保护的页面，都会对用户信息进行校验。一个看门人模块会对Oracle iLearning托管的内容进行安全保护。这样可防范未经授权的用户通过URL访问安全内容。
网络安全：使用周边网络（以前称为非军事区或DMZ）的概念用于在Internet上保证Oracle iLearning服务器的安全。服务器位于防火墙之后，但不在内部网中。
Oracle iLearning可在有防火墙的系统中方便地使用吗？?
Oracle iLearning采用标准HTTP请求来完成所有Web接口功能。不会有任何特殊端口或其他“小窍门”有可能被防火墙阻挡。此外，它也没有使用Java Applet。
如何对Oracle iLearning进行升级？
类似任何Web站点，每次登录时，Oracle iLearning都允许您立即访问已经添加的任何新特性。您不必下载任何软件，也不必进行任何系统调节。
公司的IT部门需要怎么做？
为了建立您的Oracle iLearning社区，不需要牵涉公司IT部门的任何工作。
会产生任何附加的实现成本吗？
不会。您可自己设置用户、组织、内容和导入数据，而无需产生任何费用。Oracle iLearning确实提供了一个Quick Start（快速启动）服务包，帮助您了解公司的状况是否已为e-Learning做好准备。Quick Start可帮助您定义自己的内容开发策略，就内容和用户管理进行培训，并帮助您设置Oracle iLearning社区的属性。
如何在Oracle iLearning内部进行内容管理？
Oracle iLearning允许灵活地分布内容服务器。物理内容可由Oracle iLearning内部的内容服务器进行管理，或由您的内容供应商或ASP负责内容服务器的维护，或在您自己的防火墙内部进行管理。
在Oracle iLearning上，可实现哪些类型的内容？
Oracle iLearning支持来自多个厂商的、可在Web上播放的任何内容，也支持在单位内部创作的内容，范围从标准的字处理和演示文稿包，一直到高度复杂的多媒体创作系统。
哪些创作工具兼容于Oracle iLearning？
任何可生成能在Web上浏览的输出内容的工具，都适于开发在Oracle iLearning上播放的内容。可选范围从标准的HTML创作工具（比如Microsoft Frontpage），一直到高级的多媒体创作环境，比如Macromedia的Dreamweaver Attain工具，它集成了AICC CMI跟踪API，可用来与Oracle iLearning服务器交换状态信息。
在Oracle iLearning内部，可对内容进行什么形式的跟踪?
针对适于在Oracle iLearning内部构造和汇编的内容，信息在最低的精度级别上进行跟踪。我们还支持AICC CMI API标准，从而允许JavaScript跟踪调用，内容和Oracle iLearning之间的通信。Oracle iLearning会自动维护完成状态、所花时间以及下一个／上一个对象。学员可启动一门课程，并快速返回上一次访问过的位置。

最近几天，硬做了一些Oracle i-Learning 的支持工作，为了更好的了解和理解i-Learning,于是决定自己动手做一下，

用了2个多小时就把系统完全搞定了，相对ERP系统，这还是很小的系统，没多少技术东西，

把操作过程的截图如下，供大家参考

OVERVIEW       

Purpose

本文档的目的是Oracle i-Learning 爱好者，自己测试Oracle i-Learning 的安装、基本配置以及简单的功能测试,PROD环境建议参照Oracle 官方文档进行

Prerequisite

操作前，必须确认的事项

1． Disk Space 规划是否做好？建议d盘给20G左右空间。

2． Install Media CD 是否准备好？建议把安装介质COPY到硬盘中安装。

3． 需要的OS 和 Patch Source 最好提前下载好，并确认Source 文件完整性。

Prepare OS（XP）

安装中注意事项

1． 建议安装到XP SP2以上，并安装好病毒防护软件

2． 建议暂时关闭防火墙

3． 如果是DHCP 的话，安装Microsoft loop adapter "

Oracle i-Leaning 安装步骤

Oracle Database 安装

点击DB安装包中的"setup"按纽 ，此安装版本为9.2.0.1,因为只用于测试，所以没再打不顶，正式项目使用建议打到9.2.0.8 版本：

Oracle ias 10g  安装

点击application安装包中的"setup"按纽 ，此安装版本为9.2.0.4,因为只用于测试，所以没再打不顶，正式项目使用建议打到更高 版本：

Oracle i-Learning 安装

点击 i-Learning安装包中的"setup"按纽 ，此安装版本为5.0B,因为只用于测试，所以没再打补丁，正式项目使用建议打到更高 版本：

Oracle i-Learning Setting Up a Content Server 安装

安装方法和以上基本相似，详细内容请看官方的正式文档

Scope

This instruction covers the tasks necessary to set up an Oracle iLearning secured content server.

This instruction does not cover how to set up a non-Oracle iLearning secured content server

Distribution

Oracle iLearning Administrator^*

Oracle iLearning DBA^*

Ownership

The Oracle iLearning Documentation Manager is responsible for ensuring that this document is necessary and that it reflects actual practice.

Activity Preface

These tasks are performed whenever a content server needs to be set up and accessible by Oracle iLearning.

Overview

You can configure any file server as a content server. An Oracle iLearning secured content server provides additional security to ensure users can only access content from within Oracle iLearning, and not directly from their browser entering a URL. This is achieved by configuring the Oracle Application Server 10g (9.0.4) with an additional Oracle iLearning module, called the Gatekeeper. After adding this module, all URL references to the content must be authorized by Oracle iLearning before users can view it. You can also choose to protect some directories, and not others, by modifying the httpd.conf file on the Oracle Application Server 10g.

Note: This step requires an FTP server configuration on each content server machine, plus an Oracle iLearning installation and set up.

Note: It is not a requirement that content resides on an Oracle iLearning secured content server. You may choose to utilize non-secured servers if you like. Content located on non-secure content servers will be accessible by users outside of Oracle iLearning.
To make your file server an Oracle iLearning content server, please follow the steps below carefully. Some steps are only required on the content server machines, other steps are required on each Oracle iLearning middle tier application server:

Oracle iLearning DBA

1. Install and configure the Oracle Application Server 10g on each content server machine.

2. Perform a Middle Tier Only installation on each content server machine.

3. Ensure you can successfully connect to Oracle iLearning.

If you can successfully connect, goto task #5. Otherwise, goto task #4.

4. Resolve any database, application server, or installation issues.

Goto task #3.

5. Stop the Oracle Enterprise Manager daemon on each content server machine and every Oracle iLearning Middle Tier application server machine.

• Please refer to the Oracle Application Server 10g documentation for detailed information on starting and stopping this service.

6. Stop the Oracle Application Server 10g daemon on each content server machine and every Oracle iLearning Middle Tier application server machine.

• Please refer to the Oracle Application Server 10g documentation for detailed information on starting and stopping this server.

7. Create a physical directory on each content server machine where content will be stored.

Note: This document only describes the setup of a content directory under the <AS_HOME>/Apache/Apache/htdocs/ directory. For example:
<AS_HOME>/Apache/Apache/htdocs/ilearning/content_server

8. Copy the Gatekeeper module file from the <ORACLE_HOME>/ilearn/install/apache/ directory into the appropriate directory on each content server machine.

• For Windows: Copy the ApacheModuleAuthIla.dll module to the <AS_HOME>/Apache/Apache/modules directory.
• For UNIX: Copy the mod_auth_ila.so module to the <AS_HOME>/Apache/Apache/libexec directory.

9. Add the required lines to the Oracle Application Server 10g configuration file on each content server machine.

• The configuration file is located at: <AS_HOME>/Apache/Apache/conf/httpd.conf
• You can use the <ORACLE_HOME>/ilearn/install/httpd.conf-template.txt file for a sample of the configuration changes
• The HOST and LISTEN port values must be the same in order for the Gatekeeper module to function properly.
• The iLearningAuthKey value must be the same as the ENCRYPTION_KEY value in the ilearning.properties file for the Gatekeeper module to function properly. The key must be 64 characters in length. If the values do not match, all learners will receive a "Forbidden" error message when attempting to access content on an Oracle iLearning secured content server even if they are authorized to view the content.
• Note: You must understand Oracle Application Server 10g administration and cluster management before performing any of the following changes. Please refer to the Oracle Internet Application Server documentation for detailed information.
• The following line starts the Gatekeeper every time Oracle Application Server 10g is started. This should go in the section labeled "Dynamic Shared Object (DSO) Support":

• For Windows: LoadModule ila_auth_module modules/ApacheModuleAuthIla.dll
• For UNIX: LoadModule ila_auth_module libexec/mod_auth_ila.so

• Windows Only: This line enables the Oracle Application Server 10g to locate the Gatekeeper module. This should go in the section labeled "Dynamic Shared Object (DSO) Support":

• AddModule mod_auth_ila.c

• Add an Alias for the Oracle Application Server 10g of your physical directory to locate the stored content. This should go in the section labeled "Aliases" under "IfModule mod_alias.c":

Alias /<virtual content directory>/ "<AS_HOME>/Apache/Apache/htdocs/<physical content directory>/"

Use the information below to help define the base directory where all content used by Oracle iLearning will be stored:

• Determine where the content will be stored.
  Note: This document only describes the setup of a content directory under the <AS_HOME>/Apache/Apache/htdocs/ directory. For example:
  <AS_HOME>/Apache/Apache/htdocs/ilearning/content_server
  Alternatively, you could establish UNIX soft links to any other directory from this location.
• Any name can be used for the <virtual content directory> directory.
• The <virtual content directory> and <physical content directory> values are required when setting up content servers within the Oracle iLearning application
• For example, to store content in the <AS_HOME>/Apache/Apache/htdocs/ilearning/content_server/ directory, you would use the following:
  Alias /content/ "/u01/app/ias/Apache/Apache/htdocs/ilearning/content_server/"

• Add the following lines to protect the secure directory to which Apache has access. You must also create the physical directories that are specified here.

• <Directory "<AS_HOME>/Apache/Apache/htdocs/<secure physical directory>">
       AuthType iLearning
          require valid-user
          iLearningAuth on
          iLearningAuthKey <ENCRYPTION_KEY value from ilearning.properties entry>
       ErrorDocument 403 http://<Oracle iLearning Website Address>
  </Directory>
  Use the information below to help configure this line:

• This command protects all content under <secure physical directory>, except streaming media audio files which must be exempted from the secured location (.wma). 
• For example, to prevent unauthorized access to content under the <AS_HOME>/Apache/Apache/htdocs/ilearning/content_server/secure directory, you would specify the following
  <Directory "/u01/ias/Apache/Apache/htdocs/ilearning/content_server/secure">
       AuthType iLearning
          require valid-user
          iLearningAuth on
          iLearningAuthKey 2a9021bea78b754a7156c17e1eaccb4c840ff9bd81c547ff813b6ef1abc788f
       ErrorDocument 403 http://<Oracle iLearning Website Address>
  </Directory>
• If your content server will also store Windows Media streaming (.wma) files, add the following lines to ensure that gatekeeper does not prevent the player from accessing these files. This line, if added, must be included in the <Directory> tag as indicated in the example below:
  <Directory "/u01/ias/Apache/Apache/htdocs/ilearning/content_server/secure">
       AuthType iLearning
          require valid-user
          iLearningAuth on
          iLearningAuthKey 2a9021bea78b754a7156c17e1eaccb4c840ff9bd81c547ff813b6ef1abc788f
       <Files *.wma>
          iLearningAuth off
       </Files>
       ErrorDocument 403 http://<Oracle iLearning Website Address>
  </Directory>

• Add the following lines to unprotect the public directory to which Apache has access:

• <Directory "<AS_HOME>/Apache/Apache/htdocs/<unsecure physical directory>">
       AuthType iLearning
          require valid-user
          iLearningAuth off
       ErrorDocument 403 http://<Oracle iLearning Website Address>
  </Directory>
  Use the information below to help configure this line:

• This command removes Gatekeeper protection from the <unsecure physical directory> and all its subdirectories.
• This line is not required if all directories are to be secured.
• For example, to allow anyone to access content under the /u01/ias/Apache/Apache/htdocs/ilearning/content_server/public directory, you could specify the following:
  <Directory "/u01/ias/Apache/Apache/htdocs/ilearning/content_server/public">
      AuthType iLearning
          require valid-user
          iLearningAuth off
       ErrorDocument 403 http://<Oracle iLearning Website Address>
  </Directory>

10.    Install and configure an FTP server on each content server machine.

An FTP server running on the same Oracle iLearning content server machine is mandatory.

Use the following steps as guidelines for configuring an FTP server:

• Start the FTP server.
• Create one FTP user.

• The FTP username must be the same operating system username used for installing Oracle Application Server 10g and Oracle iLearning. The same operating system user should be used during the installation of both Oracle Application Server 10g and Oracle iLearning, regardless of whether they are being installed in the same or different Oracle Homes.
• The same username and password must be used when configuring the ftpuser and ftppassword properties in the ilearning.properties file (Refer to the Oracle iLearning configuration step 11).
• The Upload Files feature in the Oracle iLearning administrative user interface can only succeed if the owner of the Oracle Application Server 10g files is used for the ftpuser property when setting up the ilearning.properties file.
• The FTP protocol is required only between Oracle iLearning application servers and the content servers.
• Oracle iLearning does not use the FTP protocol to upload files from the user's browser. The compressed ZIP files are transferred from the browser to the Oracle iLearning application servers using the standard HTTP protocol and then are transferred from the Oracle iLearning application server to the content server using the FTP protocol.

• For each alias created in your httpd.conf file (as per step 9)

• Make sure all required physical directories have been created
• Make sure the FTP user has full access to the base directory when all Oracle iLearning content will be stored. For example, if the following directories were created:

• /u01/ias/Apache/Apache/htdocs/ilearning/content_server/secure
• /u01/ias/Apache/Apache/htdocs/ilearning/content_server/public

Then, the FTP user should have full access on the
/u01/ias/Apache/Apache/htdocs/ilearning/content_server directory.

• From another machine, attempt to FTP to this machine using the username and password you just created. If you are unsuccessful, stop and restart the FTP server and try again.
• Refer to your specific FTP server documentation for more information.
• Note: Windows 2003 Server installations only:
  There is a default FTP server created during the Windows 2003 Server installation. You can either:

• Disable the Windows 2003 FTP server (from the Internet Services Manager) and install another FTP server
• Configure the Windows 2003 FTP server. The following steps may assist your configuration:

• From Start Menu->Administrative Tools, launch Start Internet Services Manager
• Select the name of the machine in the tree and create a new FTP site using the wizard. You need to define the following:

• A new name for the FTP site
• The IP address and port
• The default home directory for the FTP site
• Both Read and Write for the directory

• Edit the properties for the FTP site. From the Security Accounts tab:

• Select Allow Anonymous Connections
• In the Username field, select a username. This must be the same user that will be specified as the FTP user in the ilearning.properties file. You will enter this in step 11.
• Enter the password for the user. This must be the same password that has will be specified as the FTP user in the ilearning.properties file. You will enter this in step 11

• Select the FTP server site you just created, and use the wizard to create a new Virtual Directory. You need to define the following:

• An alias that will be used to access the Oracle content server directory. This must be the same virtual directory that was specified as the alias in the httpd.conf file. For example, content
• The physical content server location. This must be the same physical directory that was specified as the alias in the httpd.conf file. For example,  c:\oracle\ias904\Apache\Apache\htdocs\content_server
• Privileges for the FTP user, which should be both Read and Write for the directory

• Edit the properties for the windows directory that you specified as your physical content server location.

• Select the Security tab
• Add the username that you created in the FTP server setup

11.    Modify the file ilearning.properties file on all Oracle iLearning middle tier application servers.

Note: This is not required on content server machines, unless they are also an Oracle iLearning middle tier application server.

• The ilearning.properties file is located in <AS_HOME>/j2ee/oil/applications/ilearning/ilearn/WEB-INF directory.
• Edit this file to provide the correct values for the ftpuser and ftppassword. This is an FTP user that should be set up on the FTP Server on your content server machine. This user should have permissions on the content server directory to transfer content using FTP. The default values during installation are:

• FTP User: ftpuser
• FTP Password: ftpuserpassword

• For example, if a UNIX ftp user called ilearnftp was created on the content server machine with password ilearn_transfer, the following values could be used:
  ftpuser=ilearnftp
  ftppassword=ilearn_transfer

12.    Save the configuration file.

13.    Update the Oracle Application Server 10g repository

• This must be performed on the content server machine and all middle tier application servers for the above changes to take effect.
• Please refer to the Oracle Application Server 10g documentation for detailed information on updating the repository.

14.    Stop the Oracle Application Server 10g daemon on each content server machine and every Oracle iLearning Middle Tier application server machine.

• Please refer to the Oracle Application Server 10g documentation for detailed information on starting and stopping this server.

15.    Start the Oracle Application Server 10g daemon on each content server machine and every Oracle iLearning Middle Tier application server machine.

• Please refer to the Oracle Application Server 10g documentation for detailed information on starting and stopping this server.

16.    Start the Oracle Enterprise Manager daemon on each content server machine and every Oracle iLearning Middle Tier application server machine.

• Please refer to the Oracle Application Server 10g documentation for detailed information on starting and stopping this service.

17.    The content server is now set up.

All Oracle iLearning middle tiers can access this content server.

Defining the Content Server in Oracle iLearning

18.    Define which sites will have access to this content server.

Oracle iLearning Administrator

19.    Log in to Oracle iLearning as an administrator on the Root Site.

20.    Click the Admin icon in the upper right corner of your browser window.

21.    Select the site that should have access to the content server, for example, the Root Site or Site1.

22.    Click the More... tab.

23.    Choose Content Servers.

24.    Click Add Content Server to view the list of available content servers.

25.    Click New Content Server to define a new content server.

26.    Enter the appropriate information to define a new content server (all fields are mandatory).

• Enter the content server Name
• Enter the content server Host and Port
• Enter the Physical Path to the content server directory
• Enter the Virtual Path to the content server directory
• Note: The information entered here needs to match with the information placed in the httpd.conf file on the web server. Please ensure to coordinate these efforts with your Oracle iLearning DBA.

27.    Click Save to define the content server in Oracle iLearning.

28.    To make the content server available to the site, check the Select box next to the content server name, and click Make Available to Site.

If you plan to use SCORM-based content, stop and complete Setting Up the Oracle CMI Adapter. Otherwise, goto task #29.

29.    Use the Upload Files option in Oracle iLearning to transfer their content to the content server.

When their content resides on an Oracle iLearning content server, content developers should always choose the iLearning Secured option when specifying the Content Location for a content object.

End of activity.

Have finished oracle dba training about Oracle Academy Teacher Training in Guangzhou .

Thanks for all teachers.!

1. Introduction
2. Installation
3. DB Creation
4. Instance
5. Storage
6. Users
7. Schema
8. Data & Concurrency
9. Undo
10. Security
11. Network
12. Proactive Maintenance
13. Performance
14. Backup & Recovery Concepts
15. Backup
16. Recovery
17. Flashback
18. Moving Data

环境：
- OS：Oracle Enterprise Linux 5.3 (Lastest version)
- VM: Vmware workstation 6.5
- Desktop:Dell PC
- Application :Oracle E-Business Suite R12.1.1 VIS Demo+ 简体中文补丁

Oracle E-Business Suite R12.1.1 安装配置问题总结

安装配置步骤：
- http://edelivery.oracle.com/ 上下载EBS for Linux X86 安装介质
- 安装Vmware workstation 6.5
- 在VM上安装Oracle Enterprise Linux 5.3（可以在http://edelivery.oracle.com/ 下载）
- ftp ebs zip file to Linux
- unzip zip file on linux
- 安装 Oracle E-Business Suite R12.1.1 Visom Demo
- 安装EBS 中文补丁
- 性能稍微调整（因为是测试用，很多参数没必要那么大）
当中的问题总结：
- 安装Linux 尽量把所有包都选择上，否则，安装EBS中会出现错误
- 调整 Linux 的某些参数
- 检查EBS 需要的OS的包
- 做重要的下面两个命令，否则EBS中有错误
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
- 修改如下，否则DB 会有错误
以root身份，通过以下命令查询SELinux的模式：getenforce 默认应当返回Enforcing
通过以下命令更改模式：setenforce 0
然后再次查询getenforce，应该返回permissive了
- 安装完毕，主画面没问题，进去FORM出现错误，解决方法：
[oracle@r12test opmn]$ vi HTTP_Server~1.log
[oracle@r12test opmn]$ pwd
/u01/oracle/VIS/inst/apps/VIS_r12test/logs/ora/10.1.3/opmn
[oracle@r12test opmn]$

09/08/10 17:31:50 Start process
--------
/u01/oracle/VIS/inst/apps/VIS_r12test/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

--------
09/08/10 17:31:52 Start process
--------
/u01/oracle/VIS/inst/apps/VIS_r12test/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
32,1 Bot
ln -s /usr/lib/libdb-4.3.so /usr/lib/libdb-3.3.so

[root@r12test ~]# ln -s /usr/lib/libgdbm.so /usr/lib/libdb.so.2

had to use this instead:
ln -s /usr/lib/libgdbm.so.2 /usr/lib/libdb.so.2

[root@r12test ~]# ls -rtl /usr/lib/libdb.so.2
lrwxrwxrwx 1 root root 19 Aug 10 17:47 /usr/lib/libdb.so.2 -> /usr/lib/libgdbm.so

- 打中文补丁前，先打如下补丁：
Patch 8508724
- 打到最后还剩8个的时候出现错误。
Applying 6678700_PTB - 12.1.1 : Upgrade Patch

Fails on : FAILED: file XLIFFLoader.class on worker 1.

--------details-------------------------
Invoking Utility XLIFFLoader ...
Class: oracle.apps.xdo.oa.util.XLIFFLoader
Method: processXLIFF
Arguments: UPLOAD -DB_USERNAME &un_apps -DB_PASSWORD &pw_apps -JDBC_CONNECTION &jdbc_db_addr
-APPS_SHORT_NAME OFA -TEMPLATE_CODE FADTXD -FILE_NAME
&fullpath:fa:patch/115/publisher/templates/PTB:FADTXD.xlf
TimeStamp : [Wed Jul 01 22:53:56 BRT 2009]
==========================================================
XLIFFLoader started: Wed Jul 01 22:53:56 BRT 2009

[FILE_NAME]
[/d01/oracle/VIS/apps/apps_st/appl/fa/12.0.0/patch/115/publisher/templates/PTB/FADTXD.xlf]
[APPS_SHORT_NAME] [OFA]
[UPLOAD] [UPLOAD]
[DB_USERNAME] [APPS]
[JDBC_CONNECTION]
[(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)
(HOST=<host>.<domain>)(PORT=<port>)))(CONNECT_DATA=(SID=<sid>)))]
[DB_PASSWORD] [*****]
[TEMPLATE_CODE] [FADTXD]

Target file: FADTXD.xlf
[070109_105356316][][EXCEPTION] java.io.UTFDataFormatException: Invalid UTF8 encoding.
at oracle.xml.parser.v2.XMLUTF8Reader.checkUTF8Byte(XMLUTF8Reader.java:160)
at oracle.xml.parser.v2.XMLUTF8Reader.readUTF8Char(XMLUTF8Reader.java:203)
at oracle.xml.parser.v2.XMLUTF8Reader.fillBuffer(XMLUTF8Reader.java:120)
at oracle.xml.parser.v2.XMLByteReader.saveBuffer(XMLByteReader.java:450)
at oracle.xml.parser.v2.XMLReader.fillBuffer(XMLReader.java:2488)
at oracle.xml.parser.v2.XMLReader.tryRead(XMLReader.java:1089)
at oracle.xml.parser.v2.XMLReader.scanXMLDecl(XMLReader.java:3047)
at oracle.xml.parser.v2.XMLReader.pushXMLReader(XMLReader.java:521)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:288)
at oracle.apps.xdo.oa.util.TemplateTranslator.createMLSTemplates(TemplateTranslator.java:238)
at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:738)
at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:586)
at oracle.apps.xdo.oa.util.XLIFFLoader.processXLIFF(XLIFFLoader.java:1153)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.ad.worker.AdJavaWorker.invokeUtility(AdJavaWorker.java:503)
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:356)

Exception while parsing base template
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Wed Jul 01 22:53:56 BRT 2009]
Updating task with status 1

AD Worker error:
The utility XLIFFLoader returned error for the above task.

解决方法
-- To implement the solution, please execute the following steps::
1. In a separate UNIX session, set the APPS environment.

2. Then run the following commands from the command line.
Please note each is a single command.

In these commands, it is assumed the APPS username and password is apps/apps. If this is not correct then please change them approriately in this section:
-DB_USERNAME apps -DB_PASSWORD apps

Command to reload US XML
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD
-DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION
"(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTO=tcp)(HOST=<host.dimain- taken from error message above>)(PORT=<port- taken from error message above>)))(CONNECT_DATA=(SID=<sid - taken from error message above>)))"
-LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00
-XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME
$FA_TOP/patch/115/publisher/defs/FADTXD.xml

_______________________________________________________________________
.
Command to reload US RTF
.
adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD
-DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION
"(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=<host.dimain- taken from error message above>)(PORT=<port- taken from error message above>)))(CONNECT_DATA=(SID=<sid - taken from error message above>)))"
-LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en
-TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME
$FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf

Once the commands have completed successfully, restart the failed worker and verify the equivalent language script runs successfully.

以上做完就基本完成了，别的就可以傻瓜式进行了。。

声明：以上只是系统测试，正式生产环境请严格安装ORACLE 正式文档操作和正常的IT规划去操作，
这些只是本人观点，并不代表任何组织和个人。。呵呵

环境：

- Oracle VM

- Oracle Enterprise Linux5.3

- Siebel 8.1.1 +Chinese Package

- Database 11.1.0.7

由于Linux 的多个环境变量的问题折腾了好长时间才搞明白

最难受的是最后的一“哆嗦”，搞了好几天，才明白原来是License code 的问题。。

环境：

- Oracle Enterprise Linux 5.3

- Oracle ebs 12.1.1 +chinese package

新东西+最新的OS，问题还是不少的。

出现的问题都做了记录，有时间的话整理出来，共享 出来，免的再走弯路。减少点痛苦

2008.03

本文档目的是为了广大 - Oracle EBS Release12 爱好者测试参考使用，本文档内容将全部是Oracle 技术内容，将不含有任何可能有商业信息的内容，请不要用于其他商业用途，如有违反，原创作者有权追究相关责任

文章主要内容:
    - Oracle EBS R12 DB/AP 跨Server 安装
    - Oracle EBS R12 DB 单instance 转换成双节点RAC
    - Oracle EBS R12 Muti App Server Setup and Configration
    - Parallel Concurrent Processing（PCP） 安装配置
   - Muti APP/PCP/DB RAC 功能测试
   - ERP 系统备份和恢复系统测试

测试系统环境

软件信息

测试环境软件清单

l 操作系统：HP-UX 11.23

l Application:Oracle E-Business Suite 12.0.4

l 数据库：Oracle DB Enterprise Edition 10.2.0.2

l Oracle Cluster Software 10.2.0.2

l HP MC/Service Guard 11.16

l HP Service Guard Cluster File System(CFS) 11.17

资源分布

系统资源分布

测试环境搭建

安装新系统

安装一套DB/AP分布到2台机器 上的新系统

l 在DB 和AP 服务器上分别创建oratest和appltest 用户

l 分别在DB/AP 服务器上创建相同的文件系统，例如：/u01/prod

l 详细安装方法，请参考我以前写过的文档

安装Oracle Cluster Software(CRS)

l Check Network Requirements(public/private/vip 设置检查)

l Verify Kernel Parameters

详细设置参数请参考Metalink Notes

l Check rsh and Host Equivalence

l Set up Shared Storage

这部分由HP工程师已经准备完毕，所以，不用做任何操作

配置Oracle DB RAC

l 详细方法请参考我以前写过的Single Instance Conversion RAC

小结

l 通过以上的步骤已经完成从单instance 向Oracle db RAC的转变

测试过程

双AP安装和配置

Shared Application Tier File System Layout

双AP安装和配置

操作过程

l Clone Application Server

$cd $INST_TOP/admin/scripts

$perl adpreclone.pl appsTier

l 限制操作修改现有AP SV文件属性

$mkdir $HOME/bin

$ln –s /bin/true $HOME/bin/chmod

$PATH=$HOME/bin:$PATH

l Create a new context file for new node

$cd /u01/ test/apps/apps_st/comn/clone/bin

$perl ./adclonectx.pl addnode \

Contextfile= ../context/apps/TEST_erpapp1.xml

l 删除文件限制属性

$rm $HOME/bin/chmod

l 产生一个新的Intance Home for new Node

$cd /u01/test/apps/apps_st/appl/ad/12.0.0/bin

$$AD_TOP/bin/perl ./adconfig.pl \

/u01/test/apps/TEST_erpapp2/appl/admin/TEST_erpapp2.xml

测试过程

对比两个节点Contextfile的下面值

测试过程

LoadBalance 安装

Load Balance System Layout

修改context文件

测试环境安装

F5 设置

操作过程

l 此部分有网络厂商完成，不过DBA需要指导他们去完成

测试环境安装

PCP配置

l Execute AutoConfig by using $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.

l Source the application environment.

l Check the configuration files tnsnames.ora and listener.ora located at $INST_TOP/ora/10.1.2/network/admin. Ensure that you have information of all the other concurrent nodes for FNDSM and FNDFS entries.

l Restart the application listener processes on each application node.

l Logon to Oracle E-Business Suite Release 12 using SYSADMIN in login and System Administrator Responsibility. Navigate to Install > Nodes screen and ensure that each node in the cluster is registered.

l Verify whether the Internal Monitor for each node is defined properly with correct primary and secondary node specification and work shift details. Also make sure the Internal Monitor manager is activated by going into Concurrent -> Manager -> Administrator and activate the manager.
(e.g. Internal Monitor: Host2 must have primary node as host2 and secondary node as host3)

l Set the $APPLCSF environment variable on all the CP nodes pointing to a log directory on a shared file system.

l Set the $APPLPTMP environment variable on all the CP nodes to the value of the UTL_FILE_DIR entry in init.ora on the database nodes. This value should be pointing to a directory on a shared file system.

l Set profile option ' Concurrent: PCP Instance Check' to OFF if database instance-sensitive failover is not required. By setting it to 'ON', Concurrent Managers will failover to a secondary Application tier node if the database instance it is connected to goes down.

Set Up Transaction Managers

l Shut down the application services (servers) on all nodes

l Shut down all the database instances cleanly in RAC environment using the command:
SQL>shutdown immediate;

l Edit $ORACLE_HOME/dbs/<context_name>_ifile.ora. Add the following parameters:

§ _lm_global_posts=TRUE

§ _immediate_commit_propagation=TRUE

l Start the instances on all database nodes, one by one

l Start up the application services (servers) on all nodes

l Logon to Oracle E-Business Suite Release 12 using SYSADMIN login and System Administrator Responsibility.
Navigate to Profile > System and change the profile option ‘Concurrent: TM Transport Type' to ‘QUEUE' and verify the transaction manager works across the RAC instance.

l Navigate to Concurrent > Manager > Define screen, and set up the primary and secondary node names for transaction managers

l Restart the concurrent managers

l If any of the transaction managers are in de-activated status, activate them using
Concurrent > Manager > Administrator screen.

Set Up Load Balancing on Concurrent Processing Nodes

l Edit the applications context file through Oracle Applications Manager interface and set the value of Concurrent Manager TWO_TASK (s_cp_twotask) to load balancing alias (<service_name>_balance>)

l Execute AutoConfig by using $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.

功能测试

双AP 功能测试

双AP功能测试

l 可以通过拔网线的方式，模拟机器故障，详细过程，由于原来的截图不能在次显示

PCP 功能测试

PCP功能测试

l 可以通过拔网线的方式，模拟机器故障，详细过程，由于原来的截图不能在次显示

DB RAC功能测试

DB RAC功能测试

l 这个是普通DB RAC测试一样，整体思路，TNS文件。。拔网线模拟故障

备份系统测试

备份/恢复测试

备份测试

l 采用第3方软件，如TSM，Veritas或者HP DP+RMAN进行归档方式备份

恢复测试

l 采用第3方软件，如TSM，Veritas或者HP DP+RMAN进行归档方式恢复

总结

l 本文档只是能给大家一个思路，详细操作过程还需要参考metalink相关notes

                                                                                                                                                                               2009.05.01

Purpose

本文档的目的是Oracle Agile PLM 爱好者，自己测试Oracle Agile PLM 的安装、基本配置以及简单的功能测试,PROD环境建议参照Oracle 官方文档进行

主要内容
Agile 数据库服务器
安装Agile数据库软件
安装配置Agile 数据库
设置Oracle监听
配置数据库并测试Agile连接
Agile 应用服务器
Agile 9.2 AS的安装；
部署（Deploy）Agile应用服务器
安装配置Agile Viewer Server [OPTION]
安装AutoVue
验证AutoVue Server
登陆测试
Agile PLM 9.2.2.4
登录 web Client
部署Java Client
验证系统并确认安装完成
中文界面的切换以
新用户增加和权限设置

Pre-installation

Prerequisite

操作前，必须确认的事项

1． Disk Space 规划是否做好？建议d盘给50G左右空间。

2． Install Media CD 是否准备好？建议把安装介质COPY到硬盘中安装。

3． 需要的OS 和PLM 的Patch Source 最好提前下载好，并确认Source 文件完整性。

Prepare OS（XP）

安装中注意事项

1． 建议安装到XP SP2以上，并安装好病毒防护软件

2． 建议暂时关闭防火墙

3． 如果是DHCP 的话，安装Microsoft loop adapter “

Oracle Agile 安装步骤

Oracle Database 安装

点击DB安装包中的”setup”按纽 ，此安装版本为10201,因为只用于测试，所以没再打不顶，正式项目使用建议打到10204 版本：

Oracle companion 安装

PLM DB instance 生成

数据库网络监听配置

Agile PLM 安装

Agile PLM Configration

Agile View Installation

File Server configration

用户中文画面切换

参考资料

安装和文档参考了如下资料

http://metalink.oracle.com