1 2 Previous Next 18 Replies Latest reply: Jan 5, 2013 11:24 AM by 961125 Go to original post RSS
      • 15. Re: Error while connecting database from SQL developer
        sb92075
        958122 wrote:
        I have restarted the listener service but still getting the same in sql dev

        LSNRCTL> status
        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
        STATUS of the LISTENER
        ------------------------
        Alias LISTENER
        Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
        ction
        Start Date 05-JAN-2013 21:56:29
        Uptime 0 days 0 hr. 2 min. 44 sec
        Trace Level off
        Security ON: Local OS Authentication
        SNMP OFF
        Listener Parameter File d:\app\Karan\product\11.2.0\dbhome_1\network\admin\lis
        tener.ora
        & you are still using the problematic listener.ora file shown above!

        CD d:\app\Karan\product\11.2.0\dbhome_1\network\admin\
        RENAME LISTENER.ORA LISTENER.ORA.SAV
        Listener Log File d:\app\karan\diag\tnslsnr\Karan-PC\listener\alert\log.
        xml
        Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
        listener still listening on 127.0.0.1 which is NOT IP# for Karan-PC!
        • 16. Re: Error while connecting database from SQL developer
          961125
          older listener file data
          # listener.ora Network Configuration File: d:\app\Karan\product\11.2.0\dbhome_1\network\admin\listener.ora
          # Generated by Oracle configuration tools.

          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (SID_NAME = OIMDB)
          (ORACLE_HOME = d:\app\Karan\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:d:\app\Karan\product\11.2.0\dbhome_1\bin\oraclr11.dll")
          )
          )

          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          )
          )

          ADR_BASE_LISTENER = d:\app\Karan



          and I have created a new listener file as
          # listener.ora Network Configuration File: d:\app\Karan\product\11.2.0\dbhome_1\network\admin\listener.ora
          # Generated by Oracle configuration tools.

          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (SID_NAME = OIMDB)
          (ORACLE_HOME = d:\app\Karan\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:d:\app\Karan\product\11.2.0\dbhome_1\bin\oraclr11.dll")
          )
          )

          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
          )
          )

          ADR_BASE_LISTENER = d:\app\Karan

          where IP is of my machine

          then status of listener is
          LSNRCTL> status
          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
          ction
          Start Date 05-JAN-2013 22:17:53
          Uptime 0 days 0 hr. 5 min. 55 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File d:\app\Karan\product\11.2.0\dbhome_1\network\admin\lis
          tener.ora
          Listener Log File d:\app\karan\diag\tnslsnr\Karan-PC\listener\alert\log.
          xml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=1521)))
          Services Summary...
          Service "OIMDB" has 1 instance(s).
          Instance "OIMDB", status UNKNOWN, has 1 handler(s) for this service...
          The command completed successfully


          NOW am getting error as network adapter could not establish the connection, an fyi in connection properties value of host is localhost

          while changing the host value to 192.168.1.2 am getting the same socket error.

          Please help.
          • 17. Re: Error while connecting database from SQL developer
            sb92075
            Since you REFUSE to follow my directions, I give up.
            You're On Your Own (YOYO)!
            • 18. Re: Error while connecting database from SQL developer
              961125
              Ok sorry, just I thought something will happen myway. NOW am doing the same as you have told me.
              Listener.ora renamed listener.ora.sav

              and getting this
              LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 05-JAN-2013 22:54
              :05

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

              Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
              TNS-12541: TNS:no listener
              TNS-12560: TNS:protocol adapter error
              TNS-00511: No listener
              32-bit Windows Error: 61: Unknown error

              Edited by: 958122 on Jan 5, 2013 10:54 PM
              1 2 Previous Next