7 Replies Latest reply: Jun 10, 2011 5:33 AM by 678557 RSS

    Windows 7 64-bit 10g XE

    678557
      Hi All,

      I am currently using the below given Oracle Exp. Edition.
      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
      PL/SQL Release 10.2.0.1.0 - Production
      "CORE     10.2.0.1.0     Production"
      TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production
      Now I need to support Windows 7 64-bit OS. I cannot find the same version setup for 64-bit OS.

      Can anyone provide me the link?

      I appreciate your help.

      I had filed this same thread in different category but still not reached to any conclusion.

      10g EE setup for 64-bit OS

      Thanks,
      Jignesh
        • 1. Re: Windows 7 64-bit 10g XE
          587815
          Oracle 10g XE is not supported on 64 bits. The production version of 11g XE if it's supported by Windows and Linux 64 bits.

          Roberto
          • 2. Re: Windows 7 64-bit 10g XE
            678557
            Hi Roberto,

            Thanks for your reply.

            I checked the link below and found that 10.2.0.4 supports Windows 7 64-bit.

            http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

            I clicked on the link for 10.2.0.4 and it says that

            "4. If installing on Windows 7 or Windows Server 2008 R2, then 10.2.0.5 patchset or higher must be used. (My Oracle Support)"

            http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html

            But in my previous thread I got reply that only 11g will be supported on Windows 7 64-bit.

            I am getting confused now. Moderator??? Can anybody please help me reaching some concrete decision?

            More to the actual question. I am using the 10.2.0.1 universal database engine setup only. Is there similar setup available for the above?

            I appreciate your inputs.

            Thanks,
            Jignesh

            Edited by: Jignesh Parikh on Jun 8, 2011 10:34 PM
            • 3. Re: Windows 7 64-bit 10g XE
              678557
              Hi Roberto,

              Thanks for your reply.

              I checked the link below and found that 10.2.0.4 supports Windows 7 64-bit.

              http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

              I clicked on the link for 10.2.0.4 and it says that

              "4. If installing on Windows 7 or Windows Server 2008 R2, then 10.2.0.5 patchset or higher must be used. (My Oracle Support)"

              http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html

              But in my previous thread I got reply that only 11g will be supported on Windows 7 64-bit.

              I am getting confused now. Moderator??? Can anybody please help me reaching some concrete decision?

              More to the actual question. I am using the 10.2.0.1 universal database engine setup only. Is there similar setup available for the above?

              I appreciate your inputs.

              Thanks,
              Jignesh
              • 4. Re: Windows 7 64-bit 10g XE
                678557
                I have one more question regarding that.

                Can I install 10g XE 10.2.0.1 as a 32-bit application on Windows 7 64-bit OS?
                • 5. re: Windows 7 64-bit 10g XE
                  CarCrazyBen
                  Hello Jignesh. Yes, you can run 10g Express on Win7 64 bit. I just downloaded and installed XE today and the application is web-based and running just fine on Firefox.
                  Hope this helps.....

                  ~Ben
                  • 6. Re: re: Windows 7 64-bit 10g XE
                    678557
                    Hello Ben,

                    Thank you for your time.

                    I just checked that and installation works smoothly but fails when I try to connect from my project code. It shows me the below given error.
                    System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified
                       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
                       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
                       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
                       at System.Data.OracleClient.OracleConnection.Open()
                    I googled for that error. Looked into tnsnames.ora, sqlnet.ora and listener.ora files. All these files looks ok to me. I am pasting the contents of these files.

                    1. tnsnames.ora
                    XE =
                      (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = testpc)(PORT = 1521))
                        (CONNECT_DATA =
                          (SERVER = DEDICATED)
                          (SERVICE_NAME = XE)
                        )
                      )
                    
                    EXTPROC_CONNECTION_DATA =
                      (DESCRIPTION =
                        (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                        )
                        (CONNECT_DATA =
                          (SID = PLSExtProc)
                          (PRESENTATION = RO)
                        )
                      )
                    
                    ORACLR_CONNECTION_DATA = 
                      (DESCRIPTION = 
                        (ADDRESS_LIST = 
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
                        ) 
                        (CONNECT_DATA = 
                          (SID = CLRExtProc) 
                          (PRESENTATION = RO) 
                        ) 
                      ) 
                    2. listener.ora
                    SID_LIST_LISTENER =
                      (SID_LIST =
                        (SID_DESC =
                          (SID_NAME = PLSExtProc)
                          (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
                          (PROGRAM = extproc)
                        )
                        (SID_DESC =
                          (SID_NAME = CLRExtProc)
                          (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
                          (PROGRAM = extproc)
                        )
                      )
                    
                    LISTENER =
                      (DESCRIPTION_LIST =
                        (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                          (ADDRESS = (PROTOCOL = TCP)(HOST = testpc)(PORT = 1521))
                        )
                      )
                    
                    DEFAULT_SERVICE_LISTENER = (XE)
                    3. sqlnet.ora
                    # This file is actually generated by netca. But if customers choose to 
                    # install "Software Only", this file wont exist and without the native 
                    # authentication, they will not be able to connect to the database on NT.
                    
                    SQLNET.AUTHENTICATION_SERVICES = (NTS)
                    4. lsnrctl stat
                    C:\Users\Administrator>lsnrctl stat
                    
                    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-JUN-2011 16:31
                    :30
                    
                    Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                    
                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                    STATUS of the LISTENER
                    ------------------------
                    Alias                     LISTENER
                    Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
                    ction
                    Start Date                10-JUN-2011 16:06:07
                    Uptime                    0 days 0 hr. 25 min. 22 sec
                    Trace Level               off
                    Security                  ON: Local OS Authentication
                    SNMP                      OFF
                    Default Service           XE
                    Listener Parameter File   C:\oraclexe\app\oracle\product\10.2.0\server\network\a
                    dmin\listener.ora
                    Listener Log File         C:\oraclexe\app\oracle\product\10.2.0\server\network\l
                    og\listener.log
                    Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testpc)(PORT=1521)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
                    HTTP)(Session=RAW))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "XEXDB" has 1 instance(s).
                      Instance "xe", status READY, has 1 handler(s) for this service...
                    Service "XE_XPT" has 1 instance(s).
                      Instance "xe", status READY, has 1 handler(s) for this service...
                    Service "xe" has 1 instance(s).
                      Instance "xe", status READY, has 1 handler(s) for this service...
                    The command completed successfully
                    Can anybody say what is going wrong? Is it with Win 7 64-bit?

                    I appreciate your help.

                    Thanks,
                    Jignesh

                    Edited by: Jignesh Parikh on Jun 10, 2011 4:02 AM
                    • 7. Re: Windows 7 64-bit 10g XE
                      678557
                      Hello Roberto,

                      Oracle 10g XE not supported on Win 7 64-bit but It allows me to install as 32-bit application but fails when trying to establish connection from .NET code.

                      Thanks,
                      Jignesh

                      Edited by: Jignesh Parikh on Jun 10, 2011 3:33 AM