| ORA-03113: end-of-file on communication channel [message #137622] |
Thu, 15 September 2005 14:25  |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
hi gurus,
I upgraded the Oracle 9.0.1.1.1 to Oracle 9.2.0.1.0.The OS is Windows XP.Now the problem is , when I shutdown my database(except shutdown abort) it showing 'ORA-03113: end-of-file on communication channel'.The same error is occuring when I startup the database.
Eg:
SQL> shutdown immediate;
ORA-03113: end-of-file on communication channel
------------
SQL> startup
ORACLE instance started.
Total System Global Area 122755896 bytes
Fixed Size 453432 bytes
Variable Size 88080384 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Databasemounted.
ORA-03113: end-of-file on communication channel
SQL>
Please give me a solution for this
Thanks
Rajesh
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #137761 is a reply to message #137757] |
Fri, 16 September 2005 10:35  |
mrmarath
Messages: 23
Registered: July 2005
|
Junior Member |
|
|
Hi Alan,
It was not there before my upgrade.After upgrade I got this error and invalid objects error too.Soon after my upgrade , I could connect as sysdba without any error.If i connected as any other DBA user it showed ORA-00600 error & some application package error and then I got connected.As per my friend ,I executed 'standard.sql' .Then this problem solved.Then the next error was I couldnt access any dynamic views or DBA_* views.Then, I executed catalog.sql and catproc.sql.Again, I solved that error.I can access all views now.The current error is 'ORA-03113: end-of-file on communication channel' as i mentioned above.How to solve this issue?
I'll explain how I did upgrade from 9.0.1.1.1 to 9.2.0.
There was no error in my previous release.I just put oracle 9.2 software and started as normal installation, instead of creating database, i selected software only option(It was my experiment!).Could you please suggest a good method for upgrading, if this one(what I tried) is not a suggested method.
Thanks in advance
Rajesh
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #140082 is a reply to message #137761] |
Fri, 30 September 2005 14:24 |
AnalystParth
Messages: 15
Registered: September 2005
Location: India
|
Junior Member |
|
|
Rajesh,
If I understand right, you have not upgraded the datafiles, but have just copied them over to the new oracle home and started it up?
If that be the case then, any kind of unexpected errors are possible as that is not the recommended upgrade route.
Please follow the metalink note for the upgrade from 9.0 to 9.2 all other methods are non standard and unsupported.
--Parth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
