[Oracle10g service and listener started, but sqlplus cannot connect] Solution

In the past few days, Oracle has been installed in the virtual machine. In the system service, the services and listeners have been installed, and:

No problem with tnsping orcl. The connection fails. I interviewed sqlplus system/manager @ orcl on the DOS interface, indicating the wrong user name and password.

 

Solution: DOS:

 

Sqlplus/nolog

 

SQL> Shutdown

 

SQL> startup

 

(This step will report an error. It doesn't matter)

 

SQL> recover database;

 

SQL> alter database open;

 

SQL> exit;

 

If the system user is locked after startup, go to the console to unlock

 

[Screenshot of the operation process]