Creating the Portal Database for Oracle 9i On Windows
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:
- Register the portal SID in the registry by running RegisterSIDPLUM.reg .
RegisterSIDPLUM.reg is in the directory
on the Oracle Database server to which you copied the scripts.
- Create and configure the portal database.
- Create the PLUM directory under %ORACLE_BASE%\oradata
- Copy initPLUM.ora to %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_nt.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%\database 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_nt.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 process may generate the following errors:
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%\database you should see
the following:
- PLUMtbl1.dbf
- PLUMtmp1.dbf
- PLUMidx1.dbf (single disk installation only.)