Oracle database services on windows

The main services of oracle database in windows operating system are as follows
  1. OracleServiceORCLThis is the main DBMS service that runs the database engine. On a server this should be set to automatically start when the server boots up. If you will only use Oracle once in a while, you may wish to set this to start manually. This way you can turn it on when you need it.
  2. OracleOraDb11g_home1TNSListener  - This is the “listener” service that allows Oracle clients to connect to the database running on your server. By default it will open up TCP port 1521 to accept incoming connections and then forward those connections to the database service. Most of the Oracle development tools and middle ware will need to be able to talk to this service. 
  3. OracleOraDb11g_home1ClrAgent - This is the service that supports .NET connections and executions within Oracle database. The CLR stands for Common Language Run time which is Microsoft’s “virtual machine” environment for running .NET applications (e.g., written in C# or Visual Basic.NET). If you do not plan on using .NET, this service can be safely disabled or left on Manual setting.
  4. OracleMTSRecoveryService-  This is the Microsoft Transaction Services integration service that allows Oracle databases to participate in distributed transactions. Unless you will be developing MTS applications, you may leave this service set on Manual setting.
  5. OracleJobScheduler- This service supports the Oracle remote jobs scheduling package. If you do not intend on writing applications with the DBMS_SCHEDULER, you may leave this service Disabled.
  6. OracleDbConsoleORCL - This service supports the Oracle Enterprise Manager web service that runs on port 1158.
  7. Oracle ORCL VSS Writer Service - This service supports the Oracle Volume Shadow Copy backup and recovery functions. Even though it is set for Manual start-up, it will start when the main Oracle database starts up.
Learn how to start and stop oracle database services manually using simple script click the link to view:- Oracle database services script




 

    Previous
    Next Post »