Re: OAS report server sometimes does not create reports
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 05 Sep 2012 07:32:52 +0200
Message-ID: <5046E404.2080003_at_gmail.com>
On 04/09/2012 23:12, Yong Huang wrote:
> Oracle Application Server 10.1.0.3 on RHEL 4
>
> Once in a while, users get error "REP-0178: Cannot connect to Reports Server ..." when trying to create a report. Whenever this happens, I notice that the report server java process (found by ps -ef | grep rep_) shows ORA-4020 in strace output:
>
> [...]
Date: Wed, 05 Sep 2012 07:32:52 +0200
Message-ID: <5046E404.2080003_at_gmail.com>
On 04/09/2012 23:12, Yong Huang wrote:
> Oracle Application Server 10.1.0.3 on RHEL 4
>
> Once in a while, users get error "REP-0178: Cannot connect to Reports Server ..." when trying to create a report. Whenever this happens, I notice that the report server java process (found by ps -ef | grep rep_) shows ORA-4020 in strace output:
>
> [...]
Hi Yong,
comments from the link you posted:
>>> Does the report server implement its own sophiscated RDBMS engine, >>> or at least the library cache locking mechanism?)
Oracle Forms has its own PL/SQL engine:
PL/SQL Engine
The PL/SQL compilation and run-time system is an engine that compiles
and executes PL/SQL units.
The engine can be installed in the database or in an application
development tool, such as Oracle Forms.
goo.gl/sENRd
Regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 05 2012 - 00:32:52 CDT