Oracle initialization or shutdown in progress solution, oracleshutdown

Oracle initialization or shutdown in progress solution, oracleshutdown

I encountered an error message "oracle initialization or shutdown in SS" when logging on to oracle today. I searched the internet and tried many methods. Finally, I combined several methods to solve the problem!

Cause: I deleted a previously backed up database file by mistake. An error is prompted when I log on to the database again to load data.

Procedure:

1.Run cmd in windows to enter the DOS environment.

2.Log On As a dba user. The specific command is
Sqlplus/NOLOG
SQL> connect sys/change_on_install as sysdba
Tip: Successful

3.

SQL> shutdown immediate
SQL> startup start the service, observe that no data file loading error occurs at startup, and remember the error data file number.
SQL> shutdown immediate stop the service again
SQL> alter database datafile 'G: \ sp001.dbf' offline drop;

The database has been changed.

SQL> alter database open;

The database has been changed.

SQL> startup starts the service. This time it is normal.

4.No error prompted when logging on to SQL * PLUS

Ora-01033: oracle initialization or shutdown in progress solution system and common users can not login, login after

The service is not started, or the Server ip address has changed.
The customer Oracle server enters PL/SQL Developer times ora-01033: oracle initializationg or shutdown in progress error message, the application system cannot connect to the Oracle service. Solve the problem remotely. The process is as follows:
1. Go to CMD and run set ORACLE_SID = fbms to ensure the correct SID is connected;
2. Run sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> startup start the service, observe that no data file loading error occurs at startup, and remember the error data file number.
SQL> shutdown immediate stop the service again
SQL> startup mount
SQL> recover datafile 2 restore the wrong data file
SQL> shutdown immediate stop the service again
SQL> startup starts the service. This time it is normal.
3. Go to PL/SQL Developer for check. No error is displayed.

It cannot be started yet. It may be a file problem,

ORACLE login error: ora-01033: oracle initialization or shutdown in progress solution, Solution

1. mount the database
SQL> startup mount
2 alter system set db_recovery_file_dest_size = 2g scope = spfile;
{Or alter system set DB_RECOVERY_FILE_DEST_SIZE = 4g scope = BOTH ;}
The value of db_recovery_file_dest_size is set based on the remaining disk space and actual needs,
3. Open the database
SQL> alter database open
4. Delete invalid archive logs.
Rman
RMAN> connect target/
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN> exit
5. Restart the database
SQL> shutdown immediate
SQL> startup
See blog.csdn.net/..908204