Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to restart the Oracle database". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to restart the Oracle database".

Restart the database

Open secureCRT and connect to the linux machine where the database is located. If the user is root, enter the command "su-oracle" and enter. If you want a password,

Enter the password and enter, and then switch to the oracle user. (the picture shows that it has been switched to the oracle user)

How to restart oracle database under linux

two

Turn off the listener process of oracle: the command is "lsnrctl stop" and enter, and the external connection to the database is no longer possible. If there is a prompt in the picture to close the success message.

three

Kill all session first, and the editor uses the command: "ps-ef | grep $ORACLE_SID | grep-v ora_ | grep LOCAL=NO | awk'{print $2}'| xargs kill" can also be used in other ways.

Then log in to the database using sqlplus. The command is "sqlplus / nolog"-"connect / as sysdba", and finally closes the oracle database "shutdown immediate" with the command.

It takes some time to close the command.

four

Exit sqlplus with the command "exit". Then start the listening process of the database with the command "lsnrctl start".

five

As in step 3, log in to the database using sqlplus first. The command is: "sqlplus / nolog"-"connect / as sysdba".

Then enter the command "startup" and enter. Finally, exit sqlplus with the command "exit".

Thank you for your reading, the above is the content of "how to restart the Oracle database", after the study of this article, I believe you have a deeper understanding of how to restart the Oracle database, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.