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!