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

Written August 15, 2009 by Marko Sutic

   42 comments

42 comments:

  1. ColdFireOctober 5, 2009 at 5:51 PM

    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. Marko SuticOctober 6, 2009 at 2:41 PM

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

    ReplyDelete
  3. UnknownOctober 15, 2009 at 2:32 PM

    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. UnknownOctober 16, 2009 at 2:18 AM

    Thanks a lot!!! Great trick!!!

    ReplyDelete
  5. Anton BudiartoOctober 26, 2009 at 3:46 AM

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

    ReplyDelete
  6. SilviaNovember 4, 2009 at 1:03 AM

    Me ayudo mucho! gracias :D

    ReplyDelete
  7. Victor DomDecember 8, 2009 at 5:18 PM

    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
  8. Victor DomDecember 10, 2009 at 11:29 AM

    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
  9. Marko SuticDecember 10, 2009 at 12:56 PM

    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
  10. UnknownJanuary 4, 2010 at 2:02 AM

    thanks it helped me a lot

    ReplyDelete
  11. AnonymousJanuary 6, 2010 at 4:58 AM

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

    ReplyDelete
  12. Dušan Knežević January 15, 2010 at 11:03 AM

    Hvala Marko, ustedeo si mi dosta vremena...

    pozdrav

    ReplyDelete
  13. rommelFebruary 6, 2010 at 9:32 PM

    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
  14. Mr CapableFebruary 19, 2010 at 8:41 AM

    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
  15. Marko SuticFebruary 19, 2010 at 9:55 AM

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

    thanks for comment,
    Marko

    ReplyDelete
  16. AnonymousMarch 5, 2010 at 9:20 PM

    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
  17. Leonardo LuzzattoMarch 10, 2010 at 2:31 PM

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

    ReplyDelete
  18. UnknownMarch 11, 2010 at 12:58 PM

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

    ReplyDelete
  19. shanks !!March 12, 2010 at 8:32 PM

    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
  20. AnonymousMarch 14, 2010 at 10:54 AM

    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
  21. UnknownMarch 20, 2010 at 12:20 AM

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

    ReplyDelete
  22. AnonymousMay 17, 2010 at 6:05 PM

    Great Work dude!!
    Thanks,

    ReplyDelete
  23. BulatMay 20, 2010 at 5:46 PM

    Thanks a lot!

    great tip!

    ReplyDelete
  24. adithyanJuly 4, 2010 at 3:59 PM

    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
  25. Manfred LangeJuly 29, 2010 at 3:25 PM

    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
  26. AnonymousJuly 31, 2010 at 12:45 AM

    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
  27. evanjNovember 16, 2010 at 8:45 PM

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

    ReplyDelete
  28. AnonymousFebruary 3, 2011 at 7:16 PM

    thanks!!! very nice

    ReplyDelete
  29. AnonymousMarch 16, 2011 at 5:29 PM

    Thanks a lot. You saved my day!

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

    ReplyDelete
  30. AnonymousJuly 13, 2011 at 8:06 PM

    This comment has been removed by the author.

    ReplyDelete
  31. AnonymousJuly 13, 2011 at 8:09 PM

    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
  32. AnonymousAugust 9, 2011 at 1:45 PM

    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
  33. xanaxAugust 24, 2011 at 1:57 AM

    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
  34. AnonymousNovember 8, 2011 at 7:36 PM

    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
  35. AnonymousNovember 13, 2011 at 9:36 AM

    1.000.000 THANKS Marco!!!

    ReplyDelete
  36. Sangram NandkhileNovember 18, 2011 at 8:25 AM

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

    Sangram

    ReplyDelete
  37. AnonymousFebruary 4, 2012 at 1:19 AM

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

    ReplyDelete
  38. Victor AnibarriMarch 5, 2012 at 10:05 PM

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

    ReplyDelete
  39. SaniyaApril 11, 2012 at 8:09 AM

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

    ReplyDelete
  40. Alhassan D. GlogoDecember 1, 2013 at 10:50 PM

    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
  41. AnonymousOctober 30, 2014 at 7:21 PM

    Hey man!!
    THANK YOUUUUUUUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!!!!
    :-D

    ReplyDelete
  42. UnknownSeptember 11, 2017 at 11:02 AM

    You are on 2nd page on google :D

    ReplyDelete

Subscribe to: Post Comments (Atom)