Create ISIM database

This step is required only if we do not use the Oracle Database Configuration Assistant wizard, which creates ISIM database. To use the Oracle Database Configuration Assistant wizard to create database, see "Creating Database with the Oracle Database Configuration Assistant" from the Oracle Official website.

We must finish installing the Oracle database.

  1. Manually create an ISIM database.
    • Windows operating systems:

      1. Create the instance with this command:

          # oradim -new -sid db_name -pfile ORACLE_HOME\admin\db_name\pfile\ initdb_name.ora

        The value of the -sid parameter specifies the database instance name. For example, the value of db_name might be itimdb. The value of the -pfile parameter specifies the file that you previously configured in Configure the init.ora file.

      2. Start the database instance with these commands:

          # sqlplus "/ as sysdba" SQL> startup nomount pfile=ORACLE_HOME\admin\db_name\pfile\initdb_name.ora

      3. Verify that the Windows service OracleService db_name is started.

    • UNIX or Linux operating systems:

      Start the database instance with these commands.

        # ./sqlplus "/ as sysdba" SQL> startup nomount pfile= ORACLE_HOME/dbs/initdb_name.ora
  2. Use an SQL script like the following example to create your database. Change the values in the script to match any requirements at your site. In this example, the value of the db_name is an instance name such as itimdb. 
      --  Create database
CREATE DATABASE db_name
    CONTROLFILE REUSE
    LOGFILE '/u01/oracle/db_name/redo01.log' SIZE 1M REUSE,
            '/u01/oracle/db_name/redo02.log' SIZE 1M REUSE,
            '/u01/oracle/db_name/redo03.log' SIZE 1M REUSE,
            '/u01/oracle/db_name/redo04.log' SIZE 1M REUSE
    DATAFILE '/u01/oracle/db_name/system01.dbf' SIZE 10M REUSE 
      AUTOEXTEND ON
      NEXT 10M MAXSIZE 200M 
    CHARACTER SET UTF8;

-- Create another (temporary) system tablespace
CREATE ROLLBACK SEGMENT rb_temp STORAGE (INITIAL 100 k NEXT 250 k);

-- Alter temporary system tablespace online before proceeding
ALTER ROLLBACK SEGMENT rb_temp ONLINE;

-- Create additional tablespaces ...
-- RBS: For rollback segments
-- USERs: Create user sets this as the default tablespace
-- TEMP: Create user sets this as the temporary tablespace
CREATE TABLESPACE rbs
    DATAFILE '/u01/oracle/db_name/db_name.dbf' SIZE 5M REUSE AUTOEXTEND ON
      NEXT 5M MAXSIZE 150M;
CREATE TABLESPACE users     DATAFILE '/u01/oracle/db_name/users01.dbf' SIZE 3M REUSE AUTOEXTEND ON
      NEXT 5M MAXSIZE 150M;
CREATE TABLESPACE temp
    DATAFILE '/u01/oracle/db_name/temp01.dbf' SIZE 2M REUSE AUTOEXTEND ON
      NEXT 5M MAXSIZE 150M;

-- Create rollback segments.  
CREATE ROLLBACK SEGMENT rb1 STORAGE(INITIAL 50K NEXT 250K)
  tablespace rbs;
CREATE ROLLBACK SEGMENT rb2 STORAGE(INITIAL 50K NEXT 250K)
  tablespace rbs;
CREATE ROLLBACK SEGMENT rb3 STORAGE(INITIAL 50K NEXT 250K)
  tablespace rbs;
CREATE ROLLBACK SEGMENT rb4 STORAGE(INITIAL 50K NEXT 250K)
  tablespace rbs;

-- Bring new rollback segments online and drop the temporary system one ALTER ROLLBACK SEGMENT rb1 ONLINE;
ALTER ROLLBACK SEGMENT rb2 ONLINE;
ALTER ROLLBACK SEGMENT rb3 ONLINE;
ALTER ROLLBACK SEGMENT rb4 ONLINE;

ALTER ROLLBACK SEGMENT rb_temp OFFLINE;
DROP ROLLBACK SEGMENT rb_temp ;

    Use Security Identity Manager Performance Tuning Guide to tune the Oracle database for all systems, both for production and test environments.

  3. Install the JVM for the database. Use these commands:

      For UNIX:
      # sqlplus "/ as sysdba"

      SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
      SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
      SQL> @$ORACLE_HOME/javavm/install/initjvm.sql
      SQL> @$ORACLE_HOME/xdk/admin/initxml.sql
      SQL> @$ORACLE_HOME/xdk/admin/xmlja.sql
      SQL> @$ORACLE_HOME/rdbms/admin/catjava.sql

      SQL> connect system/manager
      SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
    For Windows:


      # sqlplus "/ as sysdba"
      SQL> @%ORACLE_HOME%/rdbms/admin/catalog.sql
      SQL> @%%$ORACLE_HOME%/rdbms/admin/catproc.sql
      SQL> @%%$ORACLE_HOME%/javavm/install/initjvm.sql
      SQL> @%%$ORACLE_HOME%/xdk/admin/initxml.sql
      SQL> @%%$ORACLE_HOME%/xdk/admin/xmlja.sql
      SQL> @%%$ORACLE_HOME%/rdbms/admin/catjava.sql

      SQL> connect system/manager
      SQL> @%ORACLE_HOME/sqlplus/admin/pupbld.sql

    The value of the manager parameter is the password for the system user account.

Tune the database performance.

Parent topic: Install the Oracle database


Related


Related tasks