ORA-03113: end-of-file on communication channel
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.
Categories: Experiments, Oracle | 
Tags: Experiments, Oracle | 
86 Comments »
Good Post, Each and every and every Stage is good Sufficient.Many thanks for sharing with us your wisdom.
so Properly. Your site is Properly Believed out, graphically Amazing and full of great Guidance. Kudos.
This is a great post. Thanks for sharing this.
I wanted to thank you for this great read!! I definitely enjoying every little bit of it.I have you bookmarked to check out new stuff you post.
Thank you for writing on this subject. Using Yahoo for the first time, found your blog.
You can definitely see your enthusiasm in the work you write. The world hopes for more passionate writers like you who aren?¯t afraid to say how they believe. Always go after your heart.
I’ve got to, I’ve nat been on this site in a long time… but t’was another lovely experience to see t’s such an important subject & ignored by many.
your new share!
I liked seeing this, are you on twitter?
Have you noticed additional visitors to your web site recently?!? You’re all in excess of Bing research!?! I honestly like your blog page, appreciation repeatedly.
I’ve really enjoyed reading your post and glad I came across. Its really informative and the way your write it makes it really interesting to read. Keep up the good work, be looking forward to your new post.
That is some enlightening information there; never really viewed it carefully like that; i think more discussion on topics like this make the information more believable.
You can definitely see your enthusiasm in the work you write. The world hopes for more passionate writers like you who aren?¯t afraid to say how they believe. Always go after your heart.
I Adore it,Great article.I am Determine to Placed this into use one of these Mornings.Thank you for sharing this.To Your Success!
Hey,I just find your website doesnt appear right under IE8. I think it’s because of some CSS problems. Please check it. BTW, very nice blog! Thanks,John Z.<a href=’http://www.pdfebooksdownloads.com’>PDF</a>
Come on and Maintain writting your blog will be A Great deal more attractive. To Your Success!
Been looking for this article for long time ago and finally found here. thanks for sharing this post. appreciate!
about Far more new Concepts
Hi can I ask who your webmaster is?
so Properly. Your site is Properly Believed out, graphically Amazing and full of great Guidance. Kudos.
I love ur post! Appreciate it!
I’d recommend this because it’s actually readable. Unusual — sad but true.
It’s mind boggling how many information and news come out on a weekly basis.
Amazing post Maki. Like Examining copywriting E book from Joe Sugarman or Dan Kennedy. Now I just have to Utilize the
A Really amazing article. Many thanks for sharing you?e wealth of Information with us When Once more. It? no wonder your blog does
This site intrigues me and is very informative.
Wow!, this was a top quality post. In theory I’d like to write like this too – taking time and real effort to make a good article… but what can I say… I procrastinate a lot and never seem to achieve anything
Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me.
What a blogpost!! Very informative and also easy to understand. Looking for more such blogposts!! Do you have a twitter?
I recommended it on digg. The only thing that it’s missing is a bit of new design. Nevertheless thank you for this information.
Nice level of details here. There is so significantly data all-around about this topic that sometimes you cannot see the wood for the trees but you might have pitched this at just the proper level so that the lay person can realize – thank you!
Its not easy to find something of value on the internet. Fortunately your article proved to be different and really helpful. I hope you” keep up the good work.
Awesome article! thanks for the good read!
I usually don’t post in Blogs but your blog forced me to, amazing work.. beautiful …
Can find the RSS button. I want to follow!
Spotted a link to this post over at Delicious. Thanks for posting it. I’m sure I’ll be back one day.
Spotted a link to this post over at Stumbleupon. Thanks for posting it. I’m sure I’ll be back one day.