5 Replies Latest reply: May 20, 2013 12:25 AM by actanz RSS

    can't connnect 11g express on win7 64bit

    actanz
      I just unlocked HR schema and I can connect to it in sqlplus by command `sqlplus hr/hr`, command `sqlplus system/oracle` works too.

      But I just can't connect both HR and system in sql developer. It's reporting "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection"

      I entered localhost, port:1521, sid: xe in the connection dialog but i just get above error, can any one give me some hint?

      I am clueless now ..


      Thanks!
        • 1. Re: can't connnect 11g express on win7 64bit
          yoonas
          Hi,

          Start a dos command window and run "lsnrctl status", post the output.

          Regards
          Yoonas
          • 2. Re: can't connnect 11g express on win7 64bit
            actanz
            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 20-MAY-2013 13:59:17

            Copyright (c) 1991, 2010, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
            Start Date 17-MAY-2013 16:45:32
            Uptime 2 days 21 hr. 14 min. 32 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Default Service XE
            Listener Parameter File E:\ora_ex\app\oracle\product\11.2.0\server\network\admin\listener.ora
            Listener Log File E:\ora_ex\app\oracle\diag\tnslsnr\APDZ3T9W1\listener\alert\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDZ3T9W1.ad.syniverse.com)(PORT=1522)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDZ3T9W1.ad.syniverse.com)(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" has 1 instance(s).
            Instance "xe", status READY, has 1 handler(s) for this service...
            The command completed successfully

            Thanks!
            • 3. Re: can't connnect 11g express on win7 64bit
              actanz
              LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 20-MAY-2013 13:59:17

              Copyright (c) 1991, 2010, Oracle. All rights reserved.

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
              Start Date 17-MAY-2013 16:45:32
              Uptime 2 days 21 hr. 14 min. 32 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Default Service XE
              Listener Parameter File E:\ora_ex\app\oracle\product\11.2.0\server\network\admin\listener.ora
              Listener Log File E:\ora_ex\app\oracle\diag\tnslsnr\APDZ3T9W1\listener\alert\log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDZ3T9W1.ad.syniverse.com)(PORT=1522)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDZ3T9W1.ad.syniverse.com)(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" has 1 instance(s).
              Instance "xe", status READY, has 1 handler(s) for this service...
              The command completed successfully
              • 4. Re: can't connnect 11g express on win7 64bit
                yoonas
                >
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=APDZ3T9W1.ad.syniverse.com)<font color=red>(PORT=1522</font>)))
                >

                Change your port to 1522
                • 5. Re: can't connnect 11g express on win7 64bit
                  actanz
                  Thank you very much yoonus!! It works!