oracle ilearning installation guide release 6 1

8/9/2019 Oracle ILearning Installation Guide Release 6 1

1/47

Oracle iLearning InstallationGuide - Release 6.1

Part No. E49209-02

February 2014


2/47

Copyright 2001, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of theirrespective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are usedunder license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMDlogo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is aregistered trademark of The Open Group.

This software and related documentation are provided under a license agreement containing restrictions on use anddisclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreementor allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute,exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, ordecompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If youfind any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalfof the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, anyprograms installed on the hardware, and/or documentation, delivered to U.S. Government end users are

"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specificsupplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs,including any operating system, integrated software, any programs installed on the hardware, and/ordocumentation, shall be subject to license terms and license restrictions applicable to the programs. No other rightsare granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is notdeveloped or intended for use in any inherently dangerous applications, including applications that may create a riskof personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible totake all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation andits affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerousapplications.

This software or hardware and documentation may provide access to or information on content, products, andservices from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all

warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and itsaffiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-partycontent, products, or services.

Author

Dean Hillman, Prakash Pulla

This book was published using: OracleTutor


3/47

Table of Contents

Oracle iLearning Installation Guide - Release 6.1 .........................................................................................1-1

Oracle iLearning Installation Guide - Release 6.1 ..........................................................................................1-3

Overview of Oracle iLearning 6.1 Release .................................................................................................1-4

Oracle iLearning 6.1 Release Information ..................................................................................................1-8

Upgrade to Oracle iLearning Release 6.1 from Release 6.0 ......................................................................1-12

New Installation of iLearning 6.1 ................................................................................................................1-16

Oracle iLearning Content Server and Oracle CMI Adapter ........................................................................1-29

Scheduling and Running Batch Jobs .........................................................................................................1-38

Troubleshooting Oracle iLearning 6.1 ........................................................................................................1-39


4/47

Copyright 2014, Oracle and/or its affiliates. All rights reserved.

Oracle iLearning Installation Guide - Release 6.1

Chapter 1 - Page 1

Oracle iLearning InstallationGuide - Release 6.1

Chapter 1


5/47



Chapter 1 - Page 2


6/47



Chapter 1 - Page 3



7/47


Overview of Oracle iLearning 6.1 Release

Chapter 1 - Page 4


Oracle iLearning Release 6.1 provides the following new features:

Access Oracle iLearning on Mobile Devices:

With Oracle iLearning Release 6.1, learners can access Oracle iLearning on their mobile

devices such as Smartphone or Tablet.iLearning now offers a mobile interface for iLearning. The mobile version is a simplified setof iLearning pages aimed at mobile devices. A new 'Always Show Simple Interface' checkbox on the Profile User Information page even makes it possible to use the simplifiedinterface on a PC, especially helpful for infrequent users or users not comfortable using aPC. If this check box is selected, then the simpler iLearning user interface version can beaccessed from PC or a mobile device. If the check box is not selected, then the normal userinterface will be shown when iLearning is accessed from a PC and the simpler version isshown if iLearning is accessed from a mobile device.

Using the simpler interface on mobile devices, learners can:

Use the Search and Browse Catalog feature to search for learning events and viewdetails of the events.

Enroll in learning events or play the events.

View both self-paced and scheduled offerings in the My Learning page. Click thePlay button or Resume button to begin or resume an offering. The player status orenrollment status or both statuses is visible for offerings, depending on the settingdefined by the site administrator.

View the learning paths in which they are subscribed in the Learning Paths page.They can click the learning path name to see its details, including the sequence ofcourses. The Status of the learning path indicates the overall status of theunderlying offerings.

View a list of certification offerings in the Certification page and their current

enrollment status. They can click the Play button to automatically launch thecertified offering in the player.

View details of the integrated learning events. They can enroll in an integratedlearning event and play.

View learning history of non-certification offerings, certification offerings, andlearning paths.

Manage profile and contact information.

Configure Look and Feel of iLearning on Mobile Devices

A new Configurable Theme for Mobile Devices field is available on the Root Site: Propertiespage for site administrators. This field enables an administrator to select the look-and-feel

for the iLearning site on mobile devices. This feature works in the same way as the existingConfigurable Theme option, which governs the layout of the PC interface.

Changes to the Learner PagesThe following changes have been made to the Learner Home Overview page:

The Learning Path section is removed from the Overview page to make the Overviewpage easier to navigate and also to have a more consistent functionality.

The two columns "Start Date" and "Enrolled" on the Learner Home page are nowcombined into one called Start Date. For synchronous online and offline (classes and


8/47



Chapter 1 - Page 5

web conference), iLearning displays the offering Start Date and for asynchronousonline and offline (e-learning and self-study), iLearning displays the Enrollments Date.

Note that the Start Date column is available in the PC version of iLearning and not thesimpler version on mobile devices.

New icons are added to the left of the headings on the different pages under the Hometab.

Select the number of items to view on Learner Pages:Learners can now select how many items are shown on the different pages under theHome tab (except the History page). This feature is available in both the mobile deviceand PC versions of iLearning.

New "Resume Last" button:Learners can click the new Resume Last button on the Overview page, which willtake learners to the last course that they played in the Player. If the content providesthe necessary information, then iLearning displays the exact location in the chapter thatlearners had left earlier. If this information is not provided by the content, then learnersare taken to the beginning of the chapter that they had left. This functionality isavailable both in the full and the simple interface of iLearning.

Transcript sub tab moved and renamed:The Transcript sub menu available from the Profile tab is now moved to the Home taband renamed to History.

Change in the Learner name format:In all the Learner pages, a learner's name will be displayed in the format FirstNameLastName.

Save Learner preferences:On the Overview page the settings/values of the following will be saved during asession:

Text in the Filter field

Setting of Include Completed Offerings checkbox

Sort order on the My Learning tableOn all pages under the Home tab the setting of Items Per Page will be savedacross pages.

Search field on all Learner pages:From this release, all the Learner sub tab pages will include a search field. TheSearch field is added to the Learner pages that do not have it currently.

Combined the Player and Enroll Status columns:iLearning now combines the Player and Enroll status columns on the Learner Overviewpage. The new Status column will display the combined content of the two oldcolumns with the content of the old Enrollment Status in line 1 and the content of theold Player in line 2.

Removed line and hyperlinks from the bottom of the Learner pages:From this release, iLearning will no longer display the lines and hyperlinks on the verybottom of all the Learner pages.

Back button added on Learner pages:In this release, a Back button is added to the following Learner pages:

Learning Path detail page

Integrated Learning detail page


9/47



Chapter 1 - Page 6

Offering detail page

RCO detail page

Browse subcategory page

Learner picture displayed on a Forum posting:iLearning displays a small version of the Learner picture on a forum posting. Thepicture is displayed in the Author column in the Topics list.

Add and View Course Pictures

iLearning administrators can now add pictures to Content Objects, Learning Paths, andIntegrated Learning. This picture will be visible to the learner on the home page, whenviewing the Details page, and when searching and browsing new training.

The site administrator can upload, view, and delete these pictures using the Propertiespages for the different objects.

The pictures that administrators can upload must not be bigger than 1 MB. The supportedformats are: JPG, GIF and PNG.

If no picture is uploaded for an object, then no picture is displayed.

Learners can Upload Additional ContentLearners can add content to the offering they are enrolled in. This content will then beavailable to all other Learners enrolled in the same Offering.

The Offering Details page displays a new Upload Content table, where learners can viewcontent uploaded by themselves or by their peers. The content can either be a URLpointing to the material or it can be a piece of content uploaded to iLearning.

When the Learner clicks the content hyperlink, the content will open up in a separatewindow using a program based on the preferences set in the learners PC. The UploadContent table contains a short description of the content, name of the learner who hasuploaded it, the date it was uploaded and an Edit icon for the topic if the Learner hasuploaded the content. When learners click the Upload button, the Upload Content pageappears for learners to upload a document or add a URL.

Note: The content that learners upload will not be visible on the Mobile or Simple Interface.

Approval is not required from the learning administrator to upload content. Theadministrator or instructor can view and delete the uploaded content from the administratorinterface.

Administrators can control the ability of learners to upload content using the 'Learnerscan upload content' option available on the Manage Site Features page for a site. If theenabled option is selected, then learners can upload content. Otherwise, learners cannotupload content

Access Social Media from the Learner Page

When viewing enrolled learners for an offering, learners can contact other enrolled learners

through the social media link drop-down available on a learner's picture. Learners can clickany social contact media link and try to contact the enrolled learner. When a learner selectsa social media link, depending on the setting defined by the site administrator, the socialmedia site will automatically open or the learner will be informed of the other persons user-id for the site and asked to open the site manually.

The site administrator can define the types of social media contacts that will be available forlearners. Using the new User Contact Media page, an administrator can define new contactmedia by entering name and URL.


10/47



Chapter 1 - Page 7

Always show Outline at Start up and Disable Outline collapse in Player

In the Offerings, Properties page, Player Preferences section, the following two checkboxes have been added:

Always Show Outline: If this box is checked, then iLearning displays the Outline inthe player at start up whether or not it was shown when the Course was played thelast time.

Always Show Outline Expanded: If this box is checked, then it is not possible for theLearner to collapse the outline.

Tech Stack Changes in Release 6.1

There are no tech stack changes between iLearning Release 6.0 and 6.1. Release 6.1 iscertified on the following tech stack:

Oracle iAS 10.1.3

Oracle Database 11gR2

Note: You do not have to change your tech stack if you are upgrading from 5.2.1, since5.2.1 is on Oracle iAS 10.1.3. You can keep your same database version. You do not haveto upgrade to 11.2.

Fresh Install of Oracle iLearning 6.1

New customers can directly install Oracle iLearning Release 6.1. If you are directly installingOracle iLearning Release 6.1, ensure that you install the following tech stack components:

Oracle iAS 10.1.3

Oracle Database 11.2 (11g)

Oracle Portal 10.1.4

Note: Installing Oracle Portal 10.1.4 is optional. Install it if you want to run the Portal.

Upgrade to Oracle iLearning 6.1Customers on Oracle iLearning on 6.0 can directly upgrade to Oracle iLearning 6.1.

Note: If customers are on a release previous to 6.0, then they must upgrade to 6.0 firstbefore upgrading to 6.1.


11/47


Oracle iLearning 6.1 Release Information

Chapter 1 - Page 8



This topic describes the following release specific information:

Software certification

Release notes

Available languages

Changing the iLearning schema password

Linux specific release details

Software Certification

Oracle iLearning 6.1 is certified with the following product stack:

UNIX operating system

Oracle Solaris on SPARC (64-bit)

HP-UX PA-RISC (64-bit)

Linux x86

Red Hat Enterprise Server 4,5

Oracle Enterprise Linux 4,5

SUSE SLES10

SUSE SLES11

IBM AIX on POWER Systems (64-bit)

Windows operating system

Microsoft Windows (32-bit)

MS Windows XP

MS Windows Server 2003

MS Windows Server 2003 R2

MS Windows Server 2008

MS Windows Vista

Oracle Application Server 10gR3 (10.1.3)

Oracle Enterprise Edition RDBMS Release 11.2, with the following configurationoptions:

Oracle Intermedia

UTF-8 Database character set

Oracle Portal 10.1.3 or higher

Oracle iLearning is certified on the following client software:

Web Browsers:

IE 9, IE 10

Firefox 17.0.1

Safari 5.0.5. Safari 5.1.7 is certified for all features except the Chat applet.

The iLearning Chat client requires the latest version of the 1.6 or 1.7 Java plug-in.


12/47



Chapter 1 - Page 9

Note: For the latest certification information and patch sets, please visit My Oracle Support(formerly MetaLink).

Release Notes

The following information pertains to the release of Oracle iLearning:

If you plan to configure multiple Oracle iLearning middle tier application servers, anOracle Application Server 10gR3 cluster configuration using Oracle AS infrastructure isoptional. If an Oracle Application Server cluster using Application Server Infrastructureis used, then the cluster of oc4j instances must be set up prior to an Oracle iLearninginstallation. Detailed configuration for this setup is beyond the scope of this document.Please refer to the Oracle Application Server 10gR3 documentation for creating andmanaging an AS cluster.

If you have problems with your installation, please refer to the Troubleshooting section.

When installing Oracle Application Server 10gR3, you should consider the following

The operating system username used to install Oracle Application Server 10gR3must be the same username used to install Oracle iLearning.

If Web Cache is installed, make sure all URLs starting with /ilearn are exempted

from caching. Oracle iLearning application pages are personalized for individualusers and should not be cached.

Oracle iLearning uses dynamic jsp pages to display relevant information to the loggedin user. Oracle has made every effort to prevent caching, but it is recommended thatproxy server caching of Oracle iLearning pages be disabled (if applicable) to ensuredata between user sessions does not get mixed.

Oracle recommends installing Oracle Portal on a separate machine, not on an OracleiLearning middle tier application server. Otherwise, you may encounter conflictsbetween Portal and Oracle iLearning common files.

When using an Oracle11g database:

If the middle tier application servers are unable to communicate with the database,

you may need to update the JDBC driver on all Oracle iLearning middle tierapplication servers. Oracle iLearning uses the database drivers located under

.

After a successful installation and configuration of Oracle iLearning, you should be ableto access the application using a browser by performing the following steps:

Enter into your browser the URL that you chose as the Oracle iLearning WebsiteAddress during the Oracle iLearning installation.

For example, http://ilearning.mycompany.com:7777

The default login page for Oracle iLearning will be displayed. Log in to OracleiLearning as the Root Site super administrator:

Username: system

Password:manager

Site: Root Site

Note: The site field in the login page will show up only if you have more than one site.

The values for Usernameand Passwordare case-sensitive, but the value for Site is

not.

Please refer to the Available Language Translations section below to review thedifferent language translations available for Oracle iLearning


13/47



Chapter 1 - Page 10

ORACLE_HOME refers to the location of the Oracle Home where Oracle iLearning will

be installed

AS_HOME refers to the location where the Oracle Application Server is already

installed

There is only one role configured during the installation, called SuperUser, unless theOracle iLearning Demo Site is installed

All Oracle iLearning middle tier installations should be performed on a dedicated server(not shared with other applications)

You must create a new Oracle database specifically for an Oracle iLearning databaseinstallation. Do not use a database that is currently being shared with otherapplications

In Oracle iLearning installations where multi-byte languages are used, you will require

additional fonts. These are located on the Oracle iLearning CD under the Support

directory. Copy all .ttffiles in this directory to the

/jdk/jre/lib/fonts directory on all middle tier application servers. If

these fonts are not installed, buttons in multi-byte languages such as TraditionalChinese, Korean, and Japanese will not appear correctly.

Available Language Translations

Oracle iLearning is available in the following languages. The language displayed in OracleiLearning is dependent on the user's browser settings. For the most up-to-date list oflanguages, please refer to My Oracle Support (formerly MetaLink).

Language Name

Language Code

Brazilian Portuguese pt_br

Chinese (Simplified) zh_tw

Chinese (Traditional) zh_cn

Czech cs

Danish da

Dutch nl

English en

Finnish fi

French fr

German de

Hungarian hu

Italian it

Japanese ja

Korean

ko

Norwegian no

Polish pl

Spanish es

Swedish sv

Turkish tr


14/47



Chapter 1 - Page 11

There are no configuration steps required to make these languages available to users. Basedon the users' language settings in their browser, the corresponding language in OracleiLearning will be displayed.

Changing the Oracle iLearning Schema Password

You can change the passwords for the Oracle iLearning Schema Name and Oracle iLearningSchema Report Name at any time. For example, you might require passwords to be changed

every three months for security reasons.

Passwords are encrypted. You have to use /ilearn/en/shared/jsp/encrypt.jsp tofind the new encrypted password.

Update the ilearning.properties file (located in the

/j2ee/oil/applications/ilearning/ilearn/WEB-INFdirectory)

on all middle tier application servers with the new passwords:

Modify the following entry to change the Oracle iLearning Schema Name password:administrator.connectString=jdbc:oracle:thin:/@::

Modify the following entry to change the Oracle iLearning Schema Report Namepassword:reporting.connectString=jdbc:oracle:thin:/@::

Modify the following entry to change the Web Services connection to the OracleiLearning Schema Name password:webservices_pool.connectString=jdbc:oracle:thin:/@::

Optional: If Oracle Portal is configured for Oracle iLearning, modify the entry for the

Oracle iLearning Schema Name in the data-sources.xmlfile (located in the

/j2ee/oil/config directory)

Restart the Oracle Application Server on all middle tiers for these changes to takeeffect. For more information on starting and stopping this server, refer to the Oracle

Application Server 10gR3 documentation.

LINUX Specific Release Notes

In SUSE9, install patch 3809117 if it is not installed already. Set the following environmentvariables before starting any Oracle Application Server processes:

$ LD_PRELOAD=/usr/lib/libInternalSymbols.so; export LD_PRELOAD

$ LD_ASSUME_KERNEL=2.4.21;export LD_ASSUME_KERNEL


15/47


Upgrade to Oracle iLearning Release 6.1 from Release 6.0

Chapter 1 - Page 12


These instructions cover the steps necessary to complete the pre-upgrade and upgrade steps ifyou want to upgrade to Oracle iLearning Release 6.1 from Oracle iLearning Release 6.0.

You must be on 6.0 to upgrade to 6.1. For upgrades, 6.1 is installed as a patch, ratherthan redeploying an .ear file.

It is a best practice to create a test environment similar to your production and perform theupgrade against the test environment first.

Make sure that the upgrade has completed successfully before attempting to upgradethe production environment.

You may want to document all the prerequisites like total time required to upgrade,resource requirements, and other technical issues specific to your environment/site.This information will help you to fine tune the resource requirements and minimize thedown-time of your production server during the upgrade process.

Perform Pre-Upgrade Steps

1. Shut down the Oracle iLearning middle tier servers and database.

2. Take a full backup of:

Entire existing Oracle iLearning installation including the database and all the middlertier servers before starting the upgrade process.

Any customized JSPs. These files may get overwritten when the patch is installed.

The backup should be taken in such a way that you should be able to restore it in case theOracle iLearning 6.1 upgrade process fails. Once the database portion of the patch has beenapplied or has failed, it cannot be reverted.

Prepare to Upgrade to Oracle iLearning 6.1

Before applying this patch, please make sure the iAS 10.1.3 web server is shutdown:

3. Unzip the file iLearning 6.1 installation zip file (OIL_17325195.zip). Note the directory

where the installation file was unzipped.4. Verify database base backups are taken.

Perform the Middle Tier Application Upgrade

Note: You must complete the following steps on each Oracle iLearning middle tier applicationserver.

Back up the 6.0 Release Files

5. Backup the following directories:

/j2ee/oil/applications/ilearning/ilearn/en

/j2ee/oil/applications/ilearning/ilearn/lmsapi

/j2ee/oil/applications/ilearning/ilearn/WEB-INF/lib/classes

6. Backup the following files if they exist:

/j2ee/oil/applications/ilearning/ilearn/lms6.0.0.0.jar



/j2ee/oil/applications/ilearning/ilearn/WEB-INF/lib/css.jar


16/47



Chapter 1 - Page 13

Apply the Middle Tier Patch

7. Copy files and the directory structure in:

"OIL_17325195/Software/upgrade_from_6.0/ilearn"

into

/j2ee/oil/applications/ilearning/ilearn

possibly overwriting the files in steps 5 and 6.

This step copies classes, JSP's, HTML and .jar files.

8. Clear your JSP cache under:

/j2ee/oil/application-deployments/ilearning/ilearn/persistence/_pages/

Configure ilearning.properties

There is a new property that controls whether SCORM content played from the middle tiershould use the new Javascript or the old applet player communication. This includes playingiLearning assessments and surveys.

Skip steps 9 & 10 if you've already installed the 6.0 patch for bug 14075342. (Javascript Player),If you're not sure if you installed this patch, start sql*plus as the the ilearn database user and

describe the ATTEMPT table.SQL> desc attempt

If the column ATTEMPT_TOKEN exists, the patch is already installed.

9. Add the following lines to the ilearning.properties file:

#******************************************************************************

# LMS_COMMUNICATION - By default, the player's communication with the LMS

# server uses javascript. Uncomment this line if you want to use the legacy

# player applet instead of javascript. This setting is for the middle tier

# player only. If using a CMI Adapter, choose an adapter path to either

# Oracle_CMI_Adapter (applet) or lmsapi (javascript).

# The default value is javascript.

#******************************************************************************

#LMS_COMMUNICATION=applet

Apply the Database Patch

This patch includes a database script that adds tables, add columns to tables, rebuildsdatabase views and packages, and adds or rebuilds indexes.

10. Run the Javascript Player Patch script as the ilearn user. Skip this step if you alreadyinstalled the 6.0 patch for bug 14075342 (Javascript Player). This script adds a column tothe ATTEMPT table and populates the column, adds 2 triggers, and builds 5 indexes. Thiscan be a long running script if you have a large ATTEMPT table. The script updates in

200,000 row intervals, commiting after each interval.

Start sql*plus from the "OIL_17325195/Software/upgrade_from_6.0/sql" directory as the ilearndatabase user and run 14075342.sql. Provide the ilearn schema index tablespace as aparameter.

SQL> @14075342.sql ilearn_index

Check the 14075342_install.out file for errors. You may see object already exist errors if youhave previously installed 6.0 patches.


17/47



Chapter 1 - Page 14

11. Run the script that creates tables and indexes for new 6.1 features.

Start sql*plus from the "OIL_17325195/Software/upgrade_from_6.0/sql" directory as theilearn database user and run ilearn.sql.

Provide the reporting schema user and ilearn schema index tablespace as parameters.

SQL> @ilearn.sql ilearnrpt ilearn_index

Check the ilearn_upgrade_61.out file for errors. You may see object already exist errors if

you've previously installed 6.0 patches.12. Run the custom reporting upgrade script.

Start sql*plus from the "OIL_17325195/Software/upgrade_from_6.0/sql" directory as theilearn_rpt database user and run ilearn_rpt.sql.

Provide the ilearn schema user as a parameter.

SQL> @ilearn_rpt.sql ilearn

Apply the Content Server Patch

This patch contains a new CMI Adapter and a Javascript Player Adapter that was originallyintroduced in the 6.0 patch 14075342 - Javascript Player. You should skip steps 14, 15 and 16 ifyou already installed the 6.0 patch.

The new Javascript CMI Adapter uses a JSP to communicate back to iLearning. In order to usethe new Javascript CMI adapter, the content server must be an Application Server that supportsJSPs.

On each content server,

13. Copy or FTP the whole OIL_17325195/Software/content_server/lmsapi directory to thecontent server under a directory that supports JSPs.

(ie. /j2ee/oil/applications/ilearning/ilearn

or /j2ee/home/default-web-app).

This new directory should be accessible by a web browser. Make a note of the URL. Youwill need it when creating a CMI Adapter in the iLearning Admin pages.

14. Back up the following file in the Oracle_CMI_Adapter directory:

Oracle_CMI_Adapter/version.js

15. Copy or FTP the files in OIL_17325195/Software/content_server/Oracle_CMI_Adapter tothe Oracle_CMI_Adapter directory on the content server, overwriting the existing files.

Perform iLearning System Admin Configuration

The CMI Adapters defined in the iLearning Admin Pages determine whether the content on thecontent server will use the new Javascript or the old applet player. They are currentlyconfigured to use the iLearning Player Java applet.

Skip this step if you already installed the 6.0 Javascript Player patch.

For each site,

16. Edit the CMI Adapters from the Site -> More... menu. Change the CMI Adapter Path topoint to the new lmsapi directory copied to the content server.

ie, change

http://ilearning.mycompany.com/ilearn/content_server/Oracle_CMI_Adapter/

to

http://ilearning.mycompany.com/ilearn/lmsapi/ orhttp://ilearning.mycompany.com/j2ee/lmsapi/


18/47


19/47


New Installation of iLearning 6.1

Chapter 1 - Page 16


These instructions cover the steps necessary to complete the pre-install and install steps if youwant to install Oracle iLearning 6.1.

Install Oracle iAS 10.1.3

1. You must install iAS 10.1.3 if this is a new install of Oracle iLearning 6.1.

2. Unzip the file iLearning 6.1 installation zip file (OIL_17325195.zip). Note the directorywhere the installation file was unzipped.

Perform Pre-Install Steps

3. Start the OEM server.

4. After iAS 10.1.3 is installed, log onto Enterprise Manager.

5. Create OC4J instance oil in the default_group.


20/47



Chapter 1 - Page 17


21/47



Chapter 1 - Page 18


22/47


23/47



Chapter 1 - Page 20

7. Select the Applications tab.

8. Select the ilearning applications check box and press the Deploy button.

9. Provide the location of the ilearning.ear file unzipped from the installation directory

(OIL_17325195) and press the next button.


24/47



Chapter 1 - Page 21

10. Leave all fields unchanged and press the Next button.

11. Press the Deploy button.


25/47



Chapter 1 - Page 22

Complete the Middle Tier Application Install

Note: You must complete the following steps on each Oracle iLearning middle tier applicationserver.

Configure iAS

12. Configure a Data Source in the 10g Release 3 (10.1.3) Instance. Add the following in/j2ee/oil/config/data-sources.xml

for example

13. Edit /j2ee/oil/config/server.xml. Replace the following lines in two places.

Change:

To:

Note:

may either be a physical or relative path to the ORACLE_HOME for iAS.

When you copy and paste from Adobe Acrobat Reader, sometimes the '-' character islost. The pasted value ends up as WEBINF instead of WEB-INF.

14. Edit /j2ee/oil/config/application.xml. Add the following lines right under


26/47


27/47



Chapter 1 - Page 24

15. Make the following changes to /opmn/conf/opmn.xml:

a. Add the following parameters to


28/47



Chapter 1 - Page 25

Unzip

/j2ee/oil/applications/ilearning/ilearn/WEB-INF/lib/iAS/uix2-install.zip

into

/j2ee/oil/applications/ilearning/ilearn.

This should create a cabo directory. When you unzip the UIX files, you will be promptedthat a file already exists. Choose n (no) to replace the existing file.

18. For a new install, back up the ilearning.properties file in/j2ee/oil/applications/ilearning/ilearn/WEB-INF.

Edit the ilearning.properties file

19. Edit the following properties in the ilearning.properties file.

Hosting Companys Domain

The domain specifies the network domain where all middle tier servers and your web siteare located. If you are running Oracle iLearning internally, your company network domainshould suffice. If you are hosting Oracle iLearning through an ISP, you may need to obtainthis value from your network administrator. All middle tier application servers should have

the same value.HOST=http://localhost

DOMAIN=.oracle.com

Outgoing SMTP Mail Server Name

Oracle iLearning uses mail servers for email notifications. To enable these features, youneed to provide the address of your company's SMTP mail server. All middle tierapplication servers should have the same value.

MAIL_HOST=mail.host.com

Administrator Email Address

Email notifications generated by Oracle iLearning are sent by default from the administratoremail address entered during installation. A valid email address is required. Administratorsof Oracle iLearning sites can override this value in the administrative user interface. Allmiddle tier application servers should have the same value.

[email protected]

CONTENT EXPORT/IMPORT SETUP

Recommendation: Change only ftpuser and ftpgroup to correct values.

Default setting: listed below, defaults for ftpuser and ftpgroup must be changed.

Required properties for iLearning export and content servers functionality.

Requires a ftp server running with any correct user and password settings totransfer files

ftpuser

ftppassword

ftpuser and ftppassword


29/47



Chapter 1 - Page 26

This is an FTP user that should be set up on the FTP Server on your content servermachine. This user should have permissions on the content server directory to transfercontent 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

Note: The ftpuser and password must be the same on all middle tiers and content servers.

Log Path

Directory for logging error messages during import and other operations

LOG_PATH=d:/apacheg/apache/logs

imsdtd=http://localhost:port/ilearn/en/admin/dtd/content.dtd

classroom_dtd=http://localhost:port/ilearn/en/admin/dtd/classroom.dtd

performance_dtd=http://localhost:port/ilearn/en/admin/dtd/performance.dtd

Oracle iLearning Protocol

Oracle iLearning supports the delivery of application pages using either the HTTP orHTTPS protocol. Select the available protocol on your Oracle iLearning application.Alternatively, select Use Both HTTP and HTTPS if you want to enable the OracleiLearning site administrators to select the protocol to be used for each site.

Encryption Key

Enter an encryption key which will be to generate a security key for encryption. The keyshould be an integer. This same value should be used as the seed for all installations ofmiddle tiers sharing this instance of Oracle iLearning.

ENCRYPTION_KEY=1b8201bae87b574b1999c17e1eaccb4c840ff9bd82c547ff813b6ef1abc788f5

Note that when the ENCRYPTION_KEY is changed, you have to change the encryptedpasswords in the connect strings. The ENCRYPTION_KEY must be the same on all middletiers and content servers.

WF_MAIL_MODE

Email notifications are sent by iLearning. System administrator can use theWF_MAIL_MODE property to configure whether a notification/approval request is sentimmediately, or queued and sent by the notification batch job. As email connections can beslow, it is up to the customers whether they want the UI to wait for the email to be sent.iLearning recommends that customers start out sending mail in batch mode. To send mailin batch mode, you must schedule a batch job.

#******************************************************************************


30/47



Chapter 1 - Page 27

# Approval notification emails can be sent immediatelyafter the approval, or

# can be send through the Notification batch job. Bydefault, they will be sent

# immediately. Uncomment the this line if you want to sendthe emails through

# the batch job.

#******************************************************************************

#WF_MAIL_MODE=batch

Refer to the topic: Scheduling and Running Batch Jobs

20. Save the changes to the ilearning.properties file.

21. Stop and start the OPMN server to pick up the new ilearning.properties.

22. Copy /j2ee/oil/applications/ilearning/ilearn/index.html to/Apache/Apache/htdocs. This redirects the browser to the login page if theuser only types the server name.

Complete the New Install Database Steps

This section covers the steps necessary to install Oracle iLearning 6.1. You must run 3 scripts,one as the sys db user, one as ilearn, and one as ilearnrpt. You do not provide connect stringsto the script.

23. Start up the Oracle iLearning database and listener on the database server.

24. Launch sqlplus from OIL_17325195/Software/database/sql

25. Connect as sys and run the sys script.

26. Run the following script as sys db user. This script takes in six parameters.

ilearning user

ilearning user password reporting user

reporting user password

default user tablespace name

temporary tablespace name

SQL> connect sys as sysdba

Enter password:

Connected.

SQL> @sys/sys_install.sql ilearn welcome ilearnrpt welcomeuserts tempts

27. Run the following script as the ilearn user. This script takes in one parameter, the indextablespace name.

SQL> connect ilearn/welcome

Connected.

SQL> @ilearn_install.sql indexts

28. Run the following script as the ilearning reporting user. This script does not take in anyparameters.


31/47



Chapter 1 - Page 28

SQL> connect ilearnrpt/welcome

Connected.

SQL> @adhoc/ilearnrpt_install.sql

Complete the Database Connection Steps

The connect strings in ilearning.properties encrypt the database password using the

encryption key. The system administrator must configure ilearning.properties without thedatabase passwords and start iLearning. iLearning provides a page encrypt.jsp(/ilearn/en/shared/jsp/encrypt.jsp) to show the administrator the encrypted passwords thatmust be used for the connect strings. The administrator must change the connect stringspasswords in ilearning.properties and bounce iAS.

Example of connect strings (note the passwords are encrypted):

administrator.connectString=jdbc:oracle:thin:ilearn/hO/55i@localhost:1521:ORCL

reporting.connectString=jdbc:oracle:thin:ilearnrpt/kudtHVL2J$$@localhost:1521:ORCL

webservices_pool.connectString=jdbc:oracle:thin:ilearn/hO/55@localhost:1521:ORCL

Configure the Content Server

For a new install, only the Javascript CMI adapter should be installed. This is the lmsapidirectory. The Oracle_CMI_Adapter directory is not used for a new install.

29. Copy or FTP the whole OIL_17325195/Software/content_server/lmsapi directory to thecontent server under a directory that supports JSPs.

(ie. /j2ee/oil/applications/ilearning/ilearn

or /j2ee/home/default-web-app).

This new directory should be accessible by a web browser. Make a note ofthe URL. You

will need it when creating a CMI Adapter in the iLearningAdmin pages.

Configure Apache for the Gatekeeper

30. The gatekeeper configuration is required on all content servers. It is required only on the

middle tier if it is also going to be a content server.For information on gatekeeperconfiguration, refer to the steps in the Oracle iLearning ContentServer and Oracle CMI Adaptertopic.

Start the Middle Tier after Patch Application

31. Start the OPMN server.

32. Start the OEM server.


32/47


33/47


Oracle iLearning Content Server and Oracle CMI Adapter

Chapter 1 - Page 30

Note: This document only describes the setup of a content directory under the

/Apache/Apache/htdocs/ directory. For example:/Apache/Apache/htdocs/ilearning/content_server

8. Copy the Gatekeeper module file from the

OIL_17325195/Software/content_server/gatekeeper directory into the

appropriate directory on each content server machine.

For Windows: Copy theApacheModuleAuthIla.dll module to the/Apache/Apache/modules directory.

For UNIX and Linux: Copy the mod_auth_ila.somodule to the

/Apache/Apache/libexecdirectory.

9. Add the required lines to the Oracle Application Server 10gR3 configuration file on eachcontent server machine.

The configuration file is located at:/Apache/Apache/conf/httpd.conf

The HOSTand LISTENport 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 willreceive a Forbidden error message when attempting to access content on an OracleiLearning secured content server even if they are authorized to view the content.

Note: You must understand Oracle Application Server 10gR3 administration andcluster management before performing any of the following changes. Please refer tothe Oracle Internet Application Server documentation for detailed information.

The following line starts the Gatekeeper every time Oracle Application Server 10gR3 isstarted. This should go in the section labeled Dynamic Shared Object (DSO) Support:

For Windows: LoadModule ila_auth_modulemodules/ApacheModuleAuthIla.dll

For UNIX and Linux: LoadModule ila_auth_modulelibexec/mod_auth_ila.so

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

AddModule mod_auth_ila.c

Add anAlias for the Oracle Application Server 10gR3 of your physical directory to

locate the stored content. This should go in the section labeled Aliases underIfModule mod_alias.c:

Alias //

"/Apache/Apache/htdocs//"Use the information below to help define the base directory where all content used byOracle iLearning will be stored:

Determine where the content will be stored.

Note: This document only describes the setup of a content directory under the

/Apache/Apache/htdocs/ directory. For example:


34/47



Chapter 1 - Page 31

/Apache/Apache/htdocs/ilearning/content_server

Alternatively, you could establish UNIX soft links to any other directory from thislocation.

Any name can be used for the directory.

The and values are required when setting up content servers within theOracle iLearning application

For example, to store content in the/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.

AuthType iLearningrequire valid-useriLearningAuth oniLearningAuthKey ErrorDocument 403 http://

Use the information below to help configure this line:

This command protects all content under ,

except streaming media audio files which must be exempted from the securedlocation (.wma).

For example, to prevent unauthorized access to content under the/Apache/Apache/htdocs/ilearning/content_server/sec

ure directory, you would specify the following

AuthType iLearningrequire valid-useriLearningAuth oniLearningAuthKey

1b8201bae87b574b1999c17e1eaccb4c840ff9bd82c547ff813b6ef1abc788f5

ErrorDocument 403 http://

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


35/47


36/47



Chapter 1 - Page 33

The FTP username must be the same operating system username used forinstalling Oracle Application Server 10gR3 and Oracle iLearning. The sameoperating system user should be used during the installation of both OracleApplication Server 10gR3 and Oracle iLearning, regardless of whether they arebeing installed in the same or different Oracle Homes.

The same username and password mustbe 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 canonly succeed if the owner of the Oracle Application Server 10gR3 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 andthe content servers.

Oracle iLearning does not use the FTP protocol to upload files from the usersbrowser. The compressed ZIP files are transferred from the browser to the OracleiLearning application servers using the standard HTTP protocol and then aretransferred from the Oracle iLearning application server to the content server usingthe FTP protocol.

For each alias created in yourhttpd.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 OracleiLearning content will be stored. For example, if the following directories werecreated:

/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 andpassword you just created. If you are unsuccessful, stop and restart the FTP serverand 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) andinstall another FTP server

Configure the Windows 2003 FTP server. The following steps may assist yourconfiguration:

From Start Menu->Administrative Tools, launch Start InternetServices Manager


37/47



Chapter 1 - Page 34

Select the name of the machine in the tree and create a new FTP site using thewizard. 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 mustbe the same user that

will be specified as the FTP user in theilearning.properties file. You

will enter this in step 11.

Enter the password for the user. This mustbe the same password that has

will be specified as the FTP user in theilearning.properties file. You

will enter this in step 11

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

An alias that will be used to access the Oracle content server directory. Thismust 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 thehttpd.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 thedirectory

Edit the properties for the windows directory that you specified as your physicalcontent server location.

Select the Security tab

Add the username that you created in the FTP server setup

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

servers.

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

The ilearning.properties file is located in

/j2ee/oil/applications/ilearning/ilearn/WEB-INF directory.

Edit this file to provide the correct values for theftpuser andftppassword. This

is an FTP user that should be set up on the FTP Server on your content servermachine. 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 ilearnftpwas created on the content server

machine with password ilearn_transfer, the following values could be used:ftpuser=ilearnftpftppassword=ilearn_transfer


38/47



Chapter 1 - Page 35

The following modes are available in the ilearning.propertiesfile:

FTP_MODE Indicates the mode of FTP.

By default, this is set to 1, which indicates the convention FTP mode.

FTP_MODE = 2 Indicates a secure FTP mode. This is SSH based secure FTP.

FTP_MODE = 3 Indicates that this can be configured for each content server that

is set up. If this is set to 3, a checkbox Use Secure FTPwill be present on the content

server setup page.

Specify the ports for normal/secure FTP (there is no site property for this).

FTP_PORT Conventional FTP port (default 21)

SSH_PORT Secure FTP port (default 22)

12. Save the configuration file.

13. Update the Oracle Application Server 10gR3 repository

This must be performed on the content server machine and all middle tier applicationservers for the above changes to take effect.

Please refer to the Oracle Application Server 10gR3 documentation for detailedinformation on updating the repository.

14. Stop the Oracle Application Server 10gR3 daemon on each content server machine andevery Oracle iLearning Middle Tier application server machine.

Please refer to the Oracle Application Server 10gR3 documentation for detailedinformation on starting and stopping this server.

15. Start the Oracle Application Server 10gR3 daemon on each content server machine andevery Oracle iLearning Middle Tier application server machine.

Please refer to the Oracle Application Server 10gR3 documentation for detailedinformation 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 10gR3 documentation for detailedinformation 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

These steps define which sites will have access to this content server.

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

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

20. Select the site that should have access to the content server, for example, the Root Site orSite1.

21. Click the More...tab.

22. Choose Content Servers.

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

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

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


39/47



Chapter 1 - Page 36

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 thehttpd.conf file on the web server. Please ensure to coordinate these efforts with your

Oracle iLearning DBA.

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

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

If you plan to use SCORM-based content, stop and complete Sett ing Up th e Oracle CMIAdapter .Otherwise, go to task #28.

28. Use the Upload Filesoption in Oracle iLearning to transfer their content to the contentserver.

When their content resides on an Oracle iLearning content server, content developersshould always choose the iLearning Secured option when specifying the ContentLocation for a content object.

Setting Up the Oracle CMI Adapter

iLearning 6.1 uses a Javascript based CMI Adapter. This replaced the applet based CMIAdapter that required the Java Plug-in. If you are upgrading to 6.1 and you have alreadyinstalled the 6.0 patch for bug 14075342 (Javascript Player), you have already set up the CMIAdapter and you can skip this section. Otherwise, you must install the new CMI adapter on allcontent servers.

This section covers the tasks necessary to set up the Oracle CMI Adapter on content servers tofacilitate communication between SCORM compliant content and Oracle iLearning 6.1. Thisdocument covers communication between iLearning 6.1 and both SCORM 1.2 and 2004content. These tasks are performed whenever a content server will contain SCORM 2004

compliant content that needs to communicate information back to Oracle iLearning 6.1.

Overview

The Oracle CMI Adapter allows for interoperability between SCORM-based web content andOracle iLearning. The following steps are required to install the Oracle CMI Adapter:

During your upgrade or new install of Oracle iLearning 6.1, the lmsapi directory is created in theOIL_17325195/Software/content_server directory on the middle tier where you unzipped theOIL_17325195.zip file. The files are required for CMI communication.

If the content server has iLearning 6.1 installed, the CMI Adapter files are already installed andyou can skip the copy adapter files step. If not, you must copy or ftp the lmsapi directory to adirectory on the content server that supports JSPs.

(ie. /j2ee/home/default-web-app)29. Log in to Oracle iLearning as an Administrator.

30. Click the Adminicon.

31. Under the Contenttab, click your site name.

32. Click the Morelink in the right-hand pane

33. Click CMI Adapters.

34. Click Add CMI Adapter.


40/47



Chapter 1 - Page 37

35. Enter the appropriate values.

There are two fields you must complete:

Content URL Starts With

CMI Adapter Path

For example:

Content URL Starts With: http://myilearning.oracle.com/content_server/scorm_content

CMI Adapter Path: http://myilearning.oracle.com/ilearn/lmsapi/

or: http://myilearning.oracle.com/j2ee/lmsapi/

36. Click Save.

Content objects created in Oracle iLearning that have the tracking type set to SCORM 1.2 or

SCORM 2004and whose Starting URL matches the value set in Step 8 will automatically have

the CMI Adapter URL prepended to the starting URL when the content is launched, to ensureSCORM 1.2 or SCORM 2004 CMI communication will take place successfully.


41/47


Scheduling and Running Batch Jobs

Chapter 1 - Page 38

Scheduling and Running Batch Jobs

This topic explains how to schedule and run batch jobs.

Oracle iLearning provides the following batch jobs that send notifications:

certification_notification - sends emails about expiring certifications

queued_notification - sends emails about enrollments and approvals. This job sendsthe emails that are queued from using WF_MAIL_MODE=batch

Batch Jobs are in OIL_17325195/Software/batchjobs. They rely on an environment variableAS_HOME.

You can run these two batch jobs for a specific site by using the -site parameter in thecommand line. The default action is to run the job for all sites. If you want the job to run for allsites, then do not specify the parameter.

%as_home%/jdk/bin/java -mx100M -ms64M -Djbo.pers.max.active.nodes=-1 -Dilearning.home=%as_home%/j2ee/oil/applications/ilearning/ilearnoracle.ila.common.util.notif.model.QueuedNotificationJob -l%LOG_DIR% -site "Root Site"


42/47


Troubleshooting Oracle iLearning 6.1

Chapter 1 - Page 39


This section provides some answers to some problems or questions that have beenencountered during the installation process:

General Installation Notes

Oracle 11g Database

Ensure the installed database is patched up to the certified version (11.2) with allspecific OS patches applied.

Oracle Application Server 10gR3 (10.1.3)

Ensure Web Cache is either not installed or is turned off

If installed, shut off ports for Oracle iLearning, change the httpd.conf file so

portand listendirectives are identical

Ensure all OS specific patches are applied prior to installation

Issue: The Oracle iLearning Installer is requesting aUSERS orTEMP tablespace. I

am performing an upgrade, and my previous release of Oracle iLearning is located in adifferent tablespace. I don't have these tablespaces in my database currently.

Resolution: The Oracle iLearning installer always validates the existence of the

USERS andTEMP tablespaces during an upgrade only. To solve this problem, you

can create the tablespaces in your database by performing the following commands:SQL> connect system/SQL> create tablespace USERS datafile '/users.dbf' size 1M;SQL> create tablespace TEMP datafile '/temp.dbf' size 1M;

After the upgrade has successfully completed , the tablespaces you created above canbe removed. However, first ensure you are not using these tablespaces for any otherpurpose.

Issue: When the Oracle iLearning Login page appears, there is no Site field.

Resolution: There are three possible causes.

Only the Root site exists. This is the expected behavior.

The Oracle iLearning middle tiers cannot communicate with the database.

Ensure the Database is up and running

Ensure the Oracle iLearning schema name and password are the same as listed

in the ilearning.propertiesfile

The JDBC drivers cannot connect to the database due to a network or databaselistener configuration problem

The IS_MULTI_SITE_Y_OR_N value in the Oracle iLearningilearning.properties configuration file is set to 'N'.

Shut down the instances of Oracle Application Server 10gR3

Change the value to Y in ilearning.properties

Restart Oracle Application Server 10gR3

Issue: After the installation completed, the Oracle iLearning login page appears, but Icannot login successfully (note: the Announcements bin and Site field do not alwaysappear).


43/47



Chapter 1 - Page 40

Resolution: This occurs if any middle tier cannot communicate with the database. Thismay happen if the database is down; the database Oracle iLearning schema name or

password is different to values contained in the ilearning.properties

configuration file on the middle tier application servers; or the JDBC driver cannotconnect to the database due to network or database listener problems. Check theschema name and password and attempt to connect to the Oracle iLearning schema

using SQL*Plus. Make the appropriate changes to the Oracle iLearning configurationfile or the database.

Issue: Is Oracle iLearning capable of load balancing and high availability?

Resolution: Oracle iLearning can load balance across application servers using theOC4J cluster mechanism.

Issue: The default session time-outs in the Oracle iLearning installation are too short.How can they be increased beyond 1 hour?

Resolution: Add the following timeout entries to the/j2ee/oil/applications/ilearning/ilearn/WEB-INF/web.xml

file. These properties specify the length of time (in minutes) before idle browsersessions are invalidated due to inactivity. The following syntax is used to set inactivesession time out value to 75 minutes:75

Note: Please refer to your Oracle Application Server 10gR3 documentation for moreinformation.The following parameter applies specifically to the Oracle iLearning player. This value

can be set from the ilearning.propertiesfile located in the same directory:PLAYER_TIMEOUT=7200000

Issue: When attempting to run reports in Oracle iLearning, I receive one or more of thefollowing errors"Error checking out an application module from the reportingpool"; orJBO-29000: Unexpected exception caught: java.sql.SQLException,msg=ORA-01031: insufficient privileges ORA-06512: at"SYS.DBMS_SESSION",line 58 ORA-06512: at "ILEARN_RPT.ILA_VPD", line 7 ORA-06512: atline 1

Resolution:

The Oracle Context option may not be installed on your database server, or may not be

configured correctly. Check that the ILA_CONTEXT object exists in the sys or systemdatabase schemas. If not, try creating this object using the following commands:SQL> CONNECT SYSTEM/@SQL> CREATE CONTEXT ila_context USING ILEARN_RPT.ila_vpd;Check that there are no invalid objects in the CTXSYS schema bySQL> SELECT OBJECT_NAME, STATUS FROM DBA_OBJECTS WHERESTATUS='INVALID' AND OWNER='CTXSYS';


44/47



Chapter 1 - Page 41

View the ilearning.properties file to ensure your reporting schema name andpasswords are correct and sufficient application modules are configured in the pool forOracle iLearning. The parameters to check are:

reporting.connectString=jdbc:oracle:thin:/@::

reporting.initialsize=5

reporting.maximumsize=40Retry a report execution.

You can only have one database schema that uses ILA_CONTEXT. If two ilearningschemas exist in the database, this can cause reports to fail. Drop the previous

ILA_CONTEXT and use the install.sqlin the

ilearn/src/sql/adhoc/directory to reinstall only the adhoc

reporting related parts pointing to your Oracle iLearning schema.

Issue: No content can be played from Oracle iLearning. A File Not Found error

message is received.

Resolution: Please make sure the host name and port number is defined correctly in

your ilearning.properties file. Also verify the LMS_URLandAICC_URLvaluesare correct.

Issue: Files cannot be successfully uploaded to an Oracle iLearning secured contentserver.

Resolution:

Make sure that value of the directives DocumentRootand Directoryare set

correctly in the httpd.conffile.

There also needs to be an ftpserver process running on the content server.

The username and password supplied in the ilearning.propertiesmust

match a user created in the ftpserver. This user also requires write permissions in

the directory specified in the httpd.conffile.

If a load balancer is in place, ensure the load balancer FTP Port is set up andaccepts FTP connections

Issue:When launching content on an Oracle iLearning Secured Server, the user

receives a HTTP 403 Permission Denied error

Resolution:

The following entries must match exactly:

httpd.conf ServerName

ilearning.properties HOST parameter of the content server

Host and Port setup of the content server all must match exactly Verify the value of the oracle.ila.player.cookie in:

http://:/ilearn/en/learner/shared/jsp/env.jsp

Issue: Installation completes, but a window is left open after installation.

Resolution: If the installation has completed successfully, you should be able to exitthe installer. The open window was created by the installer to start the OracleEnterprise Manager website. Do not close this window if you are planning on using


45/47



Chapter 1 - Page 42

Oracle Enterprise Manager to administer Oracle iLearning through the OracleApplication Server 10gR3.

Issue: On Windows 2003 Server, I installed an FTP server, but it does not start.

Resolution: There is a default FTP server created during the Windows 2003 serverinstallation. Only one FTP server should be configured. To resolve the problem. Youcan either:

Disable the Windows 2003 FTP server (from the Internet Services Manager) andinstall another FTP server; or

Configure the Windows 2003 FTP server. Please refer to the Windows 2003 Serverdocumentation for more information on the guidelines available in the Setting Up aContent Server document.

Issue: Users accessing Oracle iLearning from a Trusted URL cannot log in.

Possible Reasons:

If the external page is a secured page (using HTTPS), the link to OracleiLearning must also point to HTTPS

External pages cannot use javascript to construct the link to Oracle iLearning.

Users who have any administrative permissions other than Run Report will notbe able to log in this way. Users with administrative permissions should logdirectly in to Oracle iLearning.

Issue:Email notifications are not being sent when performing the following actions:

Enrollments/Unenrollments (except mandatory enrollment option)

Course cancellations

New user account creation

Forum notification

Instructor booking or cancellation

Certification reminder and expiration

Assessment submission

Notification to all learners currently enrolled in an offering

Standard and Learning Credit Order creation

Possible Reasons:

The smtp MAIL_HOSTentry in the ilearning.properties file is not pointing to the

correct smtp server

The smtp server is not accesible to the Oracle iLearning middle tier. (Unix only)Attempt to send an email from the command line on the middle tier to the smtpserver:

mailx -v , then enter the subject and body of the

email. Then, press Control Dto send.

The From or To email address is invalid or has syntax errors

The From Address for Notification Emails email address on the

Oracle iLearning site properties page is invalid or has syntax errors

TheADMIN_EMAILentry in the ilearning.properties file is invalid or has syntax

errors

Issue: Importing an XML file is extremely slow or never finishes


46/47



Chapter 1 - Page 43

Possible Reasons:

Ensure the xml file being imported references the correct instance of OracleiLearning if a reference to Oracle iLearning is present. If the schema validation isattempting to access another URL, it may be slow or hang completely.

Common Content Server Configuration Errors When Uploading Content

How does Content Upload Work?

When the user uploads content files using the Oracle iLearning administrative user interface,the content file is transferred from the users machine to the Oracle iLearning middle tier serverin a physical directory determined by a designated content server.

The content file is uploaded in three steps:

First, the content file is placed in a temporary location -

$TEMP_DIR/TempImportExportDir/ImportFiles/directory by the web server using http

protocol. The process renames the file to make it unique by suffixing additional characters.

Second, the file is transferred from the temporary location mentioned above to the contentserver directory using the ftp protocol. After the file is transferred, it is removed from thetemporary location.

Third, if the content file is a zip file, the web server triggers a servlet process to unzip the file inthe same directory. If the uploaded file is an individual file, then it is renamed to its originalname. The zip file is removed from this directory after successful unzip.

What are most common issues encountered in configuring a content server?

(1) The content file is not transferred from the users machine to the middle tier server.

Error message:

"The content server is not running on on Port . No files wereuploaded to the content server."

(2) The middle tier server fails to transfer the file from the location as mentioned in the first stepabove to the location mentioned in second step (i.e. content server location).

Error message:

"The FTP server is not running on the content server on Port . Nofiles were uploaded to the content server."

(3) The zip file have been uploaded into the appropriate directory in the content server but theunzip process failed.

Error message:

"The FTP server is not running on the content server on Port . Nofiles were uploaded to the content server."

No error message is seen during upload, but the file is not viewable or playable. If youphysically inspect the content location directory, you find a zip file there instead of the regularcontent files.

How to Fix Content Server Not Running issues?

The content server is not configured properly. Please follow the instructions as contained inOracle iLearning install guide to configure the content server.

How to Fix FTP Server Not Running issues?

Provide ftp access from the middle tier servers to the content server. If the middle tier serversand the content server are on the same machine, the ilearning owner (the unix user) should beable to ftp to localhost. This error message could also be thrown by the web server if the contentsever is not configured properly.


47/47

How to fix unzip or access issues?

As part of the content upload process, the middle tier server accesses the Virtual IP to initiateunzip of the uploaded file. In a BigIP and Firewall environment, most likely this might not beallowed. The following two configuration settings will help solve this problem:

(1) If the HTTP server is listening on a port other than 80:

You need to setup an extra route on the proxy service of the firewall to provide loopback access

from the middle tier server to the Virtual IP on the same BigIP. Please contact your Systemadministrator/Security Administrator to setup this configuration for you.

Test this by giving the following command:

(a) try to access the Virtual IP from the middle tier server

$telnet 80

If the above command succeeds, then the access from the middle tier server to the Virtual IP isallowed, and the extra route works.

(2) If the HTTP server is listening on port 80:

Though the solution given at (1) above will also work if the HTTP server is listening on port 80,there is one more workaround for this kind of configuration:

Add the Virtual IP as an alias for the middle tier server machine. As an example this could be

done by having the following entry in the /etc/hosts file:

< mt server machine name>

In this case the middle tier server would resolve that the Virtual IP is itself and the request willnot go to the BigIP.

oracle ilearning installation guide release 6 1

Documents