Creating the Oracle tablespaces in the database
You must create tables and related database files for the Contenta environment in your Oracle database.
Procedure
- Log in as the root user.
- Edit the /pdm/setup/pdm_setup.sql script.
- Find the section of the file that reads:
The sizes in the pdm_setup.sql file, as delivered, are suggested configuration sizes for a typical database.
Create the tablespace file path under Oracle_home. This is because default Oracle users (like sys and system) do not have permissions to create or access files anywhere other than Oracle_homeNote: Each Contenta tablespace can be stored on a separate disk to minimize load. - Edit the entries for the other tablespaces. The other tablespace entries in the file are:
datafile '/usr/app/pdmqa/pdmdbs/pdmindx_1.dbf' size 1000M datafile '/usr/app/pdmqa/pdmdbs/temp_1.dbf' size 500M - Check that the tablespace directories are owned by oracle and the group is dba.
- Source the /pdm/bin/pdm.cshrc file.
- At a system prompt, change the directory by entering cd /pdm/setup.
- Execute the pdm_setup.sql script in SQL*Plus.
Note: You must run this script as either the root user or the user who installs Contenta because by default, Oracle users such as sys or system do not have permissions to access the pdm_setup.sql file.
At a system prompt, enter:
sqlplus system/pword
where pword is the user’s password.
- At the SQL*Plus prompt, enter: @pdm_setup.sql
This creates the Contenta tablespaces, rollback segments, and data files.
- When the script is completed, at the SQL*Plus prompt, enter exit.