7 Replies Latest reply: Feb 3, 2013 2:53 PM by ranit B RSS

    Reg : Oracle and OS -

    ranit B
      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
          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
            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
              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
                Thanks Yoonus!
                This is what I was looking for... Any pointer on the other Services?
                • 5. Re: Reg : Oracle and OS -
                  yoonas
                  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
                    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
                      Thanks Yoonus and Osama, the explanations were really helpful.