A2oz

How to Create an Oracle Service in Windows?

Published in Database Administration 3 mins read

Creating an Oracle service in Windows involves registering an Oracle executable with the Windows Service Control Manager (SCM). This allows the Oracle process to run automatically in the background, even when no user is logged in. Here's how you can do it:

1. Locate the Oracle Executable

  • Identify the specific Oracle executable that you want to run as a service. This could be the Oracle Database server, the Oracle Listener, or any other Oracle component.
  • Typically, these executables are found in the Oracle installation directory, usually under \bin or \admin.
  • For example, the Oracle Database server executable might be called ORACLE_HOME\bin\oracle.exe.

2. Use the ORACLE_HOME\bin\srvctl Utility

  • The srvctl utility is a powerful command-line tool provided by Oracle that allows you to manage Oracle services.
  • To create a new service using srvctl, you'll need to use the create service command.
  • For example, to create a service named MY_ORACLE_SERVICE for the Oracle Database server, you would use the following command:
    srvctl create service service_name=MY_ORACLE_SERVICE target=database
  • Replace database with the appropriate target for your Oracle service. You can also specify additional configuration options like startup_type or display_name.

3. Use the ORACLE_HOME\bin\oradim Utility

  • The oradim utility is another tool that can be used to manage Oracle services.
  • You can use oradim to create a new service by running the oradim command with the -new option and specifying the service name, executable path, and other configuration details.
  • For example:
    oradim -new -sid ORCL -startmode=auto -pfile $ORACLE_HOME/dbs/initORCL.ora -service_name MY_ORACLE_SERVICE

4. Verify the Service Creation

  • After creating the service, you can use the Windows Services Manager (services.msc) to verify that the service was successfully created and is running.
  • You should see your newly created service listed in the Services Manager. You can then start, stop, or restart the service from there.

5. Example: Creating a Service for the Oracle Listener

  • Executable: ORACLE_HOME\bin\lsnrctl.exe
  • Service Name: MY_LISTENER_SERVICE
  • Command:
    srvctl create service service_name=MY_LISTENER_SERVICE target=listener

6. Additional Considerations

  • You can use the srvctl or oradim utilities to configure various service settings like startup type, display name, and dependencies.
  • Refer to the Oracle documentation for detailed instructions and specific options for your Oracle version.

Related Articles