Window Version: windows server 2012 64 bit

And download oracle client(11.2.0.4) 64 bit which is p13340platform4of7.zip. It's free to develop, deploy, and distribute; In this post we will cover how to download and install the oracle 11g client on windows for 32 and 64 bit installations. The 11.2.0.4 release of OWB containing the 32 bit and 64 bit standalone Windows client is released today, I had previously blogged about the Linux standalone client here. Big thanks to Anil for spearheading that, another milestone on the Data Integration roadmap. This is the terminal release of OWB and customer bugs will be resolved on top of. Oracle client 11.2.0.4 download 64 bit. Download and install prior to installing Oracle Real Application Clusters, Oracle Real Application Clusters One Node, or other Oracle software in a Grid Environment Oracle Database Gateways 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64 Installation d'Instant Client pour Microsoft Windows 64 bits.

Oracle Database Version:11.2.0.1 standard edition 64 bit

Downloaded Oracle Software: 11.2.0.4 64 Bit for Windows

Install 11.2.0.4 Oracle Software only on a different home
Take existing database and binaries backup.

After Installing 11.2.0.4 RUN the below script
@ d:/oracle/11.2.0.1/db_1/rdbms /admin/utlrp.sql //object recompilation
(SQL> spool D:preupgrade.txt)

4. Go to 11.2.0.1 database and run Pre-check script of 11.2.0.4

SQL> @d:/oracle/11.2.0.4/db_1/rdbms /admin/utlu112i.sql //precheck script

(SQL> spool off)

5. Copy the following Files to New Home 11.2.0.4 :
1. Spfile/Pfile/init.ora
2. orapwd
3. tnsname.ora
4. Listener.ora

6.Shutdown the existing database

7. oradim -delete –sid XYZ2 //delete the current service

//create new service —-mention path and name of the file copied
oradim -new -sid XYZ2 -startmode auto -pfile

Set The environment to 11.2.0.4
Set ORACLE_HOME=D:oracle/prouct/11.2.0.4
Set ORACLE_SID=XYZ1

9.Rename the old oracle home parameter files

connect to sqlplus / as sysdba

<SQL>startup upgrade //sets initialization parameters necessary for upgradation

a:-select comp_name,version,status from dba_registry where status != ‘VALID’;
select owner,count(*) from dba_objects where status != ‘VALID’ group by owner;

b:-@ d:/oracle/11.2.0.4/db_1/rdbms /admin/utlrp.sql //object recompilation
@d:/oracle/11.2.0.1/db_1/rdbms/admin/catupgrd.sql // (metadata upgrade)

DB WILL BE SHUT DOWN AUTOMATICALLY

Post upgradation steps :-

10. $ sqlplus “/as sysdba”

Startup

11. To check the upgraded components

SQL> @d:/oracle/11.2.0.4/db_1/rdbms /adminutlu112s.sql

12. Change the compatible parameter and restart the database.

SQL> alter system set compatible=’11.2.0.4.0′ scope=spfile;
SQL> shutdown immediate; //if the db is running using pfile edit pfile after stutdown
SQL> startup;

13.To check the version

SQL>select * from v$version;

This article presents how to quickly install Oracle Database 11G Release 2 (11.2.0.3) and as Oracle Grid 11G Release 2(11.2.0.3) on Windows.

Check article for new release Install Oracle 12C Release 1 (12.1) on Windows 7, 8

Software used:

Oracle Database 11G Release 2(11.2.0.3) – 64 bit for Windows
Oracle Grid 11G Release 2(11.2.0.3) – 64 bit for Windows
Windows 8 Pro 64 bit

You can download Oracle Database 11G Release 2(11.2.0.3) and Oracle Grid 11G Release 2(11.2.0.3). You can download them on Oracle support formerly MetaLink.

Hardware and software requirements for database and grid software:

at least 4GB ram as minimum, 20G space for binaries and 40G for ASM devices
Windows Server 2003 – all x64 editions
Windows Server 2003 R2 – all x64 editions
Windows XP Professional x64 Edition
Windows Vista x64 – Business, Enterprise, and Ultimate editions
Windows Server 2008 x64 and Windows Server 2008 R2 x64 – Standard, Enterprise, Datacenter, Web, and Foundation editions
Windows 7 x64 – Professional, Enterprise, and Ultimate editions

Windows 8 Support

Starting with Oracle Database 11g Release 2 (11.2.0.4), Oracle Database server and client are supported on Windows 8. Oracle RAC is not supported on Windows 8.

In case you are not planning to install grid 2GB ram is enough.

Download Oracle 11.2 0.4 Windows 64 Bit

This installation was done for 11.2.0.3 on Windows 7 but with release 11.2.0.4 it’s possible on Windows 8.

ASM devices

To run ASM on Windows you need to create at least one RAW logical partition. For this presentation I have created 2 logical partitions each 20GB using diskpart.exe program.

RAW means not formated partition and without assigned letter.

Another option is to use “Computer management” interface which is user graphical interface. It includes “Disk management” tool to manage partitions.

It’s just example for diskpart.exe

1. List available disks on computer. There is only one disk with 40GB free space.

2. As first step you need to select disk before making any changes on it. In my case there is only one disk so it’s not necessary step but I wanted to show how to do it.

Download Oracle 11.2 0.4 For Windows 64 Bit

3. List partitions. There is only one primary partition on disk.

4. Add new extended partition and 2 logical partitions.

5. Verify new partitions.

Install grid software

This presentation shows how to install grid software as standalone version which is nice to have to find out how ASM works. Unzip grid binaries to a directory and run setup.exe.

1. You should see following screen. Select “Skip software updates” and click “Next” button.

2. Select “Configure Oracle Grid Infrastructure for Standalone Server” and click “Next” button.

3. Select language and click “Next” button.

4. It’s time to create ASM diskgroup DATA. First you need to make created earlier partitions with diskpart.exe visible by ASM binaries. Click “Stamp Disk” button.

5. It will start asmtool. The tool is used to stamp devices(partitions) to be visible by Oracle binaries. Stamp means write some raw informations on the beginning of selected partition. Click “Next” button. Ye ye ye my bad “Dalej” ;). I use Polish windows :).

6. Select device which you want to stamp and enter label “DATA” for it. Then click “Next” button.

7. ASM will see this partition as “ORCLDISKDATA0”. Just click “Next” button.

8. Just click “OK”(Polish “Zakoncz”) button.

9. Repeat step 5,6,7,8 for another device and stamp it with label “BACKUP”. Once it’s done you should see 2 devices. Select redundancy to “External” and select device “ORCLDISKDATA0” and click “Next” button.

10. From security point of view you should specify separate password for user SYS and ASMSNMP. I set for both user the same password. Click “Next” button.

11. On this screen you can specify directory for grid binaries. If you have already some Oracle binaries it makes sense to select already defined Oracle Base.

12. Summary screen just before installation begin. Click “Install” button.

13. Boring installation …

15. Installation completed. Just click “Close” button.

ASM configuration assistant ASMCA

So far we have created only one ASM group DATA. I want to show how-to quickly add extra group to ASM instance.

1. Run “Automatic Storage Management Configuration Assistant” from Windows menu. Once it’s started click “Create” button.

2. Enter disk group name BACKUP, select redundancy to “External”, check checkbox for “.ORCLDISKBAC

Download Oracle 11.2 0.4 For Windows 64 Bit