Home > Oracle > Oracle 11g R2 x64 Windows 2008 R2 Installation Walkthrough.

Oracle 11g R2 x64 Windows 2008 R2 Installation Walkthrough.

1. Introduction

You need to download the setup zip files from the Oracle website.The file names are:

1. win64_11gR2_database_1of2.zip
2. win64_11gR2_database_2of2.zip

Once you have the Windows 2008 R2 x64 setup copy these file to the “D:” drive (etc.) and you can install 7zip (etc.) to unzip the two compressed files.

NOTES: My test environment was:

Windows 2008×64 Hyper-V, with two virtual hard disks and 1512 MB RAM to host the OS and install Oracle.

It is recommended you read through the complete Oracle 11g R2 x64 Windows 2008 R2 Installation Walkthrough steps once before you proceed with you installation.

You need to combine the archives before you proceed ,One easy way you can combine both archives  into one by coping/moving the contents of the second zip archive into the extracted folder of the first as shown in the below screenshots.Else you may get missing file if you run the setup.exe as show in the last two screenshots of this walkthrough.

 

2. Installation Walkthrough

Click the setup.exe to begin the installation.

Installation splash screen…

You can skip the email information part if needed.

Click the Yes Button to continue without the email setting.

Select the first option “Create and configure a database” to start installation, click the Next  Button to continue.

Select Server Class option to install the Server Configuration and click Next Button to continue.

Select Single instance database installation and click Next Button to continue.

Select the Advanced Install and click the Next Button to continue.

Select the languages in which your product will run.

Select Enterprise Edition and if you need to change any options click the Select Options Button to continue.

Select Enterprise Edition and if you need to change any options click the Select Options Button to continue.

Select Enterprise Edition and if you need to change any options click the Select Options Button to continue.

Select the path according to you drive names etc. and click the Next Button to continue.

Select the type of database you want to create.

You need to change the default database name and the SID so that it matches you environment.Here we have kept it same as the server name.

You need to change the default database name and the SID so that it matches you environment.Here we have kept it same as the server name.

No change was made here…

Change the database character set if you plan on multiple language support.

Change the database character set if you plan on multiple language groups.

No change was made in this step…

This was selected since we needed a sample database…

This can be changes as needed…

This can be changes as needed…

This can be changed according to your hard disk and storage configurations.

This was not changed according to your needs for back up…

You need to change your admin passwords here..

You need to change your admin passwords here.. or keep the same for all accounts depending on your need for security.

Setup Prerequisite Checks…

Setup Pre-stage Summary…

Installation progress…

Installation progress…

Installation progress…

Installation progress…

Installation completion…

Installation completion…

Setup details summary…

Setup details summary…

 

 

3. Database Configuration Assistant: Database Setup Steps.

If you check the option create database with sample schemas you’d probably get this (not 100% sure but it seems so).

4. Configuring the TNS + Web Admin Console.

Configuring the administrator website (administrator console, database control url , database management studio etc.)

 

Hey I installed everything , but how do I administer the stuff ?

 

Well apparently , I had to check the tns and network settings and dig around the internet for getting the admin console working.

 

I had to reconfigure the created database as below using the wizard as shown in the screenshots  below, you can start the Database Configuration Assistant again from Program Files and do below steps.

You may have to check the net manager if you don’t get a tns and have to reconfigure at this level if you get this message below.” Could not find appropriate listener for this database.Configuring DB control requires database to be registered with at-least one listener.”

If you make tns changes etc. It would be advisable to restart the machine.

5. Installation Errors

You may get this error if you do not copy the second archive and run the setup.exe as mentioned in the beginning of this walkthrough.

6. Post Installation Notes

  • You will find the Oracle 11G utils and other tools in the Program Files shortcut.
  • Most of the other tools are in the bin folder.
  • SQL Command Prompt is available.
  • We had difficulty getting the Admin URL to work on IE 8 on Windows 2008 R2 so installed Firefox.We got a blank page normally for the url
  • Reconfigure Oracle EM
  • Oracle 11g on Windows 7

7. Post Installation Checks

    The database control is as shown below:

    Login as sys dba to access full functionality

    Oracle Database Control

The following are the services that are available related to oracle once the installation is complete, If you do not find the OracleDBConsole_SID as shown below means that it was never installed in the first place, so you need to install it as in above walkthrough.

    Once the Database Console is install you will find the Database Control Shortcut along with the complete list of shortcuts as shown below:

8. Connecting via Oracle SQL Developer

The installation comes with a Oracle SQL Developer, the shortcut gives you the location, but you need to have Java (x64) SDK  installed if you want to run it on the server.You need to download it from the oracle or java site and give the path to jave.exe to proceed.Recommended you do it elsewhere.

 

I hope this walkthrough was useful to you.

Post Image Hosting: imgur.com

About these ads
Categories: Oracle
  1. 06/08/2012 at 1:20 AM | #1

    Great work!

  2. Anonymous
    03/09/2012 at 4:50 PM | #2

    Thanks finally got past tns error

  3. Jonaht
    15/11/2012 at 2:11 PM | #3

    wonderful step by step procedure thanks

  4. Acelimet
    15/11/2012 at 2:27 PM | #4

    So do I Jonaht, the documentation of the procedure is very well prepared … if you (metaactive) work for this (Technical Writer) must be making a fortune $ $ $ $ :)

  5. Angshuman
    08/02/2013 at 1:59 PM | #5

    Thanks a lot. Your documentation finally helped me to get past the error.

  6. Ronei
    14/07/2013 at 5:42 PM | #6

    You really helped me A LOT !
    Thank you very much !

  7. 12/09/2013 at 5:59 PM | #7

    That’s a great post, we’ve been searching for solve our installation and we could fix this.
    Other step that is missed is configure the host name int /etc/hosts and set the local ip to the DNS to connect via SQL Developer. Additionally you can view the overview for your connection on C:\app\YOURNAME\product\11.2.0\dbhome_3\NETWORK\ADMIN on .ora file.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: