Re: initjvm.sql hangs on db file sequential read to IDL_UB1$

> I've having trouble installing the Oracle JVM on an Oracle 9.2.0.4> instance on Redhat Linux AS 3.0. I thought perhaps some of you would> have ideas.>> ...>> I then execute @?/javavm/install/initjvm>> which runs fine and gets to the CREATE JAVA SYSTEM statement. A trace> reveals this is running fine. At some point, however, it begins waiting on:>> db file sequential read>> against the>> IDL_UB1$>> table. (Found via p1, p2 in v$session_wait.) Actually, not only the> same table, but the same /block/. It doesn't report any errors, nothing> in the alert log, it just hangs.

Adam,

I can't address Oracle JVM specifically, but I can speak to the type
of hanging problem you are encountering.

When you are querying v$session_wait, you may notice that sequence# is
not incrementing. This means that the session is not really waiting
on that event, only that that was the last event posted before the
session hung.

You need to determine first if the process is spinning or hung. Look
at top or ps for the server process of your session, and see if it is
using any CPU or not.

If yes, then it is spinning. If no then it is hung. Most likely in
your case it is hung.