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.

Note: Since there are several screenshots of various Oracle installation steps on this page, I’ve shown only the thumbnails of the screenshot. Click on the individual thumbnail image to view the full-size screenshot of a particular Oracle installation step.

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

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 (Click on the image to enlarge it)

Linux Sysadmin Course Linux provides several powerful administrative tools and utilities which will help you to manage your systems effectively. If you don’t know what these tools are and how to use them, you could be spending lot of time trying to perform even the basic administrative tasks. The focus of this course is to help you understand system administration tools, which will help you to become an effective Linux system administrator.
Get the Linux Sysadmin Course Now!

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

  1. 50 Linux Sysadmin Tutorials
  2. 50 Most Frequently Used Linux Commands (With Examples)
  3. Top 25 Best Linux Performance Monitoring and Debugging Tools
  4. Mommy, I found it! – 15 Practical Linux Find Command Examples
  5. Linux 101 Hacks 2nd Edition eBook Linux 101 Hacks Book

Bash 101 Hacks Book Sed and Awk 101 Hacks Book Nagios Core 3 Book Vim 101 Hacks Book

{ 93 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

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.

10 lugad March 19, 2010 at 8:56 am

Hi everybody i am newly certified oracle OCA, planning to soon OCP soon Iam lacking practical side as i did this course in Africa. Therefore what would advice me to do? Iam thinking going to India for three Months in order to get more practical then words, I also need help a good institute in india specially in Hyderbad.

11 amol March 26, 2010 at 3:18 pm

hi,
i have install oracal11g in my PC . setup gets finish properly but while opening SQL dlevepor , it ask the ( JAVA.EXE path) i cant find it plz help me .

12 Baloch April 26, 2010 at 12:12 am

Perfect job

13 Amit Thawait May 8, 2010 at 8:54 pm

Its awesome. Really helpful.

14 srinivas June 5, 2010 at 1:48 pm

thankyou very much.

15 rakesh June 18, 2010 at 6:13 am

hey amol you have to install java jdk 6.0 in your machine
then browse the file.
it will be in program files in windows. as of now i did not start oracle in linux. when i do it i’ll let you know.
if anyone else know the solution please mention
thankyou

16 Abdullah July 19, 2010 at 7:00 am

hi all
my comments are below
i want to learn oracle 11g but i also don’t know about the Recovery Methods
as well in oracle 10g pls send me the full details in my email thank you

With Kind Regards,
Abdullah Salimi

17 Abdullah July 19, 2010 at 7:05 am

Respected Sir,
Please help me to install oracle 11g in home client
please send me the details method in my mentioned email
my emil address is … i shall be very thankful to you for this kindness
Best Regards,
Abdullah Salimi

18 vinoth August 2, 2010 at 8:26 am

good work man……………keep it up.

19 Simran August 20, 2010 at 6:30 pm

Very helpful.Complete step by step procedure.Thanks for posting.

20 sundeep patel August 27, 2010 at 8:18 am

very cool. easy understanding

21 Abhishek Kumar September 15, 2010 at 5:37 am

thanks

22 Hafiz September 27, 2010 at 10:11 am

hello thanks it really helped me ………… but i have problem in installation of the oracle 11g form ( developer ) please post it here too or send me the link where its method is shown thanks

23 subrata satapathy September 28, 2010 at 11:12 pm

sir,i installed oracle11g on my windows7 64bit computer successfully.But i forgot to copy the database control url(isql plus url).Now how can i find out the url to connect toisql plus.Please help.

24 raju October 10, 2010 at 11:50 am

after installing .. while entering user/password it shows that the access is locked… then wt to do?

25 uwafoo October 18, 2010 at 10:06 pm

After installing oracle Developer, I try to enter user/password it shows that the access is locked, what do I have to do next to be able to use Sql

Thanks
Uwafoo
.

26 abrar khan imdad khan December 22, 2010 at 2:14 am

Sir how to install sunsolaris. and oracle software

27 William Saw December 23, 2010 at 10:32 pm

I am installing Oracle 11gR2 at HP-UX 11.31 Itanium. Installation location is on Netapp NFS volume. During the creation stage, I encounter below issue:

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

I have tried various mount option but still the same.

28 Danica January 1, 2011 at 4:50 pm

Hi Guys
I installed oracle 11g, when I started the Cmd under appl development :SQL Plus, it is asking user name and pw, but while installing , I remember that it asked me only password twice, hot to log in, how to get user id? scott, tiger is locked (os:vista homepremium, hp laptop, oracle 11g)
You will be greatly appreciated for the help
Danica

29 Sridhar January 24, 2011 at 12:27 pm

Thanks a lot ! This was very useful.

30 behrooz January 29, 2011 at 12:02 pm

Very helpful !Thanks a lot

31 Shaik Mohsin Ahmed March 2, 2011 at 8:59 am

very nice job.

could you pls send me the information regarding the table spacing
and migrating 9i to 11g database

Thnks & Rgds,

32 Vaibhav March 8, 2011 at 3:35 am

Thanks buddy it helped me alot. i just got tired doin it myself again and again….

33 Mahe March 11, 2011 at 2:56 am

Good morning fellow DBA,
pls i just wanna know three things about oracle software installation on three different operating system such as vista, xp, 7. why the conflict when using one oracle software with different OS. THANK U.

34 dhanunjay April 14, 2011 at 5:19 am

This is very wonderful for us to give the installation procedure thus every one can follow the procedure very easily and in quick manner.

35 ace April 20, 2011 at 8:18 pm

Thank you for the guide. I followed all steps, however, the installation window closes as soon as I hit the Install button. Any suggestions??

36 Arbind Negi May 18, 2011 at 1:21 am

HI All,

i have install oracle 11g on my laptop. it was successfully install. when i am browsing the java.exe path from my jdk folder it does nothing. any one kanow about this problem please let me know

37 pavithra June 1, 2011 at 2:44 am

i was installed oracle-11g.but its showing account is locked…..plz any one reply me what should i do……..

38 Hussein June 5, 2011 at 7:52 am

Is there any solution for installing oracle-11g on windows server 2008 32bit with domain controller ???
I want solution other than delete the domain controller
pleaaaaaaaze help meeeeeeeee

39 Hassan June 20, 2011 at 6:47 am

thanks
This is realy very nice

40 Thomas July 1, 2011 at 7:25 am

Hey,

We tried to install Oracle 11g onto our domain controller, and we get the error message: ORA-12560: TNS:protocol adapter error. Really not sure what to do with this, we’ve tried it a few times but it always gets stuck just after it copies the files onto the conputer. Any help would be really appreiciated! (Btw, trying to install it onto a 2008 server if that makes any differemce!)

41 Paras July 6, 2011 at 4:41 am

Sir
i tried install to this method but got some error like system requirement.

42 Anonymous July 26, 2011 at 9:46 pm

This is beautiful guide really good> Thanks

43 Nitin August 6, 2011 at 12:30 pm

Nice one ….good job…..well done

44 stefan August 6, 2011 at 1:54 pm

very well done tutorial

45 vijay August 16, 2011 at 7:37 am

can any one tell how to create edit buffer for oracle 10g express edition

46 Ashwin August 20, 2011 at 8:07 am

Hey,

We tried to install Oracle 11g onto our domain controller, and we get the error message: ORA-12560: TNS:protocol adapter error. Really not sure what to do with this, we’ve tried it a few times but it always gets stuck just after it copies the files onto the conputer. Any help would be really appreiciated!

47 Ashwin August 20, 2011 at 8:10 am

Hey,

We tried to install Oracle 11g onto our domain controller, and we get the error message: ORA-12560: TNS:protocol adapter error. Really not sure what to do with this, we’ve tried it a few times but it always gets stuck just after it copies the files onto the conputer. In sql developer it also says network adapter could not establish the connection Vendor Code:20.I really can’t understand this.Any help would be really appreiciated!.

48 Ashok Kumar September 10, 2011 at 3:27 pm

Hi All.

I have tried to install Oracle 10g on windows 7. I got the error message TNS access denied and even for 11g also i got the same error. Can some one please let me know what needs to be done. Please assistance.

and even how to install 11g on ubuntu please share the knowledge. Thanks in advance.

Ashok Kumar

49 ganesh kangane September 16, 2011 at 3:06 am

Hey,

We tried to install Oracle 11g onto our domain controller, and we get the error message: ORA-12560: TNS:protocol adapter error. Really not sure what to do with this, we’ve tried it a few times but it always gets stuck just after it copies the files onto the conputer. Any help would be really appreiciated!

50 boddeti janardhan September 22, 2011 at 6:08 am

It is very good have this kind of material

51 chinni krishna October 30, 2011 at 12:48 pm

well done good job.

52 Aneeta November 7, 2011 at 10:36 am

Excellent article. Does anyone know some website that i can self-teach myself Oracle DBA 11g? I had found one a year ago but cannot find it now.

Will appreciate your assistance.

53 Dehan November 13, 2011 at 4:01 am

can any one tell how to create professional database in Linux (DB Size 16 GB)
what kind of things i will consider

54 vinod November 15, 2011 at 11:38 pm

Hi,

Very nice HowTo …I tried Installing 10g the same way on solaris SPARC 64 & all sees well except that the Enterprice Manager fails to start…
Please let me know where to look for to get the EM up.

Thanks
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://b-zone.dikshapraya.blr:1158/em/console/aboutApplication
ps: unknown output format: -o cmd
ps: illegal option — cols
usage: ps [ -aAdeflcjLPyZ ] [ -o format ] [ -t termlist ]
[ -u userlist ] [ -U userlist ] [ -G grouplist ]
[ -p proclist ] [ -g pgrplist ] [ -s sidlist ] [ -z zonelist ]
‘format’ is one or more of:
user ruser group rgroup uid ruid gid rgid pid ppid pgid sid taskid ctid
pri opri pcpu pmem vsz rss osz nice class time etime stime zone zoneid
f s c lwp nlwp psr tty addr wchan fname comm args projid project pset
Starting Oracle Enterprise Manager 10g Database Control ………………………………………………………………………………… failed.
——————————————————————
Logs are generated in directory /export/oracle/product/10.2.0/Db_1/b-zone.dikshapraya.blr_orcl/sysman/log

55 Gabriela November 22, 2011 at 1:47 pm

Hi guys,

During installation, if they have seen the error ORA-12560, should verify the configuration of the Oracle instance you want to connect, try the following:

set ORACLE_SID=

and then try again. If this works then consider whether to make the change permanent by specifying it as a system variable.

FOR RUN THIS SID PLEASE REFER IT
Go to command prompt

C:\Document and settings\ORANGE> cd\
C:\> set oracle_sid=
e.g C:\> set oracle_sid= {press enter}
C:\> sqlplus /nolog {press enter}
sql:\>connect sys/sys as sysdba {press enter} it cant ask for password directly connected
or
sql:\>connect sys as sysdba {press enter}
password : sys {press enter}
sql:\> connected
or
sql:\> connect scott {press enter}
Enter password :tiger {press enter}
sql:\> connected
or
sql:\> connect system {press enter}
Enter password :manager {press enter}
sql:\> connected

56 Prashanth S Nilekani November 24, 2011 at 6:43 am

it is nice to use….. i really satisfied…

57 thika subber December 9, 2011 at 11:00 am

thank you vvvvvvvvvvvvvvvvvvvvvvvery much i’m thika from iraq
so much clearly

58 swapna January 9, 2012 at 11:08 pm

from wer i can download this setup.

59 Kwesi January 20, 2012 at 2:14 am

am new at using Oracle. thanks guys i came here for one reason, but i have really learnt a lot.
keep up the good work.

60 Amar January 25, 2012 at 12:30 pm

m having problem of TNS protocol error in oracle 10g…
i hav tried all pssble wayzzz for fixing this problem bt its still the same…
plz help me gyuzzz

61 satya March 8, 2012 at 9:58 am

hi,

i dont’ know oracle11g default username and password, please tell me other than scott and tiger.
please send me ur answers any thing

62 Sadashiv March 12, 2012 at 5:53 am

Sir I am new to this field so please can you send me some oracle form and report tutorial links so that I will go through it.

Thanks and Regards-
Sadashiv

63 Sankara Rao April 8, 2012 at 1:48 pm

HI Guys,
It is Good installation Guide and step-By-step screen shorts are very cleared

Thanks and Regards
Sankar

64 Sharad April 9, 2012 at 9:58 am

Sorry for stupid question…..for which OS is this tutorial for?

65 anik April 24, 2012 at 8:07 am

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

66 khan May 8, 2012 at 9:49 am

i am getting ‘tns-prorocol adapter error’ after entering username and password in sql plus…i have oracle 11g version…
thanks n regards

67 gbenga May 24, 2012 at 6:32 am

while installing i encountered an error msg @ 89% dat the dbca can not start the db control console and after completion cannot find the oracle-OraDB11g_home1 in the program file.

68 venky June 8, 2012 at 12:05 am

thnk uuuuuuuuuuuuuuuuuuuuuuuuu sooooooooooo much sirrrrrrrrrrrrrrrrrr

69 Preity June 21, 2012 at 11:15 am

Awesome!!! it helped me alot ………….thanku so much:-):-)

70 chandu July 10, 2012 at 10:53 am

m having problem of TNS protocol error in oracle 10g…
i hav tried all pssble wayzzz for fixing this problem bt its still the same…
plz help me gyuzzz

71 Anonymous July 15, 2012 at 6:41 am

where i get software free for oracle11g

72 Akbar July 20, 2012 at 12:33 am

Please let me know whats the URL to install Oracle 11g for windows XP 32 bit …
Thanks
Akbar Hussain

73 Punnit August 20, 2012 at 1:35 pm

Hi All,

Need your help guys…
I have installed oracle 11g on windows 7, everything is working fine… Rite now I am just facing 1 problem and i.e. as follows…..

When I login my username and password in SQL PLUS that time I am getting an error of ora-01017: invalid username/password: logon denied.

Actually the problem is I am able to enter the username, but when it comes to password I am just not able to type my password…. (It doesnot take any input while entering the password, it remains blank even if I type the password). I am not exactly understanding what the problem is…

Rite now I have JDK 6.0 installed on my PC… Is it a java problem..??? Should I install a higher update of java.. (18, 27 or 31).. I am not understanding the root cause of this problem… Plz help me…

Thanks,
Punnit.

74 Anonymous August 22, 2012 at 4:36 am

Actually the password section doesn’t show any thing while we type. It is just like that and not a problem with the installation or java version.

75 Punnit August 22, 2012 at 10:04 am

Hi,

Thanks for the reply… Bt the problem is that, I am getting an error… ora-01017: invalid username/password: logon denied and I have entered the username as sysdba and also entered correct password which i had set at the time of installation….

So can u help me with what exactly i am missing.. is it that I am using some wrong username…???? Any suggestions or help will be appreciated….

Regards,

Punnit.

76 Abhinav ray September 8, 2012 at 11:39 pm

Please sir give step by step instillation guide……

How to install oracle-11gR2 in redhat 6.0 …

77 Adeel September 9, 2012 at 2:16 am

Very Helpful and time saving

78 venkatesh November 19, 2012 at 11:29 pm

how to open editor in oracle 11g ,if anybody knows please help me
thankqq

79 PANHA December 20, 2012 at 1:55 am

Very good ! easy to understand .

80 guhan March 22, 2013 at 7:01 am

can I work sql commands in this?

81 yashu May 5, 2013 at 7:59 pm

can we use oracle 11g with dot net as a front end

82 Rahamad June 27, 2013 at 2:22 pm

TNS :invalid argument…………….error I m getting whe I wanted to connect to sql plus.
please help me
one more error: Unable to fiend java virtual machine……when I tried to connect Oracle SQL developer

83 Karthik July 19, 2013 at 9:53 am

Nice work dude

84 rahima July 30, 2013 at 8:12 pm

nice solution……………….

85 murali thilak dasa August 20, 2013 at 6:26 am

how to install the oracle 11g version. i dont know how to start the process. any one please tell me the process how to install the oracle 11g steps

86 krishna December 9, 2013 at 1:35 pm

which operating system is best for practice?

87 S A Patel December 14, 2013 at 4:14 am

Thanks and regards,

88 vinod kumar December 17, 2013 at 10:24 pm

can you provide installation grid in oracle 10g in windows xp 32 bit

89 hemanth January 3, 2014 at 3:55 pm

hi friends,after installation of Oracle11g in windows7 my laptop became very very slow.what will i do for getting fast and please give the reply of which OS is the best for practicing?

90 Guutuu January 16, 2014 at 10:30 am

Good and Best!!!

91 sangam February 19, 2014 at 10:45 am

plz send my email id oracle id and password!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

92 madhumita ghosh March 16, 2014 at 4:36 am

guys,
i tried to install oracle 11g express edition but i am facing a problem while installing it..

during “checking for system requirements”
1)checking operating system requirements— succeeded
2)checking administrator privileges for current logged in user— succeeded
3)”checking for oracle XE service instance—-FAILED”

IT SAYS oracle service XE is found on system. :(

what to do?? Please reply

93 shashi June 10, 2014 at 10:02 pm

Thanks a lot, very informative.

Leave a Comment

Previous post:

Next post: