This discussion is archived
9 Replies Latest reply: Jan 16, 2013 10:24 PM by 985209 RSS

OracleServiceXE service is missing

985209 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    Provide full information about DB version and OS version Please
  • 2. Re: OracleServiceXE service is missing
    985209 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 ACE
    Currently Being Moderated
    Oracle Database 10.2.0.1.0 is not certified on Microsoft Windows x64 (64-bit) 7
  • 7. Re: OracleServiceXE service is missing
    985209 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I m in office workspace :(

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points