> AquaLogic Interaction Installation Guide for Unix and Linux > Installation > Creating and Configuring an Oracle Database on Unix > Creating the Portal Schema for Oracle on Unix

AquaLogic Interaction Installation Guide for Unix and Linux

     Previous Next  Open TOC in new window   View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Creating the Portal Schema for Oracle on Unix

Prior to creating the portal schema you must configure the database, tablespace, and database user.

For details on Oracle 9i, see Creating the Portal Database for Oracle 9i On Unix

For details on Oracle 10g, see Creating the Portal Database for Oracle 10g On Unix

This section describes how to create the portal schema.
  1. Create the ALI tables, indexes, and stored procedures. Create the ALI tables, indexes, and stored procedures by running the init_ali_db_oracle.sql script. You must run this script as the portal database user that you created. Output from the script is saved in the following files in the scripts directory:
    • create_tables_oracle.lst
    • stored_procs_oracle.lst
    • load_seed_info.lst
    • postinst.lst
  2. (Optional) Create an Oracle SPFILE. For the benefits of using an SPFILE, refer to Oracle documentation.

    To create the SPFILE, run the create_spfile_oracle_unix.sql script.

  3. Create the Directory tables.

    Run the following scripts in order:


    1. create_tables.sql
    2. create_functions.sql
    3. map_alidb_65.sql
Parent topic: Creating and Configuring an Oracle Database on Unix

  Back to Top      Previous Next