RE: ORA-03113: end-of-file on communication channel
- From: "Singer, Phillip (P.W.)" <psinger1@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Oct 2004 08:29:18 -0400
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA
> Sent: Friday, October 15, 2004 11:43 AM
> To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx
> 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@icaeurp1 a
> , psopralias@icaeurp1 b
> , ps_rd_person_name@icaeurp1 c
> , ps_location_tbl@icaeurp1 d
> , ps_dept_tbl@icaeurp1 e
> , ps_rb_worker@icaeurp1 f
> , ps_rf_grp_member@icaeurp1 g
> , ps_rf_provider_grp@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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
