This discussion is archived
7 Replies Latest reply: Feb 3, 2013 12:53 PM by ranit B RSS

Reg : Oracle and OS -

ranit B Expert
Currently Being Moderated
Hi Experts,

I've a doubt regarding the Oracle Services in Win7 :
When I go to services.msc in my Win7 machine, I can see few Services named -
OracleJobSchedulerXE
OracleMTSRecoveryService
OracleServiceXE
OracleXEClrAgent
OracleXETNSListener

Could you please explain me the use of each one? And, if it is related to the starting of an Instance and mounting of a Database ??

Sometimes, when I start my system and try to connect using SQL*Plus, it gives me some error (can't remember it now). Then, by chance I discovered that starting the OracleServiceXE fixes this.
Just want to know the background concept.

My Database :
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Thanks,
Ranit B.
  • 1. Re: Reg : Oracle and OS -
    Niket Kumar Pro
    Currently Being Moderated
    you can easily find what the services do by google....
    oracleservice<database_name> must be started to start the database...if this service is stopped you cannot start ur database and got error which you don't remeber now :-)
  • 2. Re: Reg : Oracle and OS -
    ranit B Expert
    Currently Being Moderated
    Thanks Niket, But nowhere it was very clear to me.
    So thought to check with experts here, who can share some of their practical knowledge.

    How these services are related to commands - START, START MOUNT, START NOMOUNT, etc...

    Just curious about the underlying concepts about how actually DBAs work. At work, we don't have these access to production server... just developer access. So, trying to understand while at home in my own XE server.
  • 3. Re: Reg : Oracle and OS -
    yoonas Expert
    Currently Being Moderated
    Hi,

    >
    by chance I discovered that starting the OracleServiceXE fixes this.
    Just want to know the background concept.
    >

    To work with oracle database, first thing you have to do is to startup the database, on windows its configured as a service and to start the service automatically. The service has a startup type which controls the automatic starting.

    If you configure this service to be automatic each time you startup your windows machine the oracle database service is also started.

    To startup a oracle database manually you have to run the following commands, windows service is doing it automatically for you.
    sqlplus / as sysdba
    startup
    If you want to understand little more just open the alert log file "<C:\oraclexe\app\oracle\diag\rdbms\xe\xe\trace\>alert_xe.log, see the last line, stop the OracleServiceXE service and reopen the file and see. Eeach time the services is started or stopped the log is updated (log is updated on many other instances also, you can see that if you go throught the file content).

    If you ever find yourself not able to connect to database you can always go to the alert log file and check the status of the database.

    See the windows registry (ORA_XE_AUTOSTART) value also
    http://docs.oracle.com/cd/B28359_01/win.111/b32010/ap_unix.htm#i634279


    Regards
    Yoonas

    Edited by: yoonus on Feb 2, 2013 10:57 PM
  • 4. Re: Reg : Oracle and OS -
    ranit B Expert
    Currently Being Moderated
    Thanks Yoonus!
    This is what I was looking for... Any pointer on the other Services?
  • 5. Re: Reg : Oracle and OS -
    yoonas Expert
    Currently Being Moderated
    See if these links are helpful. You can search google with the service name or service executable name (ex OracleJobScheduler)

    http://docs.oracle.com/cd/B13789_01/win.101/b10113/what_new.htm#CJAFFBHH
    http://docs.oracle.com/cd/E11882_01/win.112/e26104/glossary.htm#CBAFICIE
    http://docs.oracle.com/cd/B28359_01/win.111/b28376/install.htm
    http://docs.oracle.com/cd/E11882_01/network.112/e10836/intro.htm#i455520

    Please read this one if you have not started already http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm

    Edited by: yoonus on Feb 3, 2013 12:22 AM
  • 6. Re: Reg : Oracle and OS -
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    OracleJobSchedulerXE
    provide enterprise scheduling functionality,External jobs performed by the user,This service is disabled by default. In order to use the external jobs functionality, the administrator must set the username and password for the user account under which this service must run, and enable the service.

    You Can check : http://www.stanford.edu/dept/itss/docs/oracle/10g/win.101/b10113/what_new.htm
    OracleMTSRecoveryService
    databases to be used as resource managers in Microsoft Transaction Server-coordinated transactions, providing strong integration between Oracle solutions and Microsoft Transaction Server.

    Reads Post by Expert Hans about that :
    What is the function of OracleXEClrAgent and OracleMTSRecoveryService?
    OracleServiceXE
    For oracle Database.
    OracleXEClrAgent
    provides the host for the Microsoft Common Language Runtime - documented in the "Oracle Data Provider for .NET Developer's Guide" and "Oracle Database Extensions for .NET Developer's Guide.

    The Same Reply by Hans in above thread.
    +OracleXETNSListener+
    This services used to control Oracle database listener.
  • 7. Re: Reg : Oracle and OS -
    ranit B Expert
    Currently Being Moderated
    Thanks Yoonus and Osama, the explanations were really helpful.

Legend

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