Home » Server Options » Replication » ORA-03113: end-of-file on communication channel
ORA-03113: end-of-file on communication channel [message #75254] Fri, 23 August 2002 03:34 Go to next message
Prachi Khedkar
Messages: 1
Registered: August 2002
Junior Member
Hi,

I am trying to replicate the Data from Oracle 9 to Oracle 8 database. I have successfully created the database link and after that am creating a snapshot (complete refresh). Since the original DB doesn't have all tables with PKs (primary keys) I have to use 'with rowid' option. However, when I execute this query to create snapshot I get the following error -

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

If I try to create snapshot for a table with PK and without 'with rowid', replication is successfully done.

Can anybody help me resolve this ?

Thanks in advance,

Prachi
Re: ORA-03113: end-of-file on communication channel [message #75256 is a reply to message #75254] Tue, 27 August 2002 01:29 Go to previous messageGo to next message
Jack Hsu OCP
Messages: 1
Registered: August 2002
Junior Member
you must increase SHMMAX
Re: ORA-03113: end-of-file on communication channel [message #75449 is a reply to message #75254] Thu, 22 January 2004 06:21 Go to previous message
Ondrej Jombik
Messages: 1
Registered: January 2004
Junior Member
I have the same problem. Increasing SHMMAX on the client and server do not help. My SHMMAX is over 200MB. I think it is sufficient.
Previous Topic: can't find Oracle Replication Manager
Next Topic: Materialized View COMPILE_STATE = ERROR
Goto Forum:
  


Current Time: Sat May 21 12:58:46 CDT 2022