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

我手动启动遇到了一个问题：

停止在这里

[grid@m1 ~]$  crs_start ora.mes.db

Attempting to start `ora.mes.db` on member `m1`

Attempting to start `ora.FRA.dg` on member `m2`

Attempting to start `ora.DATA.dg` on member `m3`

Start of `ora.FRA.dg` on member `m2` succeeded.

Attempting to start `ora.mes.db` on member `m2`

Start of `ora.DATA.dg` on member `m3` succeeded.

Attempting to start `ora.mes.db` on member `m3`

CRS-5017: The resource action "ora.mes.db start" encountered the following error: 

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

Process ID:  26872

Session ID: 288 Serial number: 1

. For details refer to "(:CLSN 00107:)" in "/u01/app/grid/11.2.0/log/m3/agent/crsd/oraagent_oracle/oraagent_oracle.log".

Start of `ora.mes.db` on member `m3` failed.

Attempting to stop `ora.mes.db` on member `m3`

Stop of `ora.mes.db` on member `m3` succeeded.

CRS-2632: There are no more servers to try to place resource 'ora.mes.db' on that would satisfy its placement policy

m3 的数据库不能通过命令  crs_start ora.mes.db 启动。

m1 m2 m3 三台机器都出现了这个情况 

m3 的数据库不能通过命令  crs_start ora.mes.db 启动。

数据库RAC环境安装好了之后，我没有检查过但是过了一段时间之后

1、3台数据库全部停了 

2、3台数据库 全部出现 ORA- 01155: the database is being opened, closed, mounted or dismounted

3、我怀疑是归档的问题。 查看alter.log 出现：

     最多的就是 文件不归档：

    解决：

asmcmd

ls  

cd data 

mkdir  arch 

exit

             

ORACLE RAC 启用归档

 

1、关闭所有节点数据库实例
c:>srvctl stop database -d RACDB

 

2、修改服务器配置参数
sql>startup mount
sql>alter system set cluster_database=false scope=spfile;
sql>shutdown immediate

 

3、调整归档日志路径
sql>startup mount
sql>alter system set log_archive_dest_1='LOCATION=+RAC_DISK' scope=spfile sid='RACDB1';
sql>alter system set log_archive_dest_1='LOCATION=+RAC_DISK' scope=spfile sid='RACDB2';

 

调整归档日志文件命名方式
sql>alter system set log_archive_format ='arch1_%s_%R_%T.arc' scope=spfile sid='RACDB1';
sql>alter system set log_archive_format ='arch2_%s_%R_%T.arc' scope=spfile sid='RACDB2';

 

4、开启归档日志
sql>alter database archivelog
sql>alter database open

 

5、恢复服务器配置参数
sql>alter system set cluster_database=true scope=spfile;
sql>shutdown immediate;

 

6、打开所有节点数据库实例
c:>srvctl start database -d RACDB

 

7、检查归档日志是否已启用
c:>sqlplus / as sysdba;
sql>archive log list;

 

说明：
其中2~5、7是在单节点下操作的

*************************************************************

ARCH: Error  19504 Creating archive log file to '+FRA'

Errors in file /u01/oracle/diag/rdbms/mes/mes3/trace/mes3_ora_ 14163.trc:

ORA- 16038: log 5 sequence# 13 cannot be archived

ORA- 19504: failed to create file ""

SQL> archive log list

ORA- 01155: the database is being opened, closed, mounted or dismounted

SQL> 

下面附上日志文件