9 Replies Latest reply: Jan 17, 2013 12:24 AM by 985209 RSS

    OracleServiceXE service is missing

    985209
      I have successfully installed Oracle Database 10g Express Edition on my machine. All the services are working as expected. I can create tables, store data ...
      But after few days suddenly my db stopped working, when i checked the services i found out that OracleServiceXE service was not present and OracleXETNSListener service was stopped.

      I re-installed the oracle again and everything got in place ... but after few days same thing happened. I have windows 7 as OS.

      Please provide some inputs, i have no clue why this is happening.

      Edited by: 982206 on Jan 16, 2013 4:28 AM
        • 1. Re: OracleServiceXE service is missing
          Osama_Mustafa
          Provide full information about DB version and OS version Please
          • 2. Re: OracleServiceXE service is missing
            985209
            DB Version: Oracle Database 10g Express Edition Release 10.2.0.1.0
            OS Version: Windows 7 enterprise 64 bit
            • 3. Re: OracleServiceXE service is missing
              Osama_Mustafa
              982206 wrote:
              DB Version: Oracle Database 10g Express Edition Release 10.2.0.1.0
              OS Version: Windows 7 enterprise 64 bit
              Did you check logs ? is the installation finished successfully
              • 4. Re: OracleServiceXE service is missing
                985209
                Ya, after installation of a fresh copy, all the services are in place and i can very well access my Database and perform all kind of operations. It happens after few days randomly and things start falliing apart.
                OracleServiceXE goes missing and OracleXETNSListener stops by itself.
                Below is the log from Listener.log

                15-JAN-2013 16:28:14 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=51988)) * establish * XE * 0
                15-JAN-2013 16:34:27 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=52034)) * establish * XE * 0
                15-JAN-2013 16:34:30 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=52039)) * establish * XE * 0
                15-JAN-2013 16:37:44 * service_update * xe * 0
                15-JAN-2013 16:48:48 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=52129)) * establish * XE * 0
                15-JAN-2013 16:48:56 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=52131)) * establish * XE * 0
                15-JAN-2013 16:48:58 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.224.149.84)(PORT=52133)) * establish * XE * 0
                15-JAN-2013 16:57:44 * service_update * xe * 0
                15-JAN-2013 17:27:44 * service_update * xe * 0
                15-JAN-2013 19:34:44 * service_update * xe * 0
                15-JAN-2013 19:54:47 * service_update * xe * 0
                15-JAN-2013 22:05:26 * service_update * xe * 0
                15-JAN-2013 22:45:32 * service_update * xe * 0
                No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8086))(Presentation=HTTP)(Session=RAW))
                15-JAN-2013 23:59:41 * service_died * xe * 12570
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8086))(Presentation=HTTP)(Session=RAW))
                15-JAN-2013 23:59:42 * service_register * xe * 0
                16-JAN-2013 11:11:46 * service_update * xe * 0
                16-JAN-2013 11:21:46 * service_update * xe * 0
                No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC192031.cts.com)(PORT=1521)))
                No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8086))(Presentation=HTTP)(Session=RAW))
                Listener completed notification to CRS on stop
                16-JAN-2013 11:58:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=220181))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

                TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-JAN-2013 16:28:01

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

                System parameter file is D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
                Log messages written to D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
                Trace information written to D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
                Trace level is currently 0

                Started with pid=6056
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC192031.cts.com)(PORT=1521)))
                Listener completed notification to CRS on start

                TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

                TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-JAN-2013 10:18:45

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

                System parameter file is D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
                Log messages written to D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
                Trace information written to D:\Eclipse\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
                Trace level is currently 0

                Started with pid=1944
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC192031.cts.com)(PORT=1521)))
                Listener completed notification to CRS on start

                TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

                Please let me know if you need any other log details.

                Edited by: 982206 on Jan 16, 2013 9:13 PM
                • 5. Re: OracleServiceXE service is missing
                  Krishna-Oracle
                  Hi,
                  Oracle 10g Express edition is not certified on Windows 7 OS
                  10g express edition is certified on
                  Windows 2000 Service Pack 4 or later
                  Windows Server 2003
                  Windows XP Professional Service Pack 1 or later

                  11g express edition is certified on
                  Microsoft Windows XP Professional
                  Microsoft Windows Server 2003 - all editions
                  Microsoft Windows Server 2003 R2 - all editions
                  Microsoft Windows Server 2008 - Standard, Enterprise, Datacenter, Web, and Foundation editions. The Server Core option is not supported.
                  Microsoft Windows 7 - Professional, Enterprise, and Ultimate editions

                  Install 11g express edition on Windows 7 OS

                  Thanks,
                  Krishna

                  Edited by: 858118 on Jan 16, 2013 9:25 PM
                  • 6. Re: OracleServiceXE service is missing
                    Osama_Mustafa
                    Oracle Database 10.2.0.1.0 is not certified on Microsoft Windows x64 (64-bit) 7
                    • 7. Re: OracleServiceXE service is missing
                      985209
                      Ok thanks for the info.
                      The thing is i am using this for quite a time and started facing this issue recently. My colleagues in my workplace are also using the same setup and they never faced this issue.
                      I just dont know why its suddenly start behaving like this.

                      Any suggestions will be of great help.
                      Thanks.
                      • 8. Re: OracleServiceXE service is missing
                        Osama_Mustafa
                        If you are install On Your Own Pc , the Solution would Be Install Virtual Box Or Vmware Software and Create Your Own Environment .
                        • 9. Re: OracleServiceXE service is missing
                          985209
                          I m in office workspace :(