Oracle9iAS Personalization Administrator's Guide
Release 9.0.1

Part Number A87539-02
Go To Documentation Library
Library
Go To Product List
Solution Area
Go To Table Of Contents
Contents

Go to previous page Go to next page

3
Installing and Configuring Oracle9i
and Oracle9iAS

The instructions in this chapter cover only the highlights of installing and configuring Oracle9i and Oracle9iAS for use with OP. Oracle9i and Oracle9iAS are installed on different systems.

Installing Oracle9i

This section summarizes installing Oracle9i. For full information, see Oracle9i Administrator's Guide.


Note:

Oracle9i and Oracle9iAS are installed on different systems. 


Use Oracle Universal Installer (OUI) to install Oracle9i Database 9.0.1.0.0:

  1. Start OUI as described in Oracle9i Administrator's Guide.

  2. Install the Enterprise Edition of Oracle9i. With the Enterprise Edition, installation includes all the required components plus creating and configuring a starter database.

    See "Required Database Components", below, for a list of the database components required for OP.

    OP runs on EE with and without partitioning. Partitioning is required if you want to deal with large datasets. See "Performance Recommendation" in Chapter 2 for more information.

  3. When prompted, select General Purpose, Global Database Name, and Database File Location. Select appropriate database character set.

  4. Click Install.

  5. When prompted, run script $ORACLE_HOME/root.sh while logged in as root.

Required Database Components

The following database components are required for OP:

Configuring the Database

  1. When installation is finished, a message announces that database creation is completed, and the Password Management window appears.

  2. Password Management: This Password Management window displays the default passwords for SYS and SYSTEM. Change these passwords here.

    • SYS: change_on_install (this is the default; change this password here)

    • SYSTEM: manager (this is the default; change this password here)

  3. Next, edit the init.ora file for your Oracle database instance to set additional startup parameters. Typically this file will be named
    init<$ORACLE_SID>.ora and can be found in the
    $ORACLE_HOME/admin/<db_name>/pfile directory. Go to the end of the init<$ORACLE_SID>.ora file and add:

    aq_tm_processes = 1

    utl_file_dir = /tmp/

    job_queue_processes = 2 (This parameter may already be present; if it is, leave its value set as it is. If it is not there, add it and set it to at least 2.)

    The meaning of these parameters is as follows:

    • aq_tm_processes enables time monitoring of queue messages.

    • utl_file_dir lets you specify a directory that Oracle should use for PL/SQL file I/O.

    • job_queue_processes is the maximum number of jobs that can be created for execution of jobs; this value should be at least 2.

  4. Follow these steps to create a new server parameter file using the updated
    init<$ORACLE_SID>.ora file. (See Oracle 9i Administrator's Guide for more information.)

  5. Start SQL*Plus using the following command:

    $ sqlplus /nolog
    
    
  6. Connect to database as SYS user:

    SQL> connect / as sysdba
    SQL> CREATE SPFILE = 'ORACLE_HOME/dbs/newspfile<$ORACLE_SID>.ora' 
    FROM PFILE='ORACLE_HOME/dbs/init<$ORACLE_SID>.ora';
    
    

    Use the value of ORACLE_HOME in the above SQL statement.

  7. Shut down the database.

    SQL> shutdown
    
    
  8. Copy the new server parameter file created in step 4b to the existing one:

    ORACLE_HOME/dbs/spfile<$ORACLE_SID>.ora
    
    
  9. Start up the database so that it can read the new parameters.

    $ sqlplus /nolog
    SQL> connect / as sysdba
    SQL> startup
    
    

    Once database starts, exit sqlplus:

    SQL> exit
    
    
  10. You can test your connection to the database with the following command:

    $ sqlplus system/<password>@<net_service_name>
    
    

    Your tnsnames.ora file contains net_service_name (TNSname).

  11. Once the database connection is established, you can list the parameters with the following command:

    SQL> show parameters
    
    

    and verify that aq_tm_processes, utl_file_dir, and job_queue_processes have the values given in step 3.

Installing Oracle9i Application Server

This section summarizes installing Oracle9iAS for use with OP. For complete installation information, see the appropriate version of Oracle9i Application Server Installation Guide for your operating system.


Note:

Oracle9i and Oracle9iAS are installed on different systems. 


What

Before Installing Oracle9iAS

Before you install Oracle9iAS, perform these steps:

  1. Set the required environment variables: ORACLE_HOME, ORACLE_TERM, DISPLAY, TMP, and TNS_ADMIN.

  2. Create required UNIX account and groups.

  3. Preinstall any component-specific components on the middle tier and preconfigure an origin database.

  4. Oracle9iAS requires an active database connection. OUI uses this connection to add database objects to the origin database. The origin database can be the database that holds OP database objects, but it is not mandatory that the origin database be the one that holds OP. The origin database is typically located on a database server tier. It can also be located in the same tier where Oracle9iAS is installed.

Installing Oracle9iAS

Follow these steps to install Oracle9iAS:

  1. Start OUI as described in Oracle9i Application Server Installation Guide. (Don't start OUI in the CD directory because you will have to swap CDs.)

  2. File Locations: Specify the path of source file (CD or staging area) and destination (Oracle Home).

  3. UNIX Group Name: Provide the UUNIX group name (for example, dba).

  4. Installation Types: Select the Enterprise Edition option (4.28GB).

    Ensure that there is sufficient disk space (4.28GB+) and swap space (800MB) available on the machine where you are installing Oracle9iAS. (OUI will detect if there is not enough disk space.)

  5. Component Configuration and Startup: Select Oracle HTTP Server in non-SSL mode.

    OP requires the Oracle HTTP Server component to be installed.

    Other deselected components in this screen will be installed but not configured or started later on. Only HTTP Server will be started after the installation completes.

    HTTP Server can be accessed using the following URLs:

    Non SSL Mode (executed at install time): http://host_name:7778

    SSL mode: (executed at install time): http://host_name:80 and
    http://host_name:443

  6. Origin Database Connection Information: Provide host name, port number, and service name where Oracle9iAS is installed (for example, myhost, 1521, myhost.mycompany.com)

  7. Apache Listener Configuration for Oracle9iAS Portal: Use the default setting.

  8. Origin Database User Information: Provide the origin database "sys" account password.

  9. Wireless Edition repository information: Use default settings unless you need to configure Wireless Edition repository.

  10. Wireless Edition schema information: Use default settings.

  11. Enter SYSTEM Password for Wireless Edition: Use default settings.

  12. Summary: Examine the product list that will be installed; if it is correct, click the Install button to start installation.

    There are five CDs for Oracle9iAS installation. Use the Browse button to change and locate the right disk number when OUI prompts you on the screen during the installation.

  13. After installation is complete, OUI prompts you to run the root.sh script. Log in as root, change directory to $ORACLE_HOME, and run root.sh.

  14. Start the origin database (if it has been shut down during the installation).

  15. Configuration Tools: The Configuration Tools screen lists the configuration tools for all installed components. You should see at least Oracle HTTP Server being started here. Others will depend on the components you selected at the beginning of the installation. Verify that the list of configuration tools is correct, and click Next to continue.

  16. End of Installation.

    There are some post-installation steps related to component-specific tasks. For details, refer to the Oracle9i Application Server Installation Guide.


Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Library
Go To Product List
Solution Area
Go To Table Of Contents
Contents