Home > database >  Database connection error 01033
Database connection error 01033

Time:09-29

Power cuts after restart the Oracle database connection error to 01033
Request the alter database open; At 00600 error
Request to recover the database error at 00282 and 00264

CodePudding user response:

@ xifenfei

CodePudding user response:

According to the http://www.xifenfei.com/oracle_recovery_check script to collect the information to send me, we to assess (email and phone)

CodePudding user response:

1, into the CMD, perform set is=FBMS, ensure to connect to the correct SID;
2, run up sqlplus "/as sysdba"
SQL> Shutdown immediate stop service
SQL> Startup start the service, you have no data file loading error observation start, and remember the error data file label
SQL> Shutdown immediate stop service again
SQL> Startup the mount
SQL> Recover datafile 2 error recovery data files
SQL> Shutdown immediate stop service again
SQL> Startup to start the service, this is normal,
3, the entrance for examination to a PL/SQL Developer, no errors,
  • Related