E
Metadata Repository Postinstallation and Configuration

This appendix lists the post-installation tasks that enable you to begin using Oracle9iAS Clickstream Intelligence with the metadata repository provided with Oracle9i Application Server (Oracle9iAS).

This appendix contains the following topics:

• Metadata Repository Post-Installation Tasks

• Installing the Metadata Repository in a non-English Language

Metadata Repository Post-Installation Tasks

Follow the steps below to begin using Oracle9iAS Clickstream Intelligence with the infrastructure database provided with Oracle9i Application Server. Platform-specific instructions are embedded within the text, where applicable.

1. Use the Oracle9iAS Universal Installer to install Oracle9iAS Clickstream Intelligence. For Oracle9iAS installation details, see the Oracle9i Application Server Installation Guide.

2. Install the appropriate Patchset for your operating system. To do this, go to the following URL:

   http://metalink.oracle.com
   
   

   Following successful login with a valid username and password, click Patches from the menu on the left side of your screen. Provide the following Patch Download query data. Fields not listed below require no modification; leave the default values in the fields provided.

   • Product Family: Oracle Server

   • Release: 9.0.1.3

   • Platform: (select the same platform as your Oracle9i database)

   • Language: (select the language that matches the one you selected during Oracle9i database installation.)

   • Limit Search To: All Product Patches

   Click the Submit button. From the list of patches displayed, click the link for one of the patches listed below. Download the patch as specified in the ReadMe file.

   • (UNIX) Oracle 9.0.1.3 Patch Set for Oracle Data Server.

   • (Windows) Oracle9i 9.0.1.3.1 Patch 4 for Windows NT and Windows 2000.

   Note: If you are installing the metadata repository in a language other than English, go to the "Installing the Metadata Repository in a non-English Language" section of this appendix and perform those tasks before performing the remaining installation tasks below.

3. Use Oracle Enterprise Manager (OEM) to modify the pre-generated passwords that were automatically created during installation. To learn more about changing the clkrt and clkana schema passwords, see the "Changing Component Schema Passwords" section of Chapter 10, "Reconfiguring the Application Server," in Oracle9iAS Admimistrator's Guide.

4. Continue post-installation tasks as described below. The following steps require use of Oracle9i Discoverer Administrator, which is part of Oracle9i Developer Suite (Oracle9iDS).
   • Create an End User Layer (EUL) with the Oracle9i Discoverer Administrator EUL Manager Dialog. Instructions for creating an empty EUL can be found in the Oracle9i Discoverer Administrator Administration Guide.

   • Use the Oracle9i Discoverer Administrator Import Wizard to populate the EUL with the Clickstream EUL objects contained in the clickstream_intelligence_eul_full.eex file. This file is located in the appropriate directory below:

     (UNIX)  ORACLE_HOME/install/analytics/discoverer/LANG
     
     (Windows)  ORACLE_HOME\install\analytics\discoverer\LANG
     
     

     ORACLE_HOME is the directory in which Oracle9iAS is installed, and the LANG variable is the code for the language selected during Oracle9iAS installation.

     For information about populating the EUL with Clickstream metadata, see the Oracle9i Discoverer Administrator Administration Guide.

5. Access the Clickstream Intelligence Home page at the following URL:

   http://HOST:PORT/click/
   
   

   The HOST is the name of the computer on which Clickstream Intelligence is installed, and the PORT is the primary port on which the Web server listens for HTTP requests.

6. Log on to the Runtime Administrator with the username clkrt and the password you defined via OEM.

7. Define and configure the Runtime Administrator parameters that specify the way you want data to be acquired and processed from Web server log files. For additional information about the Runtime Administrator, see the Oracle9iAS Clickstream Intelligence Administrator's Guide.

8. Load Web server log file data into the infrastructure database. For information about the Load Clickstream process and other database processes, see Chapter 4, "Loading the Clickstream Database".

9. Enable viewing of Clickstream Analytics by creating a "Private" database connection. To do this, go to the Clickstream Intelligence Home page and click the Analytics- Discoverer Viewer link. The Connect to Discoverer Viewer page appears.

10. Click Create Connection. The Connection Details page appears. Provide the Connection Name, Connection Description, and Locale (the language used to view Clickstream Analytics).

11. Provide the following Database Connection Details:
    • User Name: enter clkana.

    • Password: the clkana schema password you defined via OEM.

    • Database: the TNS alias for the Oracle9iAS metadata repository.

12. Click Apply. You return to the Connect to Discoverer Viewer page.

13. To access Clickstream Analytics, click the link for the name of the (private) connection you created.

Installing the Metadata Repository in a non-English Language

When you want to install the metadata repository in a language that is not English, run the clkinstall program immediately after Oracle9iAS installation. This script is located in the appropriate directory below, where the ORACLE_HOME variable represents your Oracle9iAS home directory.

(UNIX)  ORACLE_HOME/bin

(Windows)  ORACLE_HOME\bin

To select the language for the Clickstream Intelligence Runtime Administrator and Clickstream Analytics, enter the following command:

clkinstall seed --click-home=CLICK_HOME --hostname=HOST --sid=SID 
--port=PORT --rtadmin-lang=RTADMIN_LANG --analytics-lang=ANALYTICS_LANG

In the expression above, the CLICK_HOME variable is equivalent to:

(UNIX)  ORACLE_HOME/click

(Windows)  ORACLE_HOME\click

Additionally, the HOST is the name of the machine on which the metadata repository is installed, SID is the database system ID, PORT is the port number of the database TNS listener, RTADMIN_LANG is the language you want to use for the Clickstream Intelligence Runtime Administrator, and ANALYTICS_LANG is the language in which you want to view Clickstream Analytics.