Step 5 - Starting and Shutting Database
Learn Oracle - Starting and Shutting Down the Database Instance on Windows
Oracle DBA can start and shut down your Oracle database with the Windows Services
To start Oracle, Oracle DBA must start three services:
OracleService, which is your Oracle Database instance
OracleTNSListener, which is your listener required to allow
clients to connect to your database
OracleDBConsole, which enables clients to connect to
To start these services:
From the Control Panel, select Administrative Tools->Services. A list of all
available services on Oracle DBA system appears.
Locate the three Oracle services listed earlier. For example, if your SID is Sales1
and Oracle home is OraHome10, then locate the following services:
Start all three services. Oracle DBA can start a service by right-clicking the service, and
selecting Start. Oracle DBA can also choose Start from the Actions menu. If Oracle DBA double
click the service, the service properties page appears where Oracle DBA can Start or Stop
the service, and select your Startup Type.
To shut down the database, Oracle DBA do the reverse: locate the services and stop them, by
selecting Stop from the Actions menu.