Overview of Installing Oracle Database Software and Creating a Database

    Installing Oracle Database and Creating a Database

    Overview of Installing Oracle Database Software and Creating a Database
    Installing Oracle Database Software
    Creating and Managing a Database with DBCA
    Installation: Oracle By Example Series

Overview of Installing Oracle Database Software and Creating a Database

Before starting the installation process, please check:

        - Checking Prerequisites
        - Deciding on Installation Choices

Checking Prerequisites:

    i. There is a minimum of 1 GB of physical memory.
    ii. Sufficient paging space is available.
    iii. The appropriate service packs or patches for your operating system are installed.
    iv. An appropriate file system format is being used.

Deciding on Installation Choices:

    a. Install Options
    b. Installation Method
    c. Installation Type
    d. Software Installation Directories
    e. Database File Location
    f. Database Identifiers
    g. About Advanced Installation

a. Install Options:

Choose to create and configure a database, or to only install the database software.

If you choose not to create a database during installation, then you must run DBCA after installation to create a database.

 Pre-configured databases are based on templates that Oracle provides or that you create. Each Oracle-provided template is optimized for a particular workload type.

b. Installation Method:

The installation methods are divided into Desktop Class and Server Class:

Desktop Class:

This installation class is most appropriate for laptop or desktop computers. It includes a starter database and requires minimal configuration.

Server Class

This installation class is for servers, such as you would find in a data center, or used to support enterprise-level applications. Choose this installation class if you need access to advanced configuration options.

During a Desktop Class installation, you make only basic choices. For a Server Class installation, you choose either typical installation (where you make only basic choices) or advanced installation.
During a Desktop Class or a typical installation, Oracle Database automatically installs the sample schemas.


c. Installation Type:

During installation of Oracle Database, need to give answeers for the questions listed -

What type of database edition installation do you want to perform?

Enterprise Edition:

Provides data management for enterprise-level applications. It is intended for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments.

Standard Edition:

Suitable for workgroup or department-level applications, and for small to medium-sized enterprises.

Standard One Edition:

Suitable for workgroup, department, or web applications.

Personal Edition:

Microsoft Windows operating systems only.

This installation type installs the same software as the Enterprise Edition, but supports only a single-user, development and deployment environment.

and

What are your database configuration options?

Software Installation Directories

Specify the directory in which the Oracle Database software is installed, or the location where the product binary files are copied from the installation media.

Choose a location that has enough disk space to contain the software and is accessible by the operating system user performing the installation.

Specify the location of the Oracle base directory, which is used by all Oracle software products installed on the server.

The first time you install Oracle Database software on a server, you are prompted to specify the location of the inventory directory, called oraInventory. This directory provides a centralized inventory of all Oracle software products installed on the server.

Use the same value for the Oracle inventory directory each time you perform an Oracle software installation on the server.

Database File Location:

A database includes several files that store the user data, database metadata, and information required to recover from failures. As an administrator, you decide what kind of storage subsystem to use for these files.

File System

This default option creates database files that are managed by the file system of your operating system. You can specify the directory path where database files are to be stored. Oracle Database can create and manage the actual files.

If you are not certain about which option to use, then select File System (the default).

Automatic Storage Management

If you choose Oracle ASM, then Oracle Database automatically manages database file placement and naming. Oracle ASM performs software striping and mirroring at the file level for maximum storage flexibility, performance, and availability.

Oracle ASM uses an Oracle ASM instance, which is distinct from the database instance, to configure and manage disk groups. A single Oracle ASM instance can provide storage for multiple databases on the same server.

Oracle ASM is part of an Oracle grid infrastructure installation.

Database Identifiers

Global database name and system identifier (SID).

The SID is a unique identifier that is used to distinguish this instance from other Oracle Database instances that you may create later and run concurrently on your system.

The global database name is the full name of the database that uniquely distinguishes it from any other database. The global database name is in the form database_name.database_domain, for example sales.example.com.

The database domain portion example.com specifies the database domain in which the database is located.

Together, the database name and domain form the global database name.

About Advanced Installation:

Product Languages

Default value is English.

Database Configuration Type

General Purpose/Transaction Processing or Data Warehousing.

Database Configuration Options

Select the memory size and management options, the character sets used to store data, the security options for database access, and whether the sample schemas should be installed.

Database Management Options

Specify whether to manage your database centrally or locally using Oracle Enterprise Manager.
    Central management enables you to manage multiple targets, such as databases and application servers, using a single interface.
    Using local management you can manage only a single database instance at a time.

Recovery Options

Specify whether automated backups should be configured for the database.
Specify whether the recovery area.

Schema Passwords

When you create a database, certain administrative user accounts are created automatically. You are prompted to enter the passwords for the SYS, SYSTEM, SYSMAN, and DBSNMP accounts, which enable you to manage and administer the database. You can use the same password for each account, or specify passwords for each account individually. If you do not enter a secure password, you will receive a warning message during installation.

Operating System Groups

Administrative access to the database is granted by membership in certain
operating system groups. You can choose the operating system group to be used
for SYSDBA access (typically dba) and SYSOPER access (typically oper).

The SYSDBA group identifies operating system user accounts that have database
administrative privileges and can log in with SYSDBA access.

The SYSOPER group is an optional group for users that should have limited database administrative privileges.