Entering content frame

Procedure documentation Creating a Database Instance Locate the document in its SAP Library structure

You create a database instance on a local or remote computer using the Database Manager GUI.

Prerequisites

·        Database instance on a local computer: as an operating system user, you have administrator rights for the computer.

·        Database instance on a remote computer: you need an operating system user for the remote computer with administrator rights and also the log on as batch job right (for Microsoft Windows operating systems) or a similar right (information on managing operating system users is provided in the documentation for your operating system).

Procedure

...

Choose Instance ® Create... .

Choose Next to start each of the required steps.

       1.      Choose the required template:

¡        To use the standard settings, choose Blank.

¡        To use a predefined configuration, choose of one of the templates displayed.
If you choose the HotelDB template to create a database instance, you can create the instance in the background. To do so, choose Unattended Installation.

       2.      To create a database instance on your local computer, enter the following:

¡        Database Server: <local>: Do not change this entry.

¡        Database Name: Name of the database instance. Follow the conventions for database names.

To create a database instance on a remote computer, enter the following in addition:

¡        Database Server: Name of the remote computer

¡        Port: Port used to address the X Server; if you do not specify a port, the default port is used.

¡        Login Name: Operating system user for the remote computer

¡        Password: Password for the operating system user on the remote computer

       3.      A computer can have more than one installation of the database software. Select the appropriate installation.

       4.      If you are using a Microsoft Windows operating system, you can specify further options:

¡        Set the startup type for the database service to automatic: The database instance is started automatically when computer starts.

¡        Use the login information as account for the database service: For remote computers only; the service for the database instance runs on remote computers under the name of the operating system user logged on and not under SYSTEM.

       5.      Specify the first Database Manager operator (DBM operator). Note the conventions for user names and passwords. The default name and password is DBM.

Note

The database system converts the name and password of the DBM operator to upper-case letters.

       6.      Decide how you want to assign initial values to the database parameters.

¡        Initialize parameters with default values
The database parameters are assigned the default values of the database software.

¡        Copy parameters from existing database
The initial values of the database parameters are taken from an existing database instance. Choose the database instance from which you want to copy the parameter values.

¡        Restore parameters from a backup medium
The initial values of the database parameters are taken from a complete data backup. Select the complete data backup that you want to use.

       7.      Select a database instance type.

       8.      Adjust the database parameters to your requirements. To change a database parameter, select the parameter and choose New Value. Enter and confirm the new value for the database parameter. The database parameters are checked when you exit the input screen. You may be prompted to make and confirm changes before you can leave this screen.

       9.      Define your data volumes and log volumes.

¡        If you used a template, you do not have to make any changes here. Otherwise, choose New Volume in each case, enter the size and the name or the absolute path of the volume, and confirm your entries.

¡        If you are creating an archive database instance, add at least one data volume of the type Archive.

   10.      Define any backup media that you need.

   11.      Choose from the following options:

¡        Create and start instance
Specify the database system administrator (SYSDBA user). Do not use special characters and do not choose the name SYSDBA. We recommend that you use upper-case letters. The default name and password is DBA. The database instance is created and transferred to the ONLINE operational state.

¡        Create instance for recovery
The database instance is created and transferred to the ADMIN operational state. You can use this database instance for a recovery only. The details for the SYSDBA user are taken from the data backup.

   12.      To save your configuration as a template, choose Save Template as...

   13.      Choose Start. If errors occur, the procedure is terminated immediately. However, the state reached before the error occurred is preserved.

   14.      Choose Close.

 

 

Leaving content frame