[askdba] Re: ORA-03113: end-of-file on communication channel
- From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 12:43:06 -0400
ORA 3113 has numerous reason...
> To start with..is the DB link active I mean tested for connection.
> Is firewall involved with connection to the server where db link intends
to get data from.
> Try doing a simple select over the dblink within the procedure and see if
it returns date from psoprdefn@icaeurp1 and then test for each remote
tables.
============================
HTHU
Ankur Shah
Oracle DBA
DHR-GA
----- Original Message -----
From: "Chirag DBA" <ChiragDBA@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <askdba@xxxxxxxxxxxxx>
Sent: Friday, October 15, 2004 11:42 AM
Subject: [askdba] ORA-03113: end-of-file on communication channel
> Hi ,
>
> I m getting error ' ORA-03113: end-of-file on communication channel '
> while creating a procedure which uses database link to populate data.
>
> Can anyone tell me what can be the problem ?
>
> - Chirag Majmundar
>
>
> CREATE OR REPLACE procedure populateiCareUsers
> is
> begin
>
> -- execute immediate 'drop database link icaeurp1';
>
> -- create database link icaeurp1
> -- connect to act_parts identified by act_parts
> -- using
> execute immediate 'truncate table temp_profile_users';
>
> insert into temp_profile_users
> 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 = b.oprid
> and b.person_id = c.person_id
> and f.person_id = b.person_id
> and f.location= d.location
> and f.deptid = e.deptid
> and g.person_id = b.person_id
> and g.provider_grp_id = h.provider_grp_id;
>
> insert into profile_users select * from temp_profile_users where oprid
> not in(select oprid from profile_users);
> end;
> --------------------------------------------------------------------------
------------------
> ERRORS I M GETTING
> --------------------------------------------------------------------------
------------------
> CREATE OR REPLACE procedure populateiCareUsers
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
>
Other related posts:
