Asher/ 十二月 14, 2009/ Experiments, Oracle/ 1 comments

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.
Share this Post

1 Comment

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

Leave a Comment

电子邮件地址不会被公开。 必填项已用*标注

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>