How to Start and Stop Oracle Database Server on Windows

YouTube video

In this article, we will discuss the step-by-step process of starting and stopping the Oracle database server on Windows. By following these instructions, you will be able to effectively manage your Oracle database and ensure its smooth operation. So, let’s get started!

Starting and Stopping Oracle Database

To start and stop the Oracle database, we first need to access the command prompt on our Windows system. Once we have opened the command prompt, we can proceed with the following steps:

Step 1: Opening Command Prompt

  1. Open the Start menu on your Windows system.
  2. Type “cmd” in the search bar and press Enter.
  3. This will open the Command Prompt window, where we will execute the necessary commands.

Step 2: Starting the Oracle Database

To start the Oracle database, follow these instructions:

  1. In the Command Prompt window, type the following command:

sql
sqlplus / as sysdba

The “/ as sysdba” part of the command is used for system authentication, allowing you to access the Oracle database as an administrator.

  1. Press Enter to execute the command.
  2. Once the command is executed, you will see the version of the Oracle database displayed on the screen, confirming that it has been started successfully.

Step 3: Stopping the Oracle Database

To stop the Oracle database, follow these instructions:

  1. In the Command Prompt window, type the following command:

sql
shutdown immediate

This command will initiate the process to shut down the Oracle database immediately.

  1. Press Enter to execute the command.
  2. The shutdown process may take some time, so please be patient while it completes.
  3. Once the Oracle database is successfully stopped, you can verify it by checking the Task Manager. The Oracle task will no longer consume significant resources.

Step 4: Restarting the Oracle Database

To restart the Oracle database, follow these instructions:

  1. In the Command Prompt window, type the following command:

sql
startup

This command will initiate the process to start the Oracle database.

  1. Press Enter to execute the command.
  2. Just like the shutdown process, the startup process may also take some time. Please wait for it to complete.
  3. Once the database is started successfully, you can close the connection with the database using the “exit” command.
  4. You can also close the Command Prompt window.

Conclusion

By following these simple steps, you can easily start, stop, and restart the Oracle database on your Windows system. It is essential to properly manage your database to ensure its efficient operation and prevent any issues that may arise. Remember to subscribe to our channel for more informative content on Oracle database management.

Thank you for watching!