Creating and Configuring a Database
Instance
Purpose
To create and configure a database instance, you can use either the Installation Manager or the Database Manager database tool.
Prerequisites
If you use the
Database Manager to create a database instance, you first have to install the
database software (see the
Installation
Manual).
Process Flow
...
1. You plan your database instance.
See
○ Planning the Database Instance
2. You create the database instance.
See
○
Installation Manual,
Using the Installation
Manager
○
Database Manager GUI,
Creating a Database
Instance
○
Database Manager CLI,
db_create
○
Database Administration
Tutorial,
Creating and
Configuring a Database Instance
You can use templates (see Templates for Database Instances ).
When you create the database instance, you configure the following properties, among others:
○ Database name (see Conventions for Database Names)
○ Data and log volumes (size, directories)
○ Values of important database parameters (see Database Parameters)
Use the special database parameter _UNICODE to determine whether the names of database objects in the database catalog, such as tables and column names, are to be stored in Unicode. You can not change this database parameter once the database has been created.
○ Other operating properties (see, for example, Automatic Start and Log Settings)
○ First users (see Users, Authentication and Authorizations)
3. The database system transfers the database instance to the ONLINE operational state.
Result
The database instance is ready for operation. You can now create tables and insert data in the database instance (see Database Design).
See also:
Installation Manual,
Directories