Oracle Database 11g R2 Installation

Hello All ….Welcome Back after long time !! The tale of new journey begins… 🙂

So … prior to setup and configure new OBIEE 11g version (The Fusion Middleware  , RCU setup etc) the prerequisite must be completed . And here comes Oracle 11g R2 installation .

The configuration for my system as below :

RAM: DDR2 4 GB 667 MHz bus speed.

CPU: Intel Core 2 Duo 2.33GHz.

Hardware Cache : 4 MB L2 Cache

OS : Windows XP Professional Version 2002 – Service Pack 3

Firewall : Zonealarm

Step 1: I have downloaded Oracle 11g R2 Server version from OTN :

The content downloaded for 32 bit windows for setup in Windows XP like as below :

The downloaded content looks like below:

Step 2: Execute the “setup.exe” file .

It starts to check and validate the pre-requisite …

Step 3: Configuring security Updates

Step 4: Since I want a starter database to be installed and configured hence choose option 1

otherwise see the tooltip option which is suitable for your need if you want to upgrade from existing DB or want to install DB binaries only …

Step 5: Choose the system class . In my case it will be desktop class system .

Step 6: Configure basic parameters ….

Click “Next” and it will perform some basic checks about validating Memory , Space left at the target location , Swap Memory size , Global variable and PATH , Environment variables etc ….

Step 7: Save the response file if you would like to resume the same configuration and setup later using command line parameters …Just kickoff the installation by ‘Finish’ .

Step 8: The progress bar started continuing the installation and copying the required files.

The database creation initiates :

Note: If you have firewall configuration to protect any application accessing Internet , you can see several applications (sqlplus.exe , perl.exe , tnsping.exe ,java.exe , javaw.exe,emdctl.exe,emagent.exe,nmzctl.exe and others) would be trying to access Internet and the default loop back IP address .Just allow all of them in the firewall configuration.

Step 9: Oracle 11g R2 database installation completed .

Step 10: I prefer unlocking password for ‘HR’ , ‘BI’ ,’SCOTT’ schema and define passwords for SYS,SYTEM as ‘Sys12345’ and ‘SCOTT’ as tiger. Click OK after that .

Step 11: The installation has been done and the Enterprise manager DB console can be accessible through URL : https://localhost:1158/em .In my configuration it would take ~ 45 Minutes .


Step 12: Just validate the OEM access using the above URL :

Step 13: OEM Homepage for the instance DB instance ‘Oradeba’ as below :

N.B :- Use ‘SYSTEM’ account for Connect As Normal rather as ‘SYSDBA’ .

Finally I have done with Oracle 11gR2 Installation.


Step by Step Upgrading Oracle 10g to Oracle 11g

Hell ! Yes , my Oracle 10g in Windows XP SP2 is the older one i.e which doesn’t Support the SOA Suite installation . Oracle suggest to upgrade this to 10R2 ( or higher ) . But bit lethargic about this upgrade as I do have to again download the Patch from Metalink  i.e of  size ~972 MB . Since I have had Oracle 11g installer so best possible option is to throw my Oracle 10g DB and install 11g afresh . But again the pain is to export all Db objects and again import into new DB .What if the new DB failed to import in 11g ? What if there is Unicode/Non-Unicode character set incompatibility occurs ? I know patchset available but I can’t rely on my knowledge about applying those pathset successfully !

After lots of brainstorming the final thought come is that there might be some way to upgrade the DB from already installed 10g to 11g using the available installer rather using the upgrade patchset for 11g. So finally kickoff  11g installation after executing the setup file and follow the onscreen instruction step by step .

Here you goes …

Oracle 11g Install-1

Oracle 11g Install-2


Oracle 11g Install-3Oracle 11g Install-4

Oracle 11g Install-5Oracle 11g Install-6

Oracle 11g Install-7Oracle 11g Install-8

Oracle 11g Install-9 Oracle 11g Install-10


So I have installed 11g softwares without having any Database . My aim is to upgrade the existing 10g instance as 11g .

1) Copy file : utlu111i.sql to d:\temp (any temporary location) from “D:\Oradb11g\RDBMS\ADMIN” .

2) Connected into Oracle 10g instance while DB is up and running and execute the .sql file from SQL prompt and get the below stat .

Oracle 11g Install-11

Oracle 11g Install-12

Oracle 11g Install-13

3) To resolve the below warning :

WARNING: –> Database is using an old timezone file version.
…. Patch the database to timezone file version 4
…. BEFORE upgrading the database. Re-run utlu111i.sql after
…. patching the database to record the new timezone file version.

Execute :

SQL> select * from v$timezone_file;

WHEN 183 then 1
WHEN 355 then 1
WHEN 347 then 1
WHEN 377 then 2
WHEN 186 then case COUNT(tzname) WHEN 636 then 2 WHEN 626 then 3 ELSE 0 end
WHEN 185 then 3
WHEN 386 then 3
WHEN 387 then case COUNT(tzname) WHEN 1438 then 3 ELSE 0 end
WHEN 391 then case COUNT(tzname) WHEN 1457 then 4 ELSE 0 end
WHEN 392 then case COUNT(tzname) WHEN 1458 then 4 ELSE 0 end
WHEN 188 then case COUNT(tzname) WHEN 637 then 4 ELSE 0 end
WHEN 189 then case COUNT(tzname) WHEN 638 then 4 ELSE 0 end
FROM v$timezone_names;

Oracle 11g Install-14

If the output of this is < 4 then prior to upgrade we need to apply the Timezone patch .So I need to apply it prior to go ahead . For my Windows 32 bit the patch(5731187) could be found at Metalink.

Download the file : and un-archive to location as : D:\temp\5731187 .

4) Copy the files from location : D:\temp\5731187\files\oracore\zoneinfo and paste it to existing Oracle 10g location “D:\oracle\oracore\zoneinfo” . Make sure to keep backup of existing folder so that you  could revert if any problem occurs .

5) Stop the DB instance and Start . After that execute Step 2&3 again and the warning should be removed and timzone file version should be upgraded. Otherwise assist Oracle Support .

6) To remove below warning execute the below command from sysdba users .

WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 11g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS

Gather Dictionary stats:

Connect as sys user and gather statistics


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

7) I skip the other warnings .To avoid showing other warnings use Oracle Documentation about Pre-Upgrade Information

Final) Now lets perform the Database upgrade steps using : Database Upgrade Assistant(DBUA) a GUI to upgrade the DB and it can be found under Start -) All Programs -) Oracle 11g Home -) Configuration and Migration Tool and follow through the onscreen steps ….

Upgrade 10g to 11g using DBUA - 0

Upgrade 10g to 11g using DBUA - 1Upgrade 10g to 11g using DBUA - 2

Upgrade 10g to 11g using DBUA - 3

Upgrade 10g to 11g using DBUA - 4

Upgrade 10g to 11g using DBUA - 5

Upgrade 10g to 11g using DBUA - 6Upgrade 10g to 11g using DBUA - 7

Upgrade 10g to 11g using DBUA - 8Upgrade 10g to 11g using DBUA - 9

Upgrade 10g to 11g using DBUA - 10Upgrade 10g to 11g using DBUA - 11

Upgrade 10g to 11g using DBUA - 12Upgrade 10g to 11g using DBUA - 13

Upgrade 10g to 11g using DBUA - 14

N.B : You if are interested about the Manual upgradation using the scripts rather using the DBUA you can take the reference of onlineappsdba or Advait Blog .

After running for quite a long time (more than ~1 hr) the upgrade finishes . But alas ! life is no longer easy and another problem crops up .Enterprise Manager console is not getting configured as  there are some problem with 11g TNS service .Apart from this, everything looks fine after post upgradation messages ! 🙂

Oracle 11g Install-15

Oracle 11g Install-16

So lets wash hands and think more . The problem was I supposed to delete the Oracle11g TNS Service for 11g from Windows Registry after Software installation only and before creating the DB using DBUA .That is the reason why the TNS fails and this inturn cause the configuration failure for EMCA . The nuisance created by me and need to solve by me only 😦 . This problem might not crops up in your case ,I suppose .Otherwise follow the below steps to create the TNS . Run the “Net Configuration Assistant” from Program files OracleHome entry of start menu .Otherwise run : D:\Oradb11g\bin\launch.exe .

Create the TNS service is pretty easy there .Add new service with a name and the entry will be added automatically in Windows service list . Check by running : services.msc from Windows Run option .

N.B : Dont try to tweak registry and copy 10g TNS listener or modify it to point to 11g . Its pretty hard believe me until you dont know the impact in Windows Heart … i.e at Registry ! Also don’t try to create service manually by using sc.exe windows utility . Rely on Oracle Native Net Config Assistant all time 🙂

Hence … My Oracle 11g TNS is ready …DB is up and running fine…See below :

Oracle 11g Install-17

Now lets resolve the problem of EMCA.Follow the below command line utilities to drop the Enterprise Manager Repository and reconfigure it .Its pretty simple …again if you know the right way of doing it and finally reconfigure it .

Oracle 11g Install-18Oracle 11g Install-19

Oracle 11g Install-20

And finally all is done and lets Cheers ! 🙂 🙂 🙂

Oracle 11g Install-21

Oracle 11g Install-22

Oracle 11g 64-Bit on Windows 7 Ultimate 64-Bit

Oracle 11g will still functional and run properly on Windows 7 Ultimate edition version and its pretty cool . Though I have install it in 32 bit machine but this is okay with 64 bit as well . See below from “An Expert’s Guide to Oracle Technology”

TOAD Compatibility with Oracle 11g

Though Oracle 11g post installation brings SQL Developer by default, still till now, nothing can think of apart from working on  TOAD , a famous GUI for running SQL/PL-SQL and doing hell lot of other Admin and developer related jobs automatically without writing SQL’s ( This has now a trade-off , we are forgetting Syntax !!! 😦 )

Anyways tried TOAD 8.5.3 in Oracle 11g ….. but its a misnomer … this version of TOAD is not functional with latest OCI for 11g ….. See its objections …. However the OCI version is recognized ..

TOAD Error

So I just un-installed TOAD 8.5.3 … and goggling around to get a Crack version of latest TOAD 9.6  … Voila landed on my favorite  torrent site and downloaded TOAD 9.6 version…. Its working pretty good now ….

So finally everything is in proper place now to explore something really good in OBIEE …

Lets move on ….