You create a database instance on a local or remote computer using the Database Manager GUI.
· 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).
...
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.
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.