This chapter shows you how to use the Oracle Universal Installer
(OUI) to install your Oracle database software and create a starter database.
You will also learn how you can use the Database Configuration Assistant (DBCA)
to create additional databases.
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
You can use the Oracle Universal Installer (OUI) to install
your Oracle software . The OUI is a GUI tool that enables you to view the Oracle
software that is installed on your machine, install new Oracle software, and
delete Oracle software that you no longer intend to use.
Follow the steps below to install the Oracle software and
create a database:
1.
Log onto you computer as a member of the administrative
group that is authorized to install Oracle software and create and run
the database.
2.
Insert the distribution CD for the database into your
CD drive. The Autorun window will appear automatically. Select
Install/Deinstall Products.
Note: If you are downloading from Oracle’s
download site, follow the instructions given on the Web site.
3.
The Oracle Universal Installer Welcome window
appears. Select Next to begin the installation of your software
4.
On UNIX and Linux installations, the Specify Inventory
directory and credentials window appears. Enter the full path of the
directory in which to install the Oracle software or accept the default.
Enter the name of an operating system group that has write permission
to the directory. Click Next. Click OK.
5.
A dialog page appears.
Open a new terminal window, log in as root,
and run the orainstRoot.sh
script as instructed in the dialog page. When the script finishes, return
to the Oracle Universal Installer page and click Continue.
6.
The Specify File Locations page appears. Enter
the Oracle home name and directory path in which to install the Oracle
software or accept the default. Click Next.
7.
The Select Installation Type page appears. Select
Enterprise Edition or Standard Edition as appropriate for
your environment. Click Next.
8.
The installer will now verify that your system meets
all the minimum requirements for installing and configuring the chosen
products. Correct any reported issues before continuing. Click Next.
9.
The Select Database Configuration page appears.
Select the starter database type of General Purpose, Transaction
Processing, or Data Warehouse. Click Next.
10.
The Specify Database Configuration Options page
appears. Enter the Global Database Name and SID in the Database
Naming section. Select the character set in the Database Character
Set section. Select Create database with Sample Schemas to
install the Sample schemas. Click Next.
11.
The Select Database Management Option page appears.
Select Use Database Control for Database Management. Click Next.
12.
The Specify Database File Storage Option page
appears. Select File System, Automatic Storage Management,
or Raw Devices as appropriate to your environment. Click Next.
13.
The Specify Backup and Recovery Options page
appears. Select Do not enable Automated backups to configure your
own backup schedule. Click Next.
14.
The Specify Database Schema Passwords page appears.
Select Use different passwords for these accounts and enter passwords
for the administrative users or select Use the same password for all
the accounts and enter the password. Click Next.
15.
The Summary page appears containing a list of
the products to be installed. Click Install to begin the installation.
16.
You will see the progress window.
17.
The Configuration Assistants page appears. Allow
the assistants to execute. They configure your network, start an Oracle
Net Services listener process for connecting to the database, create the
database and configure management tools.
18.
A page showing a progress bar for database creation
appears.
19.
When the database creation is finished, a page containing
information about your database appears. Review this list. You may click
on Password Management at the bottom of the page if you want to
unlock or change passwords for database accounts. Otherwise click OK.
20.
A dialog page appears.
Open a new terminal window, log in as root,
and run the root.sh
script. When the script finishes, return to the Oracle Universal Installer
page and click OK.
21.
The End of Installation page appears with important
information about Web application port numbers.
22.
Click Yes to exit.
23.
You have now completed the installation of Oracle software
and database creation.
Using the Database Configuration Assistant
(DBCA) to Create a Database
If you choose to install software only and later create a
database, or if you want to create additional databases using the release software
that you just installed, you
can do so by using the Database Configuration Assistant (DBCA).
Follow the steps below to create a database:
1.
Log onto your computer as a member of the administrative
group that is authorized to install Oracle software and create and manage
the database.
2.
Launch the DBCA on a Windows operating system as follows:
Launch the DBCA on a UNIX operating system by entering
the following at a command prompt:
dbca
3.
The Welcome page appears. Click Next.
4.
Select Create a Database on the Operations
window to begin an interview that enables you to configure and create
a database. Click Next.
5.
On the Database Templates page, select the type
of database template to be used in creating the database. You can click
Show Details to see the configuration for each type of database.
Choose the template suited to the type of workload your database will
support. If you are not sure, select the default General Purpose
template. Click Next.
6.
On the Database Identification page, enter the
Global Database Name and SID. Click Next.
7.
The Management Options page appears. To use Enterprise
Manager, select Configure the Database with Enterprise Manager.
Select Use Database Control for Database Management to manage your
database locally or select Use Grid Control for Database Management
as appropriate to your configuration. Click Next.
8.
Enter passwords for the administrative users. Click
Next.
9.
Select File System, Automatic Storage Management,
or Raw Devices as appropriate to your environment. Click Next.
10.
Specify the location for the creation of the datafiles.
Choose one of the following:Use Database File Locations from Template,
Use Common Location for All Database Files, or Use Oracle-Managed
Files. Click Next.
11.
Select Flash Recovery Area and specify a directory
location and size. Select Enable Archiving to place your database
in ARCHIVELOG mode. Click Next.
12.
Click the Sample Schemas tab. Select Sample
Schemas if you want to include the Sample Schemas (EXAMPLE)
tablespace in your database. Click the Custom Scripts tab.
13.
Specify one or more SQL scripts to be run after your
database is created if required in your environment. Otherwise, accept
the default No scripts to run. Click Next.
14.
The Memory page appears. Select Typical
and enter a percentage value. Click the Sizing tab.
15.
The Sizing page appears. Specify the smallest
block size and the maximum number of operating system user processes that
can simultaneously connect to the database.
Note: You cannot specify the block size if you
are using a template.
Click the Character Set tab.
16.
The Character Set page appears. Select the character
set for your database. Click the Connection Mode tab.
17.
The Connection Mode page appears. Select Dedicated
Server or Shared Server as appropriate for your environment.
Click Next.
18.
The Database Storage page appears. Accept the
configuration or make changes as needed. Click Next.
19.
Select Create Database to create your database.
You can also select Save as a Database Template to save your configuration.
Click Finish.
20.
At the Confirmation window, confirm the options
that will be installed and click OK.
21.
Your database is now being created.
22.
After the database is created, you can change or unlock
your passwords or click Exit.
Move your mouse over this icon to hide all screenshots
Bookmark
