Some times we have some problem with dblinks, and we have to find a workaround to avoid to lose the connectoin. (not using ODBC, direct connection between database to database ) Try to see if you are doing something specific when you lose the connection. ORA-03113 end-of-file on communication channel For example reading a lob, or something like. ----- Original Message ----- From: "Waleed Haggagy" <haggagy@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, March 02, 2004 1:57 AM Subject: database link URGENT PLZ > thx Tanel for yr replay, > i do what u said, > but it is not working > > > plz check my code for connect to db2 on as400 (aserver is odbc connection > to db2) > > LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) > ) > ) > ) > > SID_LIST_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = hsodbc) > (ORACLE_HOME = D:\oracle\ora81) > (PROGRAM = hsodbc) > ) > (SID_DESC = > (GLOBAL_DBNAME = ORCLSURV) > (ORACLE_HOME = D:\oracle\ora81) > (SID_NAME = ORCLSURV) > ) > ) > > > > > HSODBC = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = tcp)(HOST = LOCALHOST)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = hsodbc) > ) > (HS = OK) > ) > > > > # This is a sample agent init file that contains the HS parameters that are > # needed for an ODBC Agent. > > # > # HS init parameters > # > HS_FDS_CONNECT_INFO = ASERVER > HS_AUTOREGISTER = TRUE > HS_DB_NAME = HSODBC > #HS_FDS_TRACE_LEVEL = 0 > # HS_FDS_TRACE_FILE_NAME = hsodbc.trc > > > # > # Environment variables required for the non-Oracle system > # > #set <envvar>=<value> > > _________________________________________________________________ > Add photos to your e-mail with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------