Chapter 2: Installing Oracle Software and Building the Database
Chapter 2: Installing Oracle Software and Building the
Database
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.
Approximately 2 hours
This tutorial covers the following topics:
Place the cursor over this icon to load and view all the screenshots for this tutorial.
(Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)
Note: Alternatively, you can place the cursor over
an individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking
it.
Before you perform this tutorial, you should:
| 1. |
General computer knowledge.
|
| 2. |
Familiarity with basic product installs.
|
Back to Topic List
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. There are two methods
that you can use to install the Oracle software: basic and advanced. Choose
the basic installation method to quickly the install the software with minimal
user input. The advanced installation method enables you to perform a custom
installation.
Back to Topic List
Basic Installation
Follow the steps below to install the Oracle software and
create a database using the basic installation method.
(Note: The Sample Schemas are not installed by default using
the Basic Installation option):
| 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 Select a Product to Install window appears. Select the Oracle
Database 11g option. Click Next.
|
| 4. |
The Select Installation Method window appears. Select Basic Installation.
Specify the Oracle Base Location, Oracle Home location, Installation Type,
and Unix DBA Group appropriate for your environment. Select Create
Starter Database and accept the default Global
Database Name of orcl or supply another database name appropriate for
your environment.
Supply the database password of oracle or a password
of your choice. Click Next.
|
| 5. |
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.
|
| 6. |
The Product-Specific Prerequisites Checks window appears. After all checks
are completed, click Next.
|
| 7. |
The Oracle Configuration Manager Registration window appears. This is
used to associate your configuration information with your Metalink account.
For this exercise, bypass this option and click Next.
|
| 8. |
The Summary window appears containing a list of the products to be installed.
Click Install to begin the installation.
The Install progress window is displayed.
|
| 9. |
The Configuration Assistants window 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.
|
| 10. |
The Database Configuration Assistant window showing a progress bar for
database creation appears.
|
| 11. |
When the database creation is finished, a window containing information
about your database appears. Review this list. You may click Password
Management if you want to unlock or change passwords for database
accounts. Otherwise click OK.
|
| 12. |
The Configuration Assistants window appears again, followed immediately
by the Execute Configuration scripts dialog box.
Before continuing with the installation, two separate scripts must be
run as the root user. Open a new terminal window, log in as root,
and execute the orainstRoot.sh
script found under the /u01/app/oracle/oraInventory directory (as
described in the dialog page).
Navigate to the /u01/app/oracle/product/11.1.0/db_1 directory and execute
the root.sh script.
When the scripts finish, return to the Execute Configuration scripts
page and click OK.
|
| 13. |
The End of Installation page appears with important information about
the Web application. Click Exit.
Click Yes. You have now completed the installation of
Oracle software and database creation.
|
Back to Topic
Follow the steps below to install the Oracle software and
create a database using the advanced installation method.
Note: If you performed the Basic Installation
steps, you do not need to complete this section.
| 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 Select a Product to Install window appears. Select the Oracle
Database 11g option. Click Next.
|
| 4. |
The Select Installation Method window appears. Select Advanced Installation
and click Next to begin the installation of your software.
|
| 5. |
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.
|
| 6. |
The Select Installation Type window appears. Select Enterprise Edition
or Standard Edition as appropriate for your environment. Click
Next.
|
| 7. |
The Install Location window appears. Enter the Oracle Base directory
path in which to install the Oracle software or accept the default. Under
the Software Location region of the window, enter the name and path for
the base location for storing Oracle software files, or, accept the default
values. Click Next.
|
| 8. |
The Oracle Universal 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 Configuration Option window appears. Select Create
a Database and click Next.
|
| 10. |
The Select Database Configuration window appears. Select the starter
database type of General Purpose/Transaction Processing, Data
Warehouse , or Advanced. Click Next.
|
| 11. |
The Specify Database Configuration Options window appears. Enter the
Global Database Name and SID in the appropriate fields.
Click Next.
|
| 12. |
The Specify Database Config Details window appears. From here, you can
configure memory, character sets, security, and sample schema information.
For the Memory, Character Sets, and Security tabs, accept the default
values. Navigate to the Sample Schemas tab. Select Create database
with sample schemas. Click Next.
|
| 13. |
The Select Database Management Option window appears. Select Use Database
Control for Database Management. Click Next.
|
| 14. |
The Specify Database Storage Option window appears. Select File System
or Automatic Storage Management as appropriate to your environment.
Click Next.
|
| 15. |
The Specify Backup and Recovery Options window appears. Select Do
not enable Automated backups to configure your own backup schedule.
Click Next.
|
| 16. |
The Specify Database Schema Passwords window appears. You can choose
the option, 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 one password. Click Next.
|
| 17. |
The Privileged Operating System Groups window appears. Modify the different
groups if necessary and click Next.
|
| 18. |
The Oracle Configuration Manager Registration window appears. This is
used to associate your configuration information with your Metalink account.
For this exercise, bypass this option and click Next.
|
| 19. |
The Summary window appears containing a list of the products to be installed.
Click Install to begin the installation.
The Install progress window is displayed.
|
| 20. |
The Configuration Assistants window 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.
The Database Configuration Assistant window showing a progress bar for
database creation appears.
|
| 21. |
When the database creation is finished, a window containing information
about your database appears. Review this list. You may click Password
Management if you want to unlock or change passwords for database
accounts. Otherwise click OK.
The Configuration Assistants window appears again, followed immediately
by the Execute Configuration scripts dialog box.
|
| 22. |
Before continuing with the installation, two separate scripts must be
run as the root user. Open a new terminal window, log in as root,
and execute the orainstRoot.sh
script found under the /u01/app/oracle/oraInventory directory (as
described in the dialog page).
Navigate to the /u01/app/oracle/product/11.1.0/db_1 directory and execute
the root.sh script.
When the scripts finish, return to the Execute Configuration scripts
page and click OK.
|
| 23. |
The End of Installation page appears with important information about
the Web application. Click Exit.
Click Yes. You have now completed the installation of
Oracle software and database creation.
|
Back to Topic
If you choose to install software only and later create a
database, or if you want to create additional databases using the software that
you just installed, you can do so by using the Database Configuration Assistant
(DBCA).
Note: If you created a database as part of
the Basic Installation or Advanced Installation, you do not need to complete
this section.
Follow the steps below to create a new database or a second
database if you created a database as part of the software installation:
| 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 Linux or UNIX operating system by entering the following
at a command prompt:
dbca
|
| 3. |
The Welcome window appears. Click Next.
|
| 4. |
Select Create a Database in the Operations window to begin
a process that enables you to configure and create a database. Click Next.
|
| 5. |
On the Database Templates window, 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 or Transaction Processing
template. Click Next.
|
| 6. |
On the Database Identification window, enter a Global
Database Name and SID. Click Next.
Note: If you created a database as
part of your installation of the Oracle software and you are creating
a second database with DBCA (as in this example), you must choose a different
global database name and SID for your second database.
|
| 7. |
The Management Options window appears. To use Enterprise Manager, select
Configure Enterprise Manager. Select Configure Database Control
for local management to manage your database locally as appropriate
to your configuration. Click Next.
|
| 8. |
On the Database Credentials window, you can choose to use different administrative
passwords or use the same password for all accounts. Select one of the
options and enter your password data. Click Next.
|
| 9. |
For storage options, 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 Specify Flash Recovery Area and enter 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 Next.
|
| 13. |
The Memory window appears. Select Typical and enter a Memory Size
(SGA and PGA). Click the Sizing tab.
|
| 14. |
The Sizing window 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 Sets tab.
|
| 15. |
The Character Sets window appears. Select the character set for your
database. Click the Connection Mode tab.
|
| 16. |
The Connection Mode window appears. Select Dedicated Server Mode
or Shared Server Mode as appropriate for your environment. Click
Next.
|
| 17. |
The Security Settings window appears. Accept the default value and click
Next.
|
| 18. |
The Automatic Maintenance Tasks window appears. On this window you can
configure the database to automatically manage maintenance tasks. Select
the Enable automatic maintenance tasks option. Click Next.
|
| 19. |
On the Database Storage window, you can specify storage parameters for
the database creation. Accept the default values. Click Next.
|
| 20. |
On the Creation Options window, select Create Database to create
your database. You can also select Save as a Database Template
to save your configuration. Click Finish.
|
| 21. |
At the Confirmation window, confirm the options that will be installed
and click OK.
|
| 22. |
Your database is now being created.
After the database is created, you can change or unlock your passwords
or click Exit.
|
Back to Topic List
In this tutorial, you learned how to:
 |
Install the basic version of the database. |
|
Install the advanced version of the database
including running the Database Configuration Assistant. |
|
Create a database using the Database Configuration
Assistant. |
Back to Topic List
Place the cursor over this icon to hide all screenshots.
|
Bookmark
