How to Shutdown Oracle Database in Windows?

5 Administering a Database on Windows

Go to your Oracle Database server.
Start SQL*Plus at the command prompt: C:\> sqlplus /NOLOG.
Connect to Oracle Database with username SYSDBA: SQL> CONNECT / AS SYSDBA.
To start a database, enter: SQL> STARTUP [PFILE=path\filename] ...
To stop a database, enter: SQL> SHUTDOWN [mode]

How do you Shutdown a Database?

SHUTDOWN IMMEDIATE.
SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
> sqlplus.
Enter user-name: sys as sysdba Enter password:
SQL> select instance_name, status from v$instance;

How do I Shutdown an Oracle Instance?

Open a terminal window as the oracle user.
Log in to SQL*Plus as the SYSDBA user.
Issue the SHUTDOWN command to close the database and shut down the instance.
Issue the STARTUP command to start the instance and open the database.

How do I Know if Oracle is Running on Windows?

Log on to the host where the Oracle database resides.
Change to the following directory : Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
Repeat step 3 to verify that the TNS listener is running.

How do you Stop a Database?

On Windows: Click Start, point to Programs or All Programs, point to Oracle Database 11g Express Edition , and then select Stop Database.
On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Stop Database.