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 Tablespace for Oracle On Unix

This topic describes how to create and configure the portal tablespace and user.

Note: These steps create the portal tablespace within an existing database. If you are creating a new, dedicated portal database , see Creating and Configuring an Oracle Database on Unix

The following must be done prior to scripting the database:


  • Log into the portal database host machine as the owner of the Oracle system files.
  • Verify that ORACLE_BASE,ORACLE_HOME, and ORACLE_SIDare set appropriately.

    For details, see Oracle Environment Variables

  1. Connect to your database as a user with sysdba rights.
  2. Create the portal tablespace and DB user.
    1. From $ORACLE_BASE/admin/$ORACLE_SID/plumtreescripts, start sqlplus using the /nolog parameter.
    2. Run the create_ali_tablespace_unix.sql script to create the portal tablespace.
    3. Run the create_ali_user_oracle.sql script to create the portal schema user

  Back to Top      Previous Next