Ora-03113:end-of-file on communication channel

Today in the virtual machine Oracle is not open, depressed for a long time, the results of searching the internet search answers, patchwork
, finally set up. Now the operation of the steps sorted out, one to share with you, and then to their own case. Oh ~
[oracle@rhel5 ~]$ sqlplus/nolog
sql*plus:release 11.2.0.1.0 Production on Sat 15:34:45 Ight (c) 1982, 2009, Oracle. All rights reserved.
sql> conn/as sysdba
Connected to a idle instance.
Sql> Startup
ORACLE instance started.
Total System Global area 730714112 bytes
Fixed Size 2216944 bytes
Variable size 268438544 bytes
Database buffe Rs 452984832 bytes
Redo buffers 7073792 bytes
Database mounted.
Ora-03113:end-of-file on communication channel
Process id:8698
Session id:63 serial Number:5

Sql> Startup Nomount
ORACLE instance started.
Total System Global area 730714112 bytes
Fixed Size 2216944 bytes
Variable Size 268438544 bytes
Database buffers 452984832 bytes
Redo buffers 7073792 bytes
There is no problem with the nomount phase. In the Nomount phase, Oracle first looks for the parameter file (pfile/spfile), and then
Based on the settings in the parameter file, create an instance, allocate memory, and start the background process. So this phase only
To have a parameter file, you can start the instance without requiring any control of the file or data file
Participation. Therefore, we can exclude the system configuration (kernel parameters, etc.) problems.

Next look at the mount phase
Sql> ALTER DATABASE Mount;

Database altered.
Ok. Mount phase passed. There is no problem with the control file.

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
ERROR at line 1:
Ora-03113:end-of-file on communication channel
Process id:9219
Session id:63 Serial Number:3
The open phase finally showed 03113 errors. The information given in the prompt is still incomplete. We want to see
The record in the alarm log. In fact, the general Oracle encountered problems, our first thought is to view the police
Log alert, I also know after the sleep. Ha ha. OK, let's take a look at the warning log.
I would like to mention here that my Oracle version is 11GR2. And 11g is a much bigger change.
An alert file in an XML file format, while XML-formatted files are not friendly to view under the character interface
And, even more puzzling, the XML file is stored in the default location of previous version alert. So the text lattice
Where is the alert file of the type? Take a look at the dynamic view V$diag_info.
Sql> select * from V$diag_info;

inst_id NAME VALUE
---------- ------------------------------ ----------------------------------------
1 Diag Enabled TRUE
1 ADR base/oracle
1 ADR HOME/ORACLE/DIAG/RDBMS/ORCL/ORCL
1 Diag trace/oracle/diag/rdbms/orcl/orcl/trace
1 Diag Alert/oracle/diag/rdbms/orcl/orcl/alert
1 Diag incident/oracle/diag/rdbms/orcl/orcl/incident
1 Diag cdump/oracle/diag/rdbms/orcl/orcl/cdump
1 Health Monitor/oracle/diag/rdbms/orcl/orcl/hm
1 Default Trace File/oracle/diag/rdbms/orcl/orcl/trace/orcl_
Ora_9219.trc
---------- ------------------------------ ----------------------------------------
The XML format alert is in the directory corresponding to Diag alert, and the text format alert is stored in the diag trace corresponding
Table of Contents. Come on, let's take a look at the/oracle/diag/rdbms/orcl/orcl/trace.
[Oracle@rhel5 ~]$ Cd/oracle/diag/rdbms/orcl/orcl/trace
[Oracle@rhel5 trace]$ ls
Alert_orcl.log ORCL_M000_19221.TRM ORCL_MMAN_8647.TRM ORCL_ORA_23621.TRM
Orcl_arc0_26094.trc orcl_m000_19807.trc orcl_mman_9204.trc .....
Find Alert_orcl.log. What are you waiting for, direct vi,shift+g.
-----------------------------------------------------------------------------------
Sat Mar 31 16:19:23 2012
ALTER DATABASE Open
Sat Mar 31 16:19:23 2012
Lgwr:starting ARCH Processes
Sat Mar 31 16:19:23 2012
ARC0 started with pid=18, OS id=10286
Arc0:archival started
Lgwr:starting ARCH Processes COMPLETE
Arc0:starting ARCH Processes
Errors in FILE/ORACLE/DIAG/RDBMS/ORCL/ORCL/TRACE/ORCL_ORA_9219.TRC:
ora-19504:failed to create file "/BACKUP/ARCH_LOG/1_23_779060511.DBF"
Ora-27040:file create error, unable to create file
Linux-x86_64 Error:13:permission denied
Arch:error 19504 Creating archive log file to '/backup/arch_log/1_23_779060511.dbf '
Sat Mar 31 16:19:25 2012
ARC1 started with pid=19, OS id=10288
Errors in FILE/ORACLE/DIAG/RDBMS/ORCL/ORCL/TRACE/ORCL_ORA_9219.TRC:
Ora-16038:log 2 sequence# cannot be archived
ora-19504:failed to create File ""
Ora-00312:online Log 2 thread 1: '/oracle/oradata/orcl/redo02.log '
USER (ospid:9219): Terminating the instance due to error 16038
-------------------------------------------------------------------------------------
Originally cost half a day to find out the problem, unexpectedly permission denied. No, check the archive log.
Permission to record it.
[Oracle@rhel5 trace]$ CD/
[Oracle@rhel5/]$ LL
Total 211
Drwxr-xr-x 3 root 4096 Mar 10:52 backup
-rw-r--r--1 root root 549 Oct 6 13:20 Backup.log
Drwxr-xr-x 2 root root 4096 Oct 3 11:23 Bin
Drwxr-xr-x 4 root 1024 Sep
...........................................
Make me blush. To make such a low-level mistake. Let's not talk nonsense now. directly on the steps.
[Root@rhel5 ~]# chown-r Oracle:oinstall/backup
[Root@rhel5 ~]# chmod-r 775/backup
[Oracle@rhel5 ~]$ Sqlplus/nolog
Sql*plus:release 11.2.0.1.0 Production on Sat Mar 31 16:25:33 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Sql> Conn/as SYSDBA
Connected to a idle instance.
Sql> Startup
ORACLE instance started.
Total System Global area 730714112 bytes
Fixed Size 2216944 bytes
Variable Size 268438544 bytes
Database buffers 452984832 bytes
Redo buffers 7073792 bytes
Database mounted.
Database opened.
The database was successfully opened. In a disgrace!