Re: ORA3113 with DB Links & PL/SQL block

Have you contacted Oracle support? This may be a known problem. From the sounds of it, it appears that the 7.3.4 server is crashing.

River <wychan_at_vol.net> writes:

> I face a strange problem.
> I installed two Oracle734 on two NCR Unix boxes.
> They are connected with a db link.
>
> In sql*plus, when I execute a single SQL select statement on DB#1 to
> select
> data from DB#2 through db link, no problem.
> However, when I execute a PL/SQL block to do the same thing, it will
> disconnect my session (ORA 3113).
>
> I also have two Oracle716 on that two NCR Unix boxes.
> Both the single SQL select statement and the PL/SQL block run on 716
> successfully.
>
> Is there any mistakes on the 734 I overseen?
>
> Thank for any advice,
> River
> wychan_at_vol.net

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com