13 Replies Latest reply: May 16, 2013 12:27 AM by 1009251 RSS

    Oracle 10gXE error

    617099
      I am unabl to go to the Database home page.
      Listener error
      This is the error message:
      The oracleXeTNS listener on local computer started and then stopped.Some services stop automatically if they are not in use by other services or programs .
      (listener.ora)
      ID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Mandy-PC)(PORT = 1521))
      )
      )

      DEFAULT_SERVICE_LISTENER = (XE)

      Please let me know what could be the problem.
        • 1. Re: Oracle 10gXE error
          ViragSharma
          Can you post content of error log / listener log.
          • 2. Re: Oracle 10gXE error
            Madrid
            Remove the references to the EXTPROC if you are not currently planning to use External Procedure invocations, and retry to startup the listener.

            Try to start it up by means of the command line. Please post the output of the command:

            lsnrctl start


            lsnrctl status


            ~ Madrid
            • 3. Re: Oracle 10gXE error
              617099
              Hi Virag,
              system parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
              Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
              Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
              Trace level is currently 0

              Started with pid=2252
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
              Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Mandy-PC)(PORT=1521)))
              TNS-12546: TNS:permission denied
              TNS-12560: TNS:protocol adapter error
              TNS-00516: Permission denied
              32-bit Windows Error: 13: Permission denied
              No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))


              Thanks,
              Mandy
              • 4. Re: Oracle 10gXE error
                ViragSharma
                Look likes privilege issue ...are you able to start / stop listener manually.

                lsnrctl stop
                lsnrctl start
                lsnrctl status

                user is part of oradba group ?
                • 5. Re: Oracle 10gXE error
                  Madrid
                  You are supposed to start the listener with the oracle user, if you are using a user different from this and the oracle directories where listener plans to write doesn't allow this operation, then the listener will fail to properly work.


                  ~ Madrid
                  • 6. Re: Oracle 10gXE error
                    617099
                    I am unable to start the listener manually.
                    C:\net service start OracleXETNSListener.
                    System error 5 has occurred.
                    • 7. Re: Oracle 10gXE error
                      Madrid
                      If you are still unable to start the listener, I suggest you to not to declare the EXTPROC address at the listener addresses and comment the extproc sid list.


                      ~ Madrid
                      • 8. Re: Oracle 10gXE error
                        621936
                        I have this problem too..It drives me crazy.I have downloaded Oracle Express edition 10g and the first time it worked properly..But when I came to my office , I can't start OracleXETNSListener..it gave me this message " OracleXETNSListener service on Local computer started and then stopped.Some services stop automatically if they are not in use by other services or programs."


                        Please give me the solution...For 2 days , I haven't found any solution..I must work on Oracle , because of my work..I must start OracleXETNSListener..Please somebody help me ..
                        • 9. Re: Oracle 10gXE error
                          ViragSharma
                          Start it manually , like

                          C:\Documents and Settings\virag>lsnrctl start

                          LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-FEB-2008 09:26
                          :07

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

                          Starting tnslsnr: please wait...

                          TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
                          System parameter file is C:\oracle\oraclexe\app\oracle\product\10.2.0\server\net
                          work\admin\listener.ora
                          Log messages written to C:\oracle\oraclexe\app\oracle\product\10.2.0\server\netw
                          ork\log\listener.log
                          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR
                          _XEipc)))
                          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orasib)(PORT=1580)))

                          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 08-FEB-2008 09:26:10
                          Uptime 0 days 0 hr. 0 min. 3 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Default Service XE
                          Listener Parameter File C:\oracle\oraclexe\app\oracle\product\10.2.0\server\ne
                          twork\admin\listener.ora
                          Listener Log File C:\oracle\oraclexe\app\oracle\product\10.2.0\server\ne
                          twork\log\listener.log
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orasib)(PORT=1580)))
                          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
                          • 10. Re: Oracle 10gXE error
                            794444
                            Guys if u r facing with "System Error 5 has occurred" in oracle while using windows then go to the installation directory of your oracle database, search for "startDB.bat". generally this file is in "C:\oraclexe\app\oracle\product\10.2.0\server\BIN" if you installed your oracle database in c:\oraclexe.
                            then click on the file that will make ur database start again.

                            For (windows 7 and windows vista)
                            start that file as Administrator, and ur Database will be up in no time.. :)
                            • 11. Re: Oracle 10gXE error
                              977263
                              HI !!! Im very happy because I had the same problem and I could resolve it!!! I had changed my domain data and when I changed it again I could use the oracle database but when restarted my computer (with winXP) I had the next problem: I couldn't start the service oraclexetnslistener. Every time I tried to do it i get this message: oraclexetnslistener service local computer started and then stopped.
                              To resolve it: Go to Start -> Run -> services.msc -> The services window will appear. Stop OracleServiceXE and OracleXETNSListener. Look for your LISTENER.ORA. In my computer it is on: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN.

                              Write: 127.0.0.1 instead your HostName

                              This is the content of my LISTENER.ORA:

                              SID_LIST_LISTENER =
                              (SID_LIST =
                              (SID_DESC =
                              (SID_NAME = PLSExtProc)
                              (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
                              (PROGRAM = extproc)
                              )
                              (SID_DESC =
                              (SID_NAME = CLRExtProc)
                              (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
                              (PROGRAM = extproc)
                              )
                              )

                              LISTENER =
                              (DESCRIPTION_LIST =
                              (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                              )
                              )

                              DEFAULT_SERVICE_LISTENER = (XE)
                              • 12. Re: Oracle 10gXE error
                                977263
                                I'm sorry I forgot to tell you that after doing all that you have to restart both services ... :)
                                • 13. Re: Oracle 10gXE error
                                  1009251
                                  This was really helpful.
                                  I am using Windows 7 and my Oracle XE database was working fine. But suddenly after a restart it stopped working.
                                  I manually tried to start the listener service and XE and it was all shown as started/running, but I was not able to login to the database home page.

                                  Then starting the startDB.bat as an administrator did the trick and I am able to access the db home page.

                                  Thanks for your response.

                                  Regards,
                                  Vineet