About Ways to Manage Oracle Database Services
Learn how to manage the services that Oracle Database installs on your computer.
- Overview of Oracle Database Service Naming Conventions for Multiple Oracle Homes
Oracle Database for Windows lets you have multiple Oracle homes on a single computer. - Starting Oracle Database Services
Oracle Database services must be started for you to use Oracle Database and its products. - Stopping Oracle Database Services
On occasion (for example, when reinstalling Oracle Database), you must stop Oracle Database services. - Auto-Starting Oracle Database Services
Oracle Database services can be set to start automatically whenever you start the Windows computer.
Parent topic: Administering a Database on Windows
Overview of Oracle Database Service Naming Conventions for Multiple Oracle Homes
Oracle Database for Windows lets you have multiple Oracle homes on a single computer.
This feature, described in Appendix B, "Optimal Flexible Architecture", in Oracle Database Installation Guide for Microsoft Windows, affects Oracle Services naming conventions. As you perform installations into Oracle home directories:
-
You must accept the default Oracle home name provided or specify a different name for each Oracle home directory.
-
You are prompted to give a system identifier and a global database name for each database installation.
Starting Oracle Database Services
Oracle Database services must be started for you to use Oracle Database and its products.
You can start Oracle Database services by:
-
Using the Control Panel
-
Using the Command Prompt
Using the Control Panel
To start Oracle Database services from the Control Panel:
-
Access your Windows Services dialog box.
See Also:
Your operating system documentation for instructions
-
Find the service to start in the list, select it, and click Start.
If you cannot find
OracleService
SID
in the list, then use ORADIM to create it. -
Click Close to exit the Services dialog box.
Using the Command Prompt
To start Oracle Database services from the command prompt, enter:
C:\> NET START service
The variable service
is a specific service name, such as OracleServiceORCL.
Related Topics
Parent topic: About Ways to Manage Oracle Database Services
Stopping Oracle Database Services
On occasion (for example, when reinstalling Oracle Database), you must stop Oracle Database services.
You can stop Oracle Database services from three different locations:
-
Using the Control Panel
-
Using the Command Prompt
Using the Control Panel
To stop Oracle Database services from the Control Panel:
-
Access your Windows Services dialog box.
See Also:
Your operating system documentation for instructions
-
Select
Oracle
HOMENAME
TNSListener
and click Stop.Oracle
HOMENAME
TNSListener
is stopped. -
Select
OracleService
SID
and click Stop. -
Click OK.
OracleService
SID
is stopped.
Using the Command Prompt
To stop Oracle Database services from the command prompt, enter:
C:\> net STOP service
The variable service
is a specific service name, such as OracleServiceORCL
.
Related Topics
Parent topic: About Ways to Manage Oracle Database Services
Auto-Starting Oracle Database Services
Oracle Database services can be set to start automatically whenever you start the Windows computer.
You can turn auto-start on or off by using the Control Panel.
Using the Control Panel
To use the Control Panel to configure when and how Oracle Database is started:
-
Access your Windows Services dialog box.
See Also:
Your operating system documentation for instructions
-
Select the service OracleServiceSID and click Startup.
-
Select Automatic from the Startup Type field.
-
Click OK.
-
Click Close to exit the Services dialog box.
Parent topic: About Ways to Manage Oracle Database Services