Home » RDBMS Server » Server Administration » ORA-03113: end-of-file on communication channel
ORA-03113: end-of-file on communication channel [message #60735] Tue, 02 March 2004 01:08 Go to next message
Sachin
Messages: 52
Registered: May 2001
Member
HI,

I am getting this error ORA-03113: end-of-file on communication channel while connecting to the database using t_init1.ora file

startup force pfile=t_init1.ora
ORACLE instance started.

Total System Global Area 219907312 bytes
Fixed Size 742640 bytes
Variable Size 201326592 bytes
Database Buffers 16777216 bytes
Redo Buffers 1060864 bytes
Database mounted.
ORA-03113: end-of-file on communication channel

Can you tell me why I am getting this and what could be the solution?

Thanks,

Sachin
Re: ORA-03113: end-of-file on communication channel [message #60739 is a reply to message #60735] Tue, 02 March 2004 03:04 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Anything in your ALERT.LOG file (located in your BDUMP directory)?

Best regards.

Frank
Re: ORA-03113: end-of-file on communication channel [message #60742 is a reply to message #60739] Tue, 02 March 2004 04:34 Go to previous messageGo to next message
Sachin
Messages: 52
Registered: May 2001
Member
Hi Frank,

There is nothing, actually BDUMP paramter has not been set up though I got some other message when opening the database.

$ sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 2 04:28:53 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

$ sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 2 04:28:53 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> startup force pfile=t_init1.ora quiet
ORACLE instance started.
Database mounted.
ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release 8.1.0.0.0
ORA-00405: compatibility type "LOB Retention"

I could not understand much on this part though it is saying about non compatibility between two versions.

Thanks,

Sachin
Re: ORA-03113: end-of-file on communication channel [message #60810 is a reply to message #60742] Mon, 08 March 2004 03:46 Go to previous messageGo to next message
Pradeep George
Messages: 6
Registered: March 2004
Junior Member
Please check your compatible parameter set in init.ora
Re: ORA-03113: end-of-file on communication channel [message #60913 is a reply to message #60735] Fri, 12 March 2004 09:32 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Check your system variables .. specially ORACLE_HOME ?

Did you do any upgrades recently ?
Previous Topic: Migrating from Ms-Access to Oracle8i
Next Topic: Migrate from 32 Bit Oracle 9.2.0 to 64 Bit Oracle 9.2.4
Goto Forum:
  


Current Time: Fri Sep 20 12:46:12 CDT 2024