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

This article mainly shows you "what to do when there are ORA-27101 errors in oracle", the content is simple and clear, and I hope it can help you solve your doubts. Let the editor lead you to study and learn "what to do when there are ORA-27101 errors in oracle".

When logging in to oracle users, report these two errors, read some blog content, personally feel that their own database problems may not be so complicated, infer the reasons for the failure are as follows

Due to the abnormal shutdown of the previous database server, the database was shut down abnormally, and the machine was shut down directly without shutting down the database.

Solution:

1. Log in to the database with sysdba: sqlplus / as sysdba

[oracle@localhost admin] $sqlplus / as sysdba

two。 Restart the database: startup

3. Log in to the test with system users

As a result, you can log in normally.

The above is all the contents of the article "what to do if there is an ORA-27101 error in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.