Home  >  Article  >  How to restart Oracle database

How to restart Oracle database

angryTom
angryTomOriginal
2020-02-29 12:15:3415997browse

How to restart Oracle database

Oracle method to restart the database

1. Enter the Linux system with the Oracle account under Linux.

2. Execute the following command to check the status of the database listener:

lsnrctl status

3. Execute the following command to stop the database listener:

lsnrctl stop

4. Execute the following command to enter SQLPlus :

sqlplus /nolog
conn /as sysdba
shutdown immediate

5. Execute the following command to exit SQLPlus:

Exit

6. Start and view the database listener:

lsnrctl start
lsnrctl status

7. Start the Oracle database:

sqlplus /nolog
conn /as sysdba
startup

Enter sqlplus command under window: sqlplus / as sysdba

Enter sqlplus command under Linux: sqlplus "/as sysdba"

PHP Chinese website, a large number of mysql introductory videos , welcome to learn!

The above is the detailed content of How to restart Oracle database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn