1 Reply Latest reply on Dec 11, 2013 4:14 AM by rp0428

    why when i setup HR database for sqldeveloper then click test in oracle test fail IO error

    1059621

      C:\Users\Oracle>lsnrctl status

       

       

      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-DEC-2013 10:24

      :57

       

       

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

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ipc)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ

      ction

      Start Date                10-DEC-2013 21:46:53

      Uptime                    0 days 12 hr. 38 min. 6 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   C:\app\Oracle\product\11.2.0\dbhome_1\network\admin\li

      stener.ora

      Listener Log File         c:\app\oracle\diag\tnslsnr\ORACLE\listener\alert\log.x

      ml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ipcipc)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.85.139)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

      Services Summary...

      Service "CLRExtProc" has 1 instance(s).

        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully

       

       

      C:\Users\Oracle>lsnrctl service

       

       

      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-DEC-2013 10:25

      :32

       

       

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

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=ipc)))

      Services Summary...

      Service "CLRExtProc" has 1 instance(s).

        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

          Handler(s):

            "DEDICATED" established:0 refused:0

               LOCAL SERVER

      The command completed successfully

       

       

      C:\Users\Oracle>

       

      Please help also notice i can be able to login HR using PL/SQL using my password.