Learning ORACLE recently encountered a terrible problem, always can't log in database, the following problems

Reason is that the Oracle instance is shut down, to illustrate the solution below:
Enter the SQL Plus, input sys as sysdba and password below:

Then enter the startup, the process will be a little long, silently waiting for, finished is as follows:

So you can login to the database!
Found that there is a new problem,

The solution is as follows:

CodePudding user response:

Thanks for sharing, it is recommended that the record in a blog post,

CodePudding user response:

Alter all don't need the user now