Apps DBA& Architect Knowledge Warehouse

OS:Redhat Linux AS4
DB:11.2.0.1 (Latest Version)
DB Client:11.1.0.6
Tomcat:6.0.20
Oracle Financial Services Analytical Applications 7.1(Latest Version)
Oracle Financial Services Funds Transfer Pricing5.1((Latest Version)

用了1周的时间,从没任何概念对OFSAA,到完全熟悉这个系统架构..

辛苦自己了..哈

今天在用IE8 访问EBS R12 的是否发现FORM的连接错误
并出现如下的现象
- IE好象死掉的样子,长时间没反映,并且没办法关闭,
- 错误信息 FRM-92050:连接服务器失败:/forms/lservlet:-1

在support.oracle.com上查找相关资料,发现IE8还没有被认证
解决方法:降级到IE7

Applies to:
Oracle Applications Technology Stack - Version: 11.5.10 to 12.0
Information in this document applies to any platform.

Goal
When will Internet Explorer 8 be certified with Oracle E-Business Suite 11i and R12?

Solution
Internet Explorer 8 is currently not supported and there is no estimate on the Certification date
at this time.

Please monitor Steven Chan's blog for additional information related to the certification date of Internet
Explorer 8.
http://blogs.oracle.com/stevenChan/2009/01/block_microsoft_internet_explorer_8_for_ebs_users.html

January 7, 2009
Block Microsoft Internet Explorer 8 for EBS Users
Steven Chan • January 7, 2009
Brace yourself: another browser is coming. It looks like Microsoft is gearing up for an imminent
release of Internet Explorer 8. Neither Oracle E-Business Suite Release 11i nor 12 have been
certified with IE8 yet. Our latest tests of the IE8 Release Candidate drops have shown that there
are a number of important compatibility issues that need to be resolved.
...
I don't have firm schedules for our IE8 certification yet. You're welcome to monitor or subscribe
to this blog for updates, which I'll post as soon as soon as they're available.

为配合Agile PLM在中国市场的大卖,并且针对AGILE 大好的市场,成立了Agile user experience center setup is completed(Agile 用户体验中心)
熬夜+周末加班,终于搞的差不多了..
主要体验内容如下

- 最新的Agile 9.3 Instance 真实系统体验
- 针对医疗器械行业的完整的真实数据+CAD 真实环境体验
- 针对高科技行业的DEMO UPK 演示
- 神奇的,很旋的AutoVue 的 真实系统体验
- 其他行业DEMO UPK演示

There are the following contents in Agile User Experience Center
 Physical Agile9.3 instance(Include really demo data& CAD files) user experience
 Agile 9.3 Standard functions and new feature Demo UPK
 Agile for High Tech Industry Demo UPK
 Agile for Medical Device Industry Demo UPK
 AutoVue19.3 for agile Demo UPK

The main features of the Agile User Experience Center
 DEMO presentation can first by looking and then can to experience in a real environment.
 This demo kit is designed and recorded aim to demonstrate new and enhanced features in Agile Product Lifecycle Management 9.3, which had covered most modules in Agile PLM solution, includes Product Portfolio Management, Product Quality Management, Product Cost Management, Product Governance and Compliance with industrial solution overview for Medical Device and High Tech.
 There are also some key features introduced in this demo kit such as administrative functions, data import & export and Agile web service utilities, etc.

特此记录(2009,11.16~11.20)

感谢东三省人民的热情款待,感谢教育厅各位领导的大力支持.

更感谢参加我讲课的 40 位大学老师们,特别感觉民航的郑老师,每天中午帮我把盒饭的盒子顺便给扔掉...哈哈

都感谢!

环境:

- Oracle EBS R12.1.1

- Linux 5.3

详细内容请看如下

故障现象:

- tnsping VIS 延时很长,不能忍受的地步

- 应用层面启动不成功

分析过程:

- 检查/etc/hosts, 把IP6的相关内容注释掉,因为根本没用到IP6

- ping localhost 很快

- ping hostname 很快,并且能够解析

- cd $ORACLE_HOME/nework/context_name/admin/tnsnames.ora,sqlnet.ora,lisenter.ora 文件检查,试图把hostname 换成IP,结果还是不理想

- telent hostname 1521 速度很快

- server 上sqlplus "/as sysdba"速度很快

- server sqlplus system/oracle@VIS速度很慢

%100 确定监听出了问题

- tracerouter hostname 就一跳 ,,应该没问题

- metlink上查找相关文件,怀疑有BUG存在..

- 找到类似的 What was changed between the two is the way Oracle resolves hostnames to IPs, more specifically the system call used to do that.

Oracle 11g use now getaddrinfo() while 10g used gethostbyname().

These system functions requires different configuration in /etc/nsswitch.conf.

gethostbyname() require the use of keyword "hosts" while getaddrinfo() the use the keyword "ipnodes"

This happens even if Name Server Switch configuration (nsswitch) specifies the hosts file prior to dns lookups:

/etc/nsswitch.conf
hosts: files [NOTFOUND=continue] dns
or only:
hosts: files 这样的DOC..

- 看来是因为Server 本身的DNS起作用了,DNS一起作用,hosts就有问题了

- /etc/resolv.conf

;generated by /usr/sbin/oraclevm-template
#search hostname

#options timeout:15
#options timeout:15
#nameserver hostname

全去掉,或者干脆把resolv.conf move 掉

- 最后把/etc/sysconfig/network中IP6相关的东西都去掉了

再测试,就OK了

Oracle Agile PLM Bootcamp training(Hands-on)

- 时间:2009,12,8~ 12,11

-地点:PSC 北京training room

主要内容

Day 1:
• Introductions

• Agile Product Collaboration Review

• Overview/Navigation

• Items

• AML

• Attachments

• BOM

• Import

• Changes

• Lab(s)

Day 2:

• Agile Administrator Review

• Data Settings

• User Settings

• System Settings

• Server Settings

• Lab(s)

• Configuration Workbook

• Implementation Methodology

Implementation Scoping and Planning

Day 3:

• Implementation Configuration Workshops

• Implementation Best Practices

• Implementation BPR Workshops

• File & Data Load

• Group Lab(s)

Day 4:

• Review Agile Quality Module

• Implementation Agile Quality Module

• Implementation Agile Quality Module Best Practices

• Lab(s)

• Assessment

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.