Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-03113: end-of-file on communication channel

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

From: Singer, Phillip (P.W.) <psinger1_at_ford.com>
Date: Mon, 18 Oct 2004 08:29:18 -0400
Message-ID: <A45063A7D336504580F0161CEB7FEBE204547E22@na1fcm60.dearborn.ford.com>


One unexpected (to me at least) way I have seen this is where the DBA = for the remote database put a timeout in the profile for the remote = account. =20

Thus:

  1. Use the link.
  2. Wait too long.
  3. Remote instance terminates the process
  4. Try to use it again
  5. ORA-3113

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA
> Sent: Friday, October 15, 2004 11:43 AM
> To: oracle-l_at_freelists.org; askdba_at_freelists.org
> Subject: ORA-03113: end-of-file on communication channel
>=20
>=20

> Hi ,
>=20

> I m getting error ' ORA-03113: end-of-file on communication channel '
> while creating a procedure which uses database link to populate data.
>=20

> Can anyone tell me what can be the problem ?
>=20

> - Chirag Majmundar
>=20
>=20

> CREATE OR REPLACE procedure populateiCareUsers
> is
> begin
>=20

> -- execute immediate 'drop database link icaeurp1';
>=20

> -- create database link icaeurp1
> -- connect to act_parts identified by act_parts
> -- using=20
> execute immediate 'truncate table temp_profile_users';
>=20

> insert into temp_profile_users=20
> select a.oprid
> , c.last_name
> , c.first_name
> , e.descr department
> , d.descr location
> , h.name1 provider_grp_name
> from psoprdefn_at_icaeurp1 a
> , psopralias_at_icaeurp1 b
> , ps_rd_person_name_at_icaeurp1 c
> , ps_location_tbl_at_icaeurp1 d
> , ps_dept_tbl_at_icaeurp1 e
> , ps_rb_worker_at_icaeurp1 f
> , ps_rf_grp_member_at_icaeurp1 g
> , ps_rf_provider_grp_at_icaeurp1 h
> where a.oprid =3D b.oprid
> and b.person_id =3D c.person_id
> and f.person_id =3D b.person_id
> and f.location=3D d.location
> and f.deptid =3D e.deptid
> and g.person_id =3D b.person_id
> and g.provider_grp_id =3D h.provider_grp_id;
>=20

> insert into profile_users select * from temp_profile_users where oprid
> not in(select oprid from profile_users);
> end;=20
> --------------------------------------------------------------
> ------------------------------
> ERRORS I M GETTING
> --------------------------------------------------------------
> ------------------------------
> CREATE OR REPLACE procedure populateiCareUsers
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 18 2004 - 07:25:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US