Saturday, August 15, 2009

How to install Oracle Client 11g on Windows 7?

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 ;)

42 comments:

  1. 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

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

    ReplyDelete
  3. 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


    ;)

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

    ReplyDelete
  5. 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?

    ReplyDelete
  6. 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

    ReplyDelete
  7. 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?

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

    ReplyDelete
  9. Hvala Marko, ustedeo si mi dosta vremena...

    pozdrav

    ReplyDelete
  10. 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.

    ReplyDelete
  11. 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

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

    thanks for comment,
    Marko

    ReplyDelete
  13. 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

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

    ReplyDelete
  15. 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

    ReplyDelete
  16. 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

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

    ReplyDelete
  18. Great Work dude!!
    Thanks,

    ReplyDelete
  19. 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...

    ReplyDelete
  20. 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.

    ReplyDelete
  21. 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

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

    ReplyDelete
  23. thanks!!! very nice

    ReplyDelete
  24. Thanks a lot. You saved my day!

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

    ReplyDelete
  25. This comment has been removed by the author.

    ReplyDelete
  26. 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

    ReplyDelete
  27. 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

    ReplyDelete
  28. 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.

    ReplyDelete
  29. 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.

    ReplyDelete
  30. 1.000.000 THANKS Marco!!!

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

    Sangram

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

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

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

    ReplyDelete
  35. 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;
    /
    :)

    ReplyDelete
  36. Hey man!!
    THANK YOUUUUUUUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!!!!
    :-D

    ReplyDelete