Oracle Connection issue
 i have installed oracle11g on windows 7.i can login and do my work at sqlconsole on the host where oracle is installed . However , i can not login from remote host using a client e.g. SQLDEVELOPER.However i can connect to other remote host where oracle is installed.Hence, there is no issue with sqldeveloper. On further analysis i found that the host where oracle is properly installed has a service handler running for all the services. However, in this case all the service handlers are not up. i found it by issuing command lsnrctl status. The message is 
    
    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-JUN-2012 05:34:21
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date                09-JUN-2012 05:05:40
    Uptime                    0 days 0 hr. 28 min. 41 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   E:\app\mridul\product\11.2.0\dbhome_1\network\admin\listener.ora
    Listener Log File         e:\app\mridul\diag\tnslsnr\mridul-PC\listener\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=1521)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    
    listener.ora details
    # listener.ora Network Configuration File: E:\app\mridul\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = E:\app\mridul\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:E:\app\mridul\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.3)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = E:\app\mridul
    
    tnsnames.ora details
    # tnsnames.ora Network Configuration File: E:\app\mridul\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )
      )
    
    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )
    
Please let me know how i can start the service for all the services or any other workaround to connect to remote host oracle using any client successfully
Thanks in advance



Oracle Connection issue
===

 i have installed oracle11g on windows 7.i can login and do my work at sqlconsole on the host where oracle is installed . However , i can not login from remote host using a client e.g. SQLDEVELOPER.However i can connect to other remote host where oracle is installed.Hence, there is no issue with sqldeveloper. On further analysis i found that the host where oracle is properly installed has a service handler running for all the services. However, in this case all the service handlers are not up. i found it by issuing command lsnrctl status. The message is 
    
    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 09-JUN-2012 05:34:21
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
    Start Date                09-JUN-2012 05:05:40
    Uptime                    0 days 0 hr. 28 min. 41 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   E:\app\mridul\product\11.2.0\dbhome_1\network\admin\listener.ora
    Listener Log File         e:\app\mridul\diag\tnslsnr\mridul-PC\listener\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.3)(PORT=1521)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    
    listener.ora details
    # listener.ora Network Configuration File: E:\app\mridul\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = E:\app\mridul\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:E:\app\mridul\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.3)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = E:\app\mridul
    
    tnsnames.ora details
    # tnsnames.ora Network Configuration File: E:\app\mridul\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.
    ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )
      )
    
    ORCL =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
        )
      )
    
Please let me know how i can start the service for all the services or any other workaround to connect to remote host oracle using any client successfully
Thanks in advance


