ORA-03113 Solution
Scenario:
A solution to full ORA-00257 archiving logs the archived logs described in this log are full (SEE ).
Now I want to switch the database to non-archive mode. Refer to how to start or disable Oracle ARCHIVELOG mode for operations (SEE), but the shutdown immediate is stuck.
At this time, I restarted the Windows Oracle database server.
Connecting to the database again encountered a problem that addressed the ORA-01034 and ORA-27101 error when connecting to Oracle 11g. (See)
Solution:
Connect to oracle AS sysdba
C: \ Documents ents and Settings \ Administrator> sqlplus/nolog
SQL> conn/as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Access to the mount status:
Startup mount;
Switch the database to non-archive mode: How to enable or disable the ARCHIVELOG mode of Oracle
Alter database noarchivelog;
Alter database open;
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian