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:
- Use the link.
- Wait too long.
- Remote instance terminates the process
- Try to use it again
- 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