Oracle 11g step-by-step Installation Guide with Screenshots

by Ramesh Natarajan on October 2, 2008

[Oracle 11g Logo]This is a 16 step Oracle 11g installation guide that covers a typical installation scenario with screenshots.

1. Select installation method

Following two installation methods are available:

  • Basic Installation – Choose this to perform the full Oracle Database 11g installation with standard configuration options. You can use only filesystem for storage in this option.
  • Advanced Installation – This gives your full control over the installation, including the ability to choose Automatic Storage Management. Select this option as shown below.

[Select Installation Method]
Fig - Select Installation Method

2. Specify Inventory directory and credentials

Enter the following information:

  • Enter the inventory directory: /u01/app/oraInventory
  • Specify operating system group name: oinstall
[Specify Inventory Directory]
Fig - Specify Inventory directory and credentials

3. Select Installation Type

Following three installation types are available:

  • Enterprise Edition – Select this option.
  • Standard Edition
  • Custom
[Select Installation Type]
Fig - Select Installation Type

4. Specify Install Location

Enter the following information:

  • Oracle Base: /u01/app/oracle
  • Name: Oracle_Home
  • Path: /u01/app/oarcle/product/11.1.0
[Specify Install Location]
Fig - Select Install Location

5. Product-Specific Prerequisite Checks

In this screen, the Installer verifies that your environment meets all of the minimum requirements for installing and configuring the products that you have chosen to install. You must manually verify and confirm the items that are flagged with warnings and items that require manual checks.

6. Select Configuration Option

Following three configuration options are available:

  • Create a Database – Select this option.
  • Configure Automatic Storage Management (ASM)
  • Install Software Only
[Select Configuration Option]
Fig - Select Configuration Option

7. Select a Database Configuration

Following three database configuration options are available.

  • General Purpose/Transaction Processing – Select this option.
  • Data Warehouse
  • Advanced
[Select Database Configuration]
Fig - Select Database Configuration

8. Specify Database Configuration

Enter the following information:

  • Global Database Name: devdb.example.com . An Oracle database is uniquely identified by a Global Database Name, typically of the form “name.domain”
  • SID: devdb

9. Specify Database Configuration Details

There are four different tabs in this screen as shown below:

  • Memory Tab
    • Select the check-box to Enable Automatic Memory Management
    • Drag the bar to allocate the memory. This will automatically allocate memory size for SGA and PGA depending on the total database memory allocated.
  • Character Sets Tab. Following three character set options are given in this tab.
    • Use the default
    • Use Unicode (AL32UTF8)
    • Choose from the list of character sets.  Select Database Character Set as Unicode standard UTF-8AL32UTF8 – Select this option.
  • Security Tab – Just leave the defaults in this tab.
  • Sample Schema Tab – Just leave the defaults in this tab.
[Specify Config Details for Memory]
Fig - Select Database Config Details with Memory Tab

10. Select Database Management Option

Following two management options are available:

  • Use Grid Control for Database Management
    • Management Service: Choose an agent.
  • Use Database Control for Database Management- Select this option.
    • Select the check-box to Enable Email Notifications
    • Outgoing mail (SMTP) Server:
    • Email Address:
[Select DB Management Option]
Fig - Select Database Management Option

11. Specify Database Storage Option

Following two storage options are available:

  • File System – Select this option.
    • Specify Database File location: /u01/app/oracle/oradata/
  • Automatic Storage Management. ASM simplifies database storage administration and optimizes database layout for I/O performance.

12. Specify Backup and Recovery Option

Enable automated backup as shown below. If you’ve configured ASM, you can choose to store the automated backups on ASM. If not, select File System option.

[Specify Backup Recovery Option]
Fig - Specify Backup and Recovery Options

13. Specify database schema password

Enter the password for sys, system, sysman, dbsnmp schemas. You have the option of either using the same passwords or different password for all the accounts in this screen.

14. Privileged Operating System Groups

Enter the following information in this screen:

  • Database Administrator (OSDBA) Group: dba
  • Database Operator (OSOPER) Group: dba
  • ASM administrator (OSASM) Group: dba

15. Oracle Configuration Manager Registration

You can associate your configration information with your metalink account as shown below.

[Oracle Configuration Manager]
Fig - Oracle Configuration Manager Registration

16. Final Summary Screen

This will display a summary of all the installation option you’ve selected so far. Click on Install to complete the installation.

[Install Summary Screen]
Fig - Installation Summary Screen


If you liked this article, please bookmark it on del.icio.us and Stumble it.

Download Free eBook - Linux 101 Hacks

Get free Unix tutorials, tips and tricks straight to your email in-box.

If you enjoyed this article, you might also like..

  1. Jumpstart Guide for Oracle Enterprise Linux with Screenshots
  2. Fedora 9 Sulphur step-by-step installation guide with screenshots
  3. Step-by-Step Guide to Configure Hardware RAID on DELL servers with Screenshots
  4. Step-By-Step Guide To Upgrade Ubuntu 9.04 to 9.10 With Screenshots – Jaunty Jackalope To Karmic Koala
  5. Step-By-Step Guide To Upgrade Ubuntu 8.04 To 8.10 With Screenshots – Hardy Heron To Intrepid Ibex
   

Vim 101 Hacks Book

{ 9 comments… read them below or add one }

1 Swapnil July 27, 2009 at 7:23 am

it is a very nice step-by-step tutorial, I got stuck with character set problem when working on Oracle 11g Install for SOA Suite, Thanks.

2 harjot August 26, 2009 at 2:17 am

its very good for installation but i have a error : “ORA 12560 TNS ADAPTER protocol error” while creating Database. so can u plz tell me how to solve this error

3 U.Ravi Kumar December 3, 2009 at 3:33 am

Excellent step by step guide on installing Oracle 11g. Thanks a lot.

4 Anand December 15, 2009 at 8:51 am

ThankYou

5 jothi January 18, 2010 at 2:02 am

Hi friends

It’s a very good guide. After the installation , when i start the oracle, it ask me about the java.exe file location. I d’t know what is it ? anyone help me pls.

jothi
jothi@pibginternational.com

6 Rizwan Ranjha January 22, 2010 at 6:19 am

Hey, nice working guy, but I need some auto Installation method with a script or something that can help me to deploy on larg number of computers.
Thanks

7 Brave Ali Khatri February 24, 2010 at 12:26 am

Hay Jothi,

Click on SQL developer then click on Browse then give the java,exe location By default it is in Program file/java/jdk1.6/bin you need to install JDK .

Regards

Bahadur ali

8 sanjeev akki March 6, 2010 at 12:16 pm

Hi All,

I’m trying to install oracle 11g on windows7 Home edition.

Oracle 11g installation is successful, but how should i connect to oracle.

In oracle9i we used Scott as username and tiger as password.
which username and password should be used to log in to oracle11g.
it is also asking me to certify by clicking on this.
https:sanjeev-pc:1158em link
But when i click on this link
It will re-direct me to this page…
http://www.ask.com/web?o=13701&l=dis&q=https:sanjeev-pc:1158em...

Please let me know what should i do?

I followed the steps mentioned in the link mentioned below

http://www.thegeekstuff.com/2008/10/oracle-11g-step-by-step-installation-guide-with-screenshots/

9 abhishek March 6, 2010 at 1:17 pm

sir,
please ,help me to install the orcale 11 g for home client there show the
java.exe path…. plz help me how i provide it.

Leave a Comment

Previous post:

Next post: