Creating and Configuring an Oracle Database on Windows
This section describes how to create and configure the
Oracle WebCenter Interaction portal database on Oracle and Windows.
- Verify that the Oracle environment variables are properly
set.
For details, see Oracle Environment Variables
- Copy the SQL scripts from the Oracle WebCenter Interaction
installation directory to your Oracle server.
- For Oracle 9i, the Oracle WebCenter Interaction installer
creates the SQL scripts in the following directories:
- install_dir\ptportal\10.3.0\sql\oracle_nt9.2
- install_dir\aluidirectory\1.0\sql\oracle
- For Oracle 10g or 11g, the Oracle WebCenter Interaction installer
creates the SQL scripts in the following directories:
- install_dir\ptportal\10.3.0\sql\oracle_nt10
- install_dir\aluidirectory\1.0\sql\oracle
- Configure the portal database, tablespace, and user.
- Create the portal schema and initialize the portal database.
For details, see Creating the Portal Schema for Oracle on Windows
- Start the Oracle Listener for the portal database.