User`s guide

Creating a Database
4-4 Oracle Database Installation and Administration Guide
■ Creates the system and sysaux tablespace
■ Creates the default permanent tablespace, temporary tablespace, and undo
tablespace
■ Creates the log files
■ Initializes the database
■ Runs CATALOG.SQL
■ Runs CATPROC.SQL
■ Installs the SQL Help tables
■ Installs the DEMO tables
■ Changes the system passwords if necessary
■ Calls the verification procedure
When $ORAC1120.INSTALL.P.SUPER has completed, you should have an initialized,
ready-to-use database, and a running Oracle Database system. The results of the job
are listed in the file,
L.sid.INSSUP.SYSOUT , where SID is the system ID of the database
you have just installed.
4.1.3 Creating a Database Manually
Oracle recommends that you use the automatic creation procedure outlined in
"Creating a Database Automatically" on page 4-2. The following manual creation
procedure performs the same steps as the automatic creation procedure. However,
because you enter the individual steps manually, you can perform the installation at
your own pace, and determine which of the optional of the following steps you want
to perform and which you want to expand, omit, or save for another time.
■ Copying the DBA Procedures
■ Creating the Database
■ Installing Data Dictionary Views
■ Installing Data Dictionary Views for PL/SQL
■ Installing Online Help Messages
■ Installing the Demo Tables
■ Installing the Sample Schemas
■ Verifying Successful Creation of the Database
■ Installing Oracle Text
■ Installing Java
4.1.3.1 Copying the DBA Procedures
Copy the DBA files from $ORAC1120 as shown below:
1. Log in using the DBA User ID .
2. Call Oracle Database install procedure. This procedure copies the DBA files from
$ORAC1120 to the DBA User ID account. When the procedure begins you are
prompted to supply a 1 to 4 character Oracle Database ID for the database you are
installing.
To install the DBA files, enter the following command: