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!