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.
The following must be done
prior to scripting the database:
- Create and configure the portal database.
- Create the sys password.
For example: $ $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/database/orapwPLUM
password=password
- Create the PLUM directory under $ORACLE_BASE/oradata
- Create a link to initPLUM.ora in $ORACLE_HOME/database
- Create the portal database instance.
- From $ORACLE_BASE/admin/$ORACLE_SID/plumtreescripts, start sqlplus using the /nolog parameter.
- 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.
- 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.
- 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.
- 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.)