Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: ORA-03113 again!

    Hi All!


    Since las 3 days I am looking for the solution of this problem:

    We have 2 databases, which are connected via database links. The one database, in this case the MASTER, is running on Suse 8.1 and Oracle 8.1.7.3.0, the other, in this case the SLAVE, is running on Solaris 8 and Oracle 8.1.7.4.

    In the MASTER-DB we have stored procedures, that read and write to the Tables in the SLAVE-DB via database link using some synonyms.
    The database links names and connect strings are equal to global names which are again equal to hostnames. So we have
    "slave.somedomain.de" as a global name and a hostname. The database link is then created like this

    connect system/system_password@master.somedomain.de

    grant create database link to master_dbuser;

    CREATE PUBLIC DATABASE LINK slave.somedomain.de USING 'slave.somedomain.de';

    connect master_dbuser/master_dbuser_password@master.somedomain.de
    CREATE DATABASE LINK slave.somedomain.de CONNECT TO slave_dbuser IDENTIFIED BY slave_dbuser_password;



    As soon any LOB has to be written, then connection dies due to ORA-03113.

    We tested another combination with the SLAVE on Suse 8.1 and Oracle 8.1.7.4, then everything is working fine. Also in homogene Win2k environment, there are no ORA-03113.

    Is there any specific configuration for Solaris 8 required ore is this bahavior a bug in the Solaris-Destribution of 8.1.7.x?

    Really need support on this problem!

    Thanks!

    Maxim
    Last edited by replicator; 12-18-03 at 17:38.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    I think the reason you are getting ORA-03113 "end of file on communications channel" is your sqlnet files were not relinked properly after installing Oracle on Solaris. I seem to recall that after installing Oracle you have to login as root and run root.sh, then look for errors and rerun as necessary. If you are already logged into the server and you "su root" verus "su - root" then you will get different results.

    This does not apply on Windows platforms.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •