Creating the Portal Database for Oracle 9i On Unix

This topic describes how to create and configure the portal database, tablespace, and user on Oracle 9i.

Note: These steps create a new, dedicated portal database. If you are creating the portal tablespace within an existing database, see Creating the Portal Tablespace for Oracle 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
If this is a re-creation of a database or a retry of a prior failed attempt, delete the old database file.

Create and configure the portal database.
1. Create the sys password. For example: $ $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/database/orapwPLUM password=password
2. Create the PLUM directory under $ORACLE_BASE/oradata
3. Create a link to initPLUM.ora in $ORACLE_HOME/database
Create the portal database instance.
1. From $ORACLE_BASE/admin/$ORACLE_SID/plumtreescripts, start sqlplus using the /nolog parameter.
2. Run the crdb1_oracle_unix.sql script to create and start the new database instance.
  This script should generate no errors. Output from the script is saved in the file crdb1.lst in the plumtree scripts directory.
  
  The database should now be running.
3. Verify that the correct data files have been created. In $ORACLE_BASE/oradata/$ORACLE_SID you should see the following:
  - systPLUM.dbf
  - undo1A.dbf
  - temp1A.dbf (single disk installation only.)
Create the portal tablespace and user.
1. Run the crdb2_oracle_unix.sql script to create tablespaces, create the portal database user, and perform low level database tuning.
  This script can take a significant amount of time to complete. The following errors might be generated:
```
ORA-00942 table or view does not exist 
ORA-1432/ORA-1434 public synonym to be dropped does not exist 
```
  These errors are acceptable. Any other errors are not acceptable. Output from the script is saved in the file crdb1.lst in the plumtree scripts directory.
2. Verify that the correct data files have been created. In $ORACLE_BASE/oradata/$ORACLE_SID you should see the following:
  - PLUMtbl1.dbf
  - PLUMtmp1.dbf
  - PLUMidx1.dbf (single disk installation only.)

Parent topic: Creating and Configuring an Oracle Database on Unix

AquaLogic Interaction Installation Guide for Windows

Creating the Portal Database for Oracle 9i On Unix