Technical data

Oracle Database Installation
Database Installation 2-9
Create the Database and Import Demo Data
The CDXDBA utility provided in the “Database Creation” folder may be used to automate the
process. Complete the steps in Creating the Database on page 2-9 to create the database and
import the Demo Install data into the database. The Database Creation folder contains the
instructions for the import of the Demo Install data.
Creating the Database
This process is not required if you are performing a database upgrade from a previous version of
the application. See Upgrade Install for instructions on upgrading the database.
Note: The Unix and Windows installs will create an empty database and at least
one tablespace for storing the application objects before running the install.
The default name of the application tablespace is CISTS_01. If you do not use
the default name or want to spread application objects across multiple
tablespaces, you must create the tablespaces of your choice and edit the
Storage.xml file, supplied with the install package, before starting the
installation process.
Unix
The files are located in MDM/DatabaseCreation/Unix.
Follow these steps to create a database:
1. FTP the contents of the Database Creation folder to a temporary directory on the UNIX
server.
2. To create the database set the ORACLE_HOME and ORACLE_BASE variables.
3. Execute the utility cdxdba.plx by entering following command:
perl cdxdba.plx
4. The script will prompt for parameter values:
• Enter the instance name (DEMO):
• Enter ORACLE_BASE: the directory where the setup files for the database will be
created (/orasw/app/oracle):
• Enter ORACLE_HOME: the folder where the current version of Oracle software is
installed (/orasw/app/oracle/product/):
• Enter ORACLE_DATA: the directory where the data files for the database will be
created (/db05/oradata):
• Enter the character set for the database (AL32UTF8):
Note: AL32UTF8 is the recommended database character set. The application
also supports character sets for multi-languages.
5. Enter the values based on the settings of your database server. You can also accept the default
values displayed if they match your database server settings. You will be prompted to confirm
the settings and select Y or N to create the database.
ORACLE_SID: DEMO
ORACLE_HOME: /orasw/app/oracle/product/
ORACLE_BASE: /orasw/app/oracle
ORACLE_DATA: /db05/oradata
Character Set: AL32UTF8
Do you want to continue (Y/N)?
6. Once the database has been created, you will be prompted to either exit the utility or to install
the demo database: