Creating or Initializing a Database Instance 

Prerequisites

If you want to create the database instance locally and the Microsoft Windows operating system is installed on your host, your operating system user must have administration rights.

If you want to create the database instance on a remote host and the operating system Microsoft Windows is installed, then the operating system user must possess both administration rights and also the log on as batch job authorization.  (You can find information about maintaining operating system users in your operating system documentation.)

If you want to initialize an existing database instance, your must possess administration rights for this database instance and the database server.

Procedure

Select Instance ® Install to open the Database Wizard. This installation wizard now guides you through the whole process for creating a database instance.

...

       1.      Enter the name of the database instance (Database name). This can also be the name of an existing database instance, if you want to initialize this existing instance. In this case, choose Next to go directly to step 3.
If the new database instance is to be created on a remote server, you must also specify the name of this server and your operating system user name and password for this server.

Choose Next.

       2.      There may be more than one installation of the database software on the same server. The different installations may also be of different versions. Of the installations present on the server, select the one you want.

Choose Next.

       3.      Enter the database manager operator DBM and the database system administrator SYSDBA, and assign passwords for DBM and SYSDBA.
When specifying SYSDBA and when later using it in the SQL environment, note that the Database Manager automatically converts all letters to uppercase.

If you are planning to copy the parameter file from a backup, enter the name and password of the SYSDBA saved in this parameter file.

Choose Next.

       4.      Select one of the following options:

Initialize parameters with default values
When the parameter file for the database instance is created, the standard configuration stored when the database software was installed is used.

Use current parameters
You only have this option if you are initializing an existing database instance. You use its parameters.

Copy parameters from existing database
You want to use the configuration of a database instance on the server.
Select the database instance from which the parameter file is to be copied and choose Next.

Restore parameters from a backup medium
You want to use the parameter file in a complete data backup to create the new database instance. Select the desired complete data backup.

       5.      Choose an instance type for the database.
If you chose Use current parameters in the previous steps, the system uses the instance type of the existing database instance.

       6.      Adjust the parameters to your requirements. Select the required parameter and then choose Edit.
It now appears in the bottom part of the window. Next to the parameter you will see an explanation of what the parameter does and, in some cases, how it is calculated.

In the New Value field, enter the new value for the parameter and confirm your entry.
The new value appears in the New Value column. It is stored in the internal data structures and becomes effective when the database instance is next restarted.

Choose Next.
When you exit the input screen, the parameters are checked in accordance with the rules stored on the server. You may be asked to make and confirm changes before you can leave the input screen.

       7.      Define the properties of the log volumes and the data volumes. When doing so, bear in mind the parameters set in the previous step.

Select a volume and then choose Edit. Enter the size and ID or the absolute path of the volume and confirm your entries. Repeat this process for each volume.

Choose Next.

       8.      Choose between the following options:

Install and start instance
A completely new database instance is created with the parameters in point 6., and is switched to the ONLINEoperational state.

Install instance for recovery
The database instance is reinitialized with the parameters in point 6., and is ready to import backups. The database instance can then be recovered (Recovery), or a homogeneous system copy can be created (Creating a Homogeneous System Copy).

Choose Next.

       9.      Choose Install to start the creation of the new database instance or the initialization of the specified instance.

You can see how the generation or initialization of the database instance is progressing. If any errors occur, the process is stopped immediately. However, the state that had been reached when the error or fault occurred is preserved.

Before you complete this step, the system prompts you to enter the name under which the database instance is to be registered in the Database Manager GUI. Confirm your entries.

   10.      Select Close to close the Database Wizard.
You are taken back to the start screen of the Database Manager GUI.

Result

If you created a new database instance, its operational state is ONLINE.

If you initialized an existing database instance, its operational state is ADMIN. Now you can recover a database instance or create a homogeneous system copy of a database instance.