1 2 Previous Next 19 Replies Latest reply: Feb 17, 2011 2:02 AM by P.Forstmann RSS

    Login error for ora 10g xe

    NeilCSE
      Hi All,

      I am not able to login to my ora 10g xe since today.

      the error I am getting is :

      <code>
      Listener refused the connection with the following error:

      ORA -12505, TNSL listner dose not currently know of SID given in connection descriptor. The connection descriptor used by the client was : localhost: 1521:xe

      Vendor code 0

      <\code>


      Below is listner log details

      <code>
      17-FEB-2011 12:51:17 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=neil))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=56817)) * establish * xe * 12505
      TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

      <\code>

      Edited by: NeilCSE on Feb 16, 2011 11:29 PM
        • 1. Re: Login error for ora 10g xe
          SatishKandi
          Is the XE service started?
          • 2. Re: Login error for ora 10g xe
            NeilCSE
            LSNRCTL> start
            TNS-01106: Listener using listener name LISTENER has already been started


            LSNRCTL> start
            TNS-01106: Listener using listener name LISTENER has already been started
            LSNRCTL> services
            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
            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
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0
            LOCAL SERVER
            The command completed successfully
            • 3. Re: Login error for ora 10g xe
              P.Forstmann
              What is the output of following statements run on machine where XE database runs ?
              tnsping XE
              lsnrctl services
              • 4. Re: Login error for ora 10g xe
                SatishKandi
                You have given listener status. What is the status of the "OracleServiceXE" in Windows service control?
                • 5. Re: Login error for ora 10g xe
                  Chinar
                  Post there
                  lsnrctl services
                  • 6. Re: Login error for ora 10g xe
                    P.Forstmann
                    Oracle listener does know XE instance.

                    Make sure XE listener runs on port 1521.

                    Check with :
                    lsnrctl status
                    • 7. Re: Login error for ora 10g xe
                      NeilCSE
                      TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-FEB-2
                      011 13:07:20

                      Copyright (c) 1997, 2005, Oracle. All rights reserved.

                      Used parameter files:
                      C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora


                      Used TNSNAMES adapter to resolve the alias
                      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = neil)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERV
                      ICE_NAME = XE)))
                      OK (20 msec)



                      C:\>lsnrctl services

                      LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-FEB-2011 13:07
                      :55

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

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                      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
                      Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      Handler(s):
                      "DEDICATED" established:0 refused:0
                      LOCAL SERVER
                      The command completed successfully
                      • 8. Re: Login error for ora 10g xe
                        NeilCSE
                        C:\Users\neil>lsnrctl status

                        LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-FEB-2011 13:10
                        :35

                        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 15-FEB-2011 23:35:22
                        Uptime 1 days 13 hr. 35 min. 14 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=neil)(PORT
                        =1521)))
                        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...
                        The command completed successfully
                        • 9. Re: Login error for ora 10g xe
                          Chinar
                          NeilCSE wrote:
                          C:\Users\neil>lsnrctl status

                          LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-FEB-2011 13:10
                          :35

                          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 15-FEB-2011 23:35:22
                          Uptime 1 days 13 hr. 35 min. 14 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=neil)(PORT
                          =1521)))
                          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...
                          The command completed successfully
                          As you see clearly that your XE sid was not register in listener so.
                          set ORACLE_SID=XE
                          sqlplus "/as sysdba"
                          alter system register;
                          Use dynamic or static registration.
                          • 10. Re: Login error for ora 10g xe
                            P.Forstmann
                            Check that the Oracle instance service is up with:
                            sc query OracleServiceXE
                            Try to login and check local_listener parameter:
                            sqlplus / as sysdba
                            show parameter local_listener
                            • 11. Re: Login error for ora 10g xe
                              NeilCSE
                              set ORACLE_SID=XE

                              sqlplus

                              Enter user-name: sys
                              Enter password:
                              ERROR:
                              ORA-12560: TNS:protocol adapter error
                              • 12. Re: Login error for ora 10g xe
                                Chinar
                                NeilCSE wrote:
                                set ORACLE_SID=XE

                                sqlplus

                                Enter user-name: sys
                                Enter password:
                                ERROR:
                                ORA-12560: TNS:protocol adapter error
                                It seems you did not start OracleServiceXE service.So go service control and start it and try again.
                                • 13. Re: Login error for ora 10g xe
                                  NeilCSE
                                  sc query OracleServiceXE

                                  SERVICE_NAME: OracleServiceXE
                                  TYPE : 10 WIN32_OWN_PROCESS
                                  STATE : 1 STOPPED
                                  WIN32_EXIT_CODE : 0 (0x0)
                                  SERVICE_EXIT_CODE : 0 (0x0)
                                  CHECKPOINT : 0x0
                                  WAIT_HINT : 0x0


                                  set ORACLE_SID=XE


                                  Enter user-name: sys
                                  Enter password:
                                  ERROR:
                                  ORA-12560: TNS:protocol adapter error
                                  • 14. Re: Login error for ora 10g xe
                                    P.Forstmann
                                    Try to start Oracle service for XE:
                                    sc start OracleServiceXE
                                    and
                                    sqlplus / as sysdba
                                    alter system register;
                                    1 2 Previous Next