No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


How do I stop the Oracle database

Publication Date:  2016-11-21 Views:  707 Downloads:  0

Issue Description

How do I stop the Oracle database?


Before stopping the Oracle database, check whether the Oracle database has started.

1. Log in to the SUSE Linux as user oracle.

2. On the command line interface (CLI), run the following command to connect to the Oracle database:
$ sqlplus / as sysdba

The user name and password are required in remote login mode. The following describes how to use the command to connect the system user to the Oracle database with password testpwd.
$ sqlplus system/testpwd as sysdba
If the information similar to the following is displayed, the system user is connected to the Oracle database:

3. Run the following command to stop the Oracle database:
> shutdown immediate

If the following information is displayed, the Oracle database is already stopped.
Database closed.
Database dismounted.
ORACLE instance shut down.