Oracle sysdba is logged on normally, and other users cannot log on

 

Today, a user's database suddenly finds that all clients cannot connect. However, sysdba users can log on normally;

 

First, it is suspected that someone has set the database to the silent mode.

 

Log on to the database on the server, check the status, and find that the mode is not silent

 

When trying to restart the database, a 12560 error is prompted during connection. set ORACLE_SID decisively, that is, run the command set ORACLE_SID = XXX.

 

After Login

 

Shutdown immediate;

 

Startup nomount is normal

 

Alter database mount is normal

 

Alter database open

 

An error occurred while prompting the file with an undo tablespace,

 

Use recover datafile # repair

 

Then it is normal to open the database.

 

 

 

The cause is that a data file has an error, but you have not understood why the data file is damaged and recorded.

 

 

 

This article is from the "listener" blog