Re: forms 6 intermittently getting ora-3113 at cursor using db link

"tom.ferguson" wrote:

> Has anyone ever come across the scenario described below. It is giving
> me great headaches and I have reached the limit of my Oracle knowledge.
>
> SCENARIO
> ------------
> I have two Oracle 8.1.7 databases, DB1 and DB2. Both database are on
> the same Unix server. Each database has only one schema, owned by
> different users.
>
> DB1 contains table T1 and a public synonym for it.
>
> DB2 has
> a public db link to DB1 using DB1 schema owner as user,
> a public synonym to table T1 on DB1, referencing db link,
> a Table T2 and associated public synonym,
> a View V1 on table T1, which uses the public synonym for T1,
> a public synonym for view V1.
>
> A simple client side form (Forms 6.0.5) contains a cursor which joins V1
> and T2. On occassion the Form will fail with an ORA-03113 always at the
> point of Fetching from the cursor. On other occassions it will succeed.
> It appears as if the form will only fail immediately after database DB2
> has been restarted but with constant re-attempts of the Form, it will
> eventually succeed.
>
> The TNSNAMES.ORA files have been checked on both the client PC and
> Server. The TNSNAMES.ORA have been tried with the CONNECT parameter set
> to use the SID and SERVER_NAME options but appears to make no
> difference.
>
> There are other forms which contain similar cursors (referencing Views
> to Tables across a dblink, some using synonyms, some with dblink in the
> view) that have never had any ora-3113 problems and there is no apparent
> difference in the structure/syntax.
>
> --
> Posted via http://dbforums.com

Before you invest any effort into tracking this down have the Unix SysAdmin (assuming this is not AIX but you don't indicate the flavor of UNIX) compare the settings in the kernel for shared memory and semaphores to Oracle's recommendation given the two databases on a single machine.

In Solaris it will be found in /etc/system. On HP-UX in SAM.

I'll bet a latte' they are set incorrectly for two databases on a single machine. The correct settings can be found in the docs on the Oracle CD and at http://docs.oracle.com.

Daniel Morgan Received on Sun Jan 12 2003 - 23:27:10 CET