Shut down an Oracle database instance using SQL*Plus (Windows systems)

Procedure Log on to the operating system as a user with administrator privilege. To connect as internal (without a password), this account must be part of the Windows ORA_DBA local group. Manually set the Oracle environment by entering the following commands: Copy set ORACLE_HOME=Oracle-home-path set ORACLE_SID=tc set PATH=%PATH%;%ORACLE_HOME%\bin Start the Oracle SQLPlus utility: Copy %ORACLE_HOME%\bin\sqlplus Log on to SQL. At the SQLPLUS prompt, type the following command: Copy connect / as sysdba The following system message is displayed: Copy Connected. At the SQLPLUS prompt, type the following command: Copy shutdown A system message similar to the following is displayed: Copy Database closed. Database dismounted. ORACLE instance shut down. The Oracle database is shut down. Exit the SQLPlus utility by entering the following command at the SQLPLUS prompt: Copy exit