12 Replies Latest reply: Jul 14, 2011 7:58 AM by user9210174 RSS

    Using Oracle 10g XE on Windows 7 64-bit

    794405
      After successfully installing Oracle 10g express edition on a windows 7 64-bit system several problems occurred while using it. I like to share the problems I encountered and the solutions I have found.

      IE8 problem
      When opening the Oracle database homepage in Internet Explorer 8 (IE8) 32-bit version and after login everything works fine except when clicking on the “Object Browser” icon a page not found (HTTP error-404) occurs. With IE8 64-bit the error doesn’t occur. I didn’t found the cause for this, anyone know why?

      ODBC problem with Data Source Administrator
      The Oracle ODBC driver is located in C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqora32.dll and is registered as a 32-bit driver. But the default ODBC Data Source Administrator only shows the 64-bit drivers that’s why you don’t see the Oracle ODBC driver in the driver list. The solution is to start the 32-bit version of the ODBC Data Source Administrator. You can find this version in the location %windir%\SysWOW64\odbcad32.exe. The default 64-bit ODBC Data Source Administrator is located in %windir%\system32\odbcad32.exe.

      ODBC problem using Access 2003
      When trying to use a created ODBC connection in MS Access 2003 an “ORA-12154: TNS:could not resolve the connect identifier specified” error occurs. The cause is that MS Access 2003 is located in Program Files (x86) and this name is in the pad string used in the ODBC connection data. The Oracle TNS can not handle the ( ) used in Program Files (x86). The solution for this is to copy the msaccess.exe file form C:\Program Files (x86)\Microsoft Office\OFFICE11 to a different folder without using ( ) and use that file to start Access.
        • 1. Re: Using Oracle 10g XE on Windows 7 64-bit
          791433
          Thanks for sharing your experience with oracle XE on Windows 7 64 bit
          I installed on Windows 7 32 bit - and have the same problem with Object Browser which you reported with IE8 (32).
          Oracle support on XE seems to be extremely backward. I would have thought thta they would have sorted out these gremlins long ago.
          The only response I got from this group was to the affect that Windows 7 is not on their supported list (nor is Vista).
          • 2. Re: Using Oracle 10g XE on Windows 7 64-bit
            791433
            Your info on curing the Object Browser problem by changing from IE8 (32) to IE8 (64) got me thinking. I was experiencing the Object Browser problem on Windows 7 (32) with IE8 (32). I switched to Google Chrome (ver 5.0.375.127) - and Object Browser now works.
            So it looks like IE8 (32) is the problem.
            An earlier email from another user reported the Object Browser problem with Windows XP - I wonder if it is IE8 (32) that is the problem in that case also.
            Is there anyone else out there with a recent installation of Oracle XE and IE8 ? Are you experiencing the Object Browser Problem? Is it cured by using another WWW Browser?
            • 3. Re: Using Oracle 10g XE on Windows 7 64-bit
              797378
              Hi,

              I have recently installed oracle XE on window7 32bit tried using IE8, firefox, chrome to open up the home page but to no avail. any idea what could be the problem?

              Regards,
              BK
              • 4. Re: Using Oracle 10g XE on Windows 7 64-bit
                794405
                Does the address field show the address http://127.0.0.1:8080/apex/f?p=4550:11:1428962963808679::NO::: ?

                Did you installed Oracle XE in the default folder c:\oraclexe ?

                Did you checked your firewall?
                • 5. Re: Using Oracle 10g XE on Windows 7 64-bit
                  812864
                  Hello,

                  Could you please share you solution for having Oracle XE runnging on Windows 7 64-bit?
                  • 6. Re: Using Oracle 10g XE on Windows 7 64-bit
                    Srini Chavali-Oracle
                    XE is not supported/certified on Win 7

                    http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#CIHFEBGE

                    HTH
                    Srini
                    • 7. Re: Using Oracle 10g XE on Windows 7 64-bit
                      830437
                      I keep having this problem with the home page...

                      I've installed everything by default, disabled my firewall, added 127.0.0.1 to the Intranet locations on IE8 settings, checked the availability of port 8080...
                      and still nothing!!
                      I've even uninstalled and reinstalled!
                      Neither IE nor Firefox would open the homepage...

                      Any help would do...
                      • 8. Re: Using Oracle 10g XE on Windows 7 64-bit
                        clcarter
                        Many of the Apex glitches, especially the obiect browser can be fixed with an Apex upgrade. The out-of-the-box 2.1 version is older than firefox 2. Not much older than firefox 1.

                        http://www.oracle.com/technetwork/developer-tools/apex/upgrade-apex-for-xe-154969.html


                        For user 827434 ... is the database running, check the endpoints in a lsnrctl status and start a new thread ...
                        • 9. Re: Using Oracle 10g XE on Windows 7 64-bit
                          831275
                          works perfectly fine with win7 64 bit / google chrome
                          • 10. Re: Using Oracle 10g XE on Windows 7 64-bit
                            Gaillimh
                            EmPhi - thank you very much.

                            I had this issue with Excel 2003 on Windows 7 64bit trying to connect to Oracle XE

                            ODBC problem using Access 2003
                            When trying to use a created ODBC connection in MS Access 2003 an “ORA-12154: TNS:could not resolve the connect identifier specified” error occurs. The cause is that MS Access 2003 is located in Program Files (x86) and this name is in the pad string used in the ODBC connection data. The Oracle TNS can not handle the ( ) used in Program Files (x86). The solution for this is to copy the msaccess.exe file form C:\Program Files (x86)\Microsoft Office\OFFICE11 to a different folder without using ( ) and use that file to start Access.


                            Moving the EXCEL.exe to the C:\ drive worked.

                            Thanks again.
                            • 11. Re: Using Oracle 10g XE on Windows 7 64-bit
                              863151
                              I was having the same TNS error using VFP9. I moved the VFP root folder from "Program Files (x86)" to "Program Files" and I was able to make a connection. However, this did not correct the error in using SQLPro. I still cannot get SQLPro to connect.

                              I have not upgraded my IE7 to IE8 on Windows 7 64bit and have not had any issues.
                              • 12. Re: Using Oracle 10g XE on Windows 7 64-bit
                                user9210174
                                After configuring XE on Windows 7 , if you are getting a TNS connection error , try the following.

                                1) In the ODBC connection , enter the TNS service name as localhost:1521/XE , where XE is my service name mentioned in my tnsnames.ora. This should solve the connection issue and can access the database using the sys user id.

                                Note : Each time you reboot your machine , the following need to be done.

                                (i) Navigate to C:\oraclexe\app\oracle\product\10.2.0\server\BIN

                                (ii) Locate the exe file LSNRCTL.EXE and run it with administrator privileges ( right click asn select run as administrator )

                                (iii) enter stop ( e.g LSNRCTL > stop ) and wait until it is successfully completed

                                (iv) Turn-off the Wireless ( if ON)

                                (v) enter start ( e.g LSNRCTL > start ) and wait until it is successfully completed

                                (vi) Navigate to All Programs --> Oracle Database 10g Express Edition

                                (vii) Run the "Stop Database" as Administrator and wait for the successfully completed message.

                                (viii) Turn-on the Wireless and wait for few seconds.

                                (ix) Navigate to All Programs --> Oracle Database 10g Express Edition

                                (x) Run the "Stop Database" as Administrator and wait for the successfully completed message.