您好,欢迎光临! 请 |

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

作者: | 分类:Experiments, Oracle | Tag:, | 评论:1 
字号:T|T

Tonight,after I did some changes on the parameter(processes,changed it from 150 default to 2),I issued the commands below:

SQL> alter system set processes=2 scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

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

SQL> !oerr ora 03113

03113, 00000, "end-of-file on communication channel"

// *Cause: The connection between Client and Server process was broken.

// *Action: There was a communication error that requires further investigation.

//          First, check for network problems and review the SQL*Net setup.

//          Also, look in the alert.log file for any errors. Finally, test to

//          see whether the server process is dead and whether a trace file

//          was generated at failure time.

So,I got the error  ORA-03113,now I know the reason for this is that i changed the 'process' parameter to a too small.But I didn't know the truly fact.

After that,i had to connect again,and startup the database using a pfile,and recreate a new spfile from the pfile.


SQL> alter system set processes=2 scope=spfile;
System altered.
顶一下
(0)
100%
踩一下
(0)
100%

原创内容,转载时请保留原文信息:
文章标题:ORA-03113: end-of-file on communication channel
↑上一篇↑:
↓下一篇↓:

1 篇回应 (访客:1 篇, 博主:0 篇)

  1. Rix Chan 2014-23-03

    如果没有pfile 文件怎么办吖?

    #-49楼

插入图片

NOTICE1:请申请gravatar头像,没有头像的评论可能不会被回复|头像相关帮助!