How to install Oracle Client 11g on Windows 7?

Saturday, August 15, 2009

I've never liked Windows Vista and I thought that Windows 7 is the same operating system just with new popular name. But lately I've read a lot good comments about Windows 7. To be honest Windows XP is still my favorite OS from Microsoft but I decided to try out Windows 7. So I downloaded and installed Windows 7 RC1.

First thing to try out after installing operating system is installation of Oracle Client because this application is essential for my work.

Shortly after initiating installation of Oracle Client 11g (11.1.0.6.0) installation stopped on prerequisite checks with error:

Checking operating system requirements ...
Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<< Problem: Oracle Database 11g is not certified on the current operating system. Recommendation: Make sure you are installing the software on the correct platform. ========================================================


To workaround this problem I've decided to edit refhost.xml file adding entry for Windows 7.

Location of this file on my system:
c:\unpacked_client_installation\win32_11gR1_client\client\stage\prereq\client\refhost.xml

This is excerpt from my newly edited refhost.xml file:


<CERTIFIED_SYSTEMS>
<OPERATING_SYSTEM>
<!--Microsoft Windows 2000-->
<VERSION VALUE="5.0"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<!--Microsoft Windows XP-->
<VERSION VALUE="5.1"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<!--Microsoft Windows 2003-->
<VERSION VALUE="5.2"/>
</OPERATING_SYSTEM>
<!--Microsoft Windows Vista-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.0"/>
</OPERATING_SYSTEM>
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>

</CERTIFIED_SYSTEMS>

New lines are added at the end of this excerpt after <!--Microsoft Windows 7-->. Notice version value=6.1.

With new refhost.xml file all checks passed and I was ready to try out is everything OK after installation.

All tools that I am using in my daily work functioned perfectly.

There are maybe some features that will not function properly on Windows 7 but I won't bother with that features as I don't use them.



O yes, and word or two about Windows 7.

My first impressions are good. It is much better operating system then Windows Vista. It is very stable and fast which is great for beta operating system.
Try it out on test machine or in virtual machine - it won't cost you anything ;)

41 comments:

  • ColdFire

    Finally! You have no ideea how long i've searched for a solution regarding the 6.1 pass failed. Windows 7 is cool, just instaled it, but still...LINUX is better :D

  • Marko Sutic

    I prefer LINUX or SOLARIS on server side, but on workstations Windows 7 is now best operating system in my option ;)

  • EL FATHI FOUAD

    thanks a lot !!! iwork with the oracle 10g in py computer now :D
    but we must add 6.0 also in the file install/oraparm.ini

    [Certified Versions]
    #You can customise error message shown for failure, provide value for CERTIFIED_VERSION_FAILURE_MESSAGE
    Windows=5.0,5.1,5.2,6.0,6.1


    ;)

  • asanchez14

    Thanks a lot!!! Great trick!!!

  • Gianpaolo

    thanks.. editing refhost.xml and oraparm.ini works flawlessly!! :)

  • Lila

    Me ayudo mucho! gracias :D

  • Victor Dom

    Greetings.

    I setup Oracle 11.1.0.6 software only on W7 64 then setup path 10.1.0.7
    Any problems was not.
    Before creating a DB I has decided to setup Oracle innteligent agent 10.2.0.4 has told installator -ignoreSysPrereqs there was prompt Oinstall then installation has broken.
    Who can that prompt as to setup innteligent agent on W7 64?

  • Victor Dom

    Hi
    Above I wrote about a problem with oinstal.
    Installation after a prompt conclusion broke.
    The problem has dared after installation patch java 64 for W7 from a server Sun

  • Marko Sutic

    Hi Victor,
    I don't understand what are you trying to do and what errors do you receive.

    This blog post shows how to install Oracle Client 11g application on Windows 7 - avoiding prerequisite check error.

    Are you having problems installing Oracle Client application?

  • Nice article... It help me a lot in installing oracle 11g R1 client in Windows 7

  • Duja

    Hvala Marko, ustedeo si mi dosta vremena...

    pozdrav

  • rommel

    The refhost.xml and oraparm.ini workaround worked like a charm. For Win 7 64bit, just make sure you are installing "Oracle 10.2.0.4 for Vista x64 and Win 2008 Server" client version and not the "Win XP x64" version. It looks pretty obvious but that's where I tripped.

  • another trick that worked for me was by running the oracle setup.exe from cmd prompt with the option to ignore sysprerequisite checking.


    H:\win32_11gR1_database_1013\database>setup -ignoresysprereqs

  • Marko Sutic

    @Mr Capable: yes, this trick works also... it is even more convenient trick then editing refhost.xml file.

    thanks for comment,
    Marko

  • Thank you! this trick is great. I got it work with

    Hyper-V, Window 2008 R2 server 64 bit, SQL 2008, Oracle 10g 64 bit client and ODAC 64 bit.

    JLI

  • Leonardo Luzzatto

    It worked for me only after editing the file install/oraparm.ini just like EL FATHI FOUAD did.

  • Dhritiman

    hi!!!!!!!!!
    this is too good...

  • heyy still am not able to install oracle 11g (11.1.0.6.0)...i hav made updations in both files..ie.,refhost.xml & oraparm.ini ..plz help me.....am using window 7 home 64bit os

  • Awesome answer!!!!

    for post just above me please update the two refhost.xml file in db and db_prereqs.since we have two refhost.xml files.

    shanks !! said...
    heyy still am not able to install oracle 11g (11.1.0.6.0)...i hav made updations in both files..ie.,refhost.xml & oraparm.ini ..plz help me.....am using window 7 home 64bit os

  • khiggins459

    I want to hug you, man.
    you are my hero.
    thank you very much for posting this.

  • Great Work dude!!
    Thanks,

  • Bulat

    Thanks a lot!

    great tip!

  • Thanks a lot Marko Sutic. A great help.
    When i started installing the same error came.I followed the procedure you suggested.Again the same error came. And then i closed the installation wizard and then tried the same procedure and it works. Thanks again...

  • Manfred

    It just doesn't make sense. What is the reason that Oracle doesn't get the R1 client compatible for Windows 7. Why do they make such a big fuzz about this? It appears as if there is a real need for this.

  • Hi, i tried to install oracle client 10g on windows 7 64 bits and i get the message "Terminacion anormal del programa se ha producido un error interno. proporcione los siguientes archivos a los servicios de soporte oracle: "desconocido" "desconocido" "desconocido"
    and the log of instalation say

    Using paramFile: E:\orac_client64b\102010_win64_x64_client\client\install\oraparam.ini


    No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

    The commandline for unzip:
    E:\orac_client64b\102010_win64_x64_client\client\install\unzip -qqq ../stage/Components/oracle.swd.jre/1.5.0.0.0/1/DataFiles/"*.jar" -d "C:\Users\Carlos\AppData\Local\Temp\OraInstall2010-07-30_05-39-51PM"
    The commandline for unzip:
    E:\orac_client64b\102010_win64_x64_client\client\install\unzip -qqq ..\stage\Components\oracle.swd.oui\10.2.0.1.0\1\DataFiles\/"*.jar" -d "C:\Users\Carlos\AppData\Local\Temp\OraInstall2010-07-30_05-39-51PM"
    The commandline for unzip:
    E:\orac_client64b\102010_win64_x64_client\client\install\unzip -qqq ..\stage\Components\oracle.swd.oui.core\10.2.0.1.0\1\DataFiles\/"*.jar" -d "C:\Users\Carlos\AppData\Local\Temp\OraInstall2010-07-30_05-39-51PM"

    The number of files bootstrapped for the jre is 505.

    The number of files bootstrapped for the oui is 99.


    please help me
    thanks you
    Carlos Farfan

  • Generic Viagra

    I want to thank you for these very good tips, I am so impressed how some commands can solve installation issues that with a simple view could be so hard to solve.

  • THANK YOU SO MUCH! I've been searching a while on how to get around this issue. =)

  • Thanks a lot. You saved my day!

    I had to path oparam.ini, too. Then everything worked perfect.

  • Sajaki
    This comment has been removed by the author.
  • Sajaki

    in case you're installing oracle server,

    the file to update is :
    F:\10204_vista_w2k8_x64_production_db\database\stage\prereq\db\refhost.xml

    and
    F:\10204_vista_w2k8_x64_production_db\database\install\oraparam.ini

    Windows=5.0,5.1,5.2,6.0,6.1

  • Many Thanks, Editing the refhost.xml file really did the trick and has helped me. I tried many things and was stuck for a week. Cheers Ryan

  • xanax

    Im impressed. I dont think Ive met anyone who knows as much about this subject as you do. Youre truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog youve got here.

  • Hi. i recently have this oracle package

    Oracle database 11g release 1 11.1.0.6.0
    Media pack v4
    for AIX5L based systems

    The thing is, I don't know which is which in this package. Like, which one is the Installer for the database itself.

  • 1.000.000 THANKS Marco!!!

  • Sangram Nandkhile

    Thankss a lot...great work,,
    hats off.

    Sangram

  • Thank You!!!!!!!!!!!!!
    (just needed a 64bit client....fing ....bloatware..........)

  • Victor Anibarri

    Muchas Gracias, me sirvio bastante resolvi muchos problemas con ese truco!. >D Good luck friend!.

  • Saniya

    I have changed only refhost.xml file and it worked. Thanks for the solution.

  • Alhassan D. Glogo

    God bless your soul!
    Please run this for me
    SET SERVEROUTPUT ON

    BEGIN
    -- thanks a million
    for i in 1..999999
    LOOP
    DBMS_OUTPUT.PUT_LINE('Thanks Marko Sutic');
    END LOOP;
    END;
    /
    :)

  • Post a Comment