Re: Can't install DBMS_JAVA package

I wish Avi learned how to make others help him more easily by telling us the error message or anything he observed.

Anyway, running initjvm.sql takes a lot, I do mean a lot, of memory. Our Sun server has 2GB with several small databases. Yesterday I created a small TEST database and for the first time I let it run the last createDB script which runs initjvm.sql. It took more than an hour and the memory usage went up to the level that there was about 30 (?) MB memory free. vmstat indicated a lot of swap memory was being used. CPU was quite idle though. Fortunately it ran through before I decided to kill it.

Yong Huang
yhuang_at_indigopool.com

Dave A <dave_and_vanna_at_hotmail.com> wrote in message news:ss2sdettct6121_at_corp.supernews.com...
> While we haven't done anything with Java on 8i(so I can't help the poster
> with his troubles), after applying the latest patch the instructions said
 to
> run CREATE OR REPLACE JAVA SYSTEM .
>
> Does this do the same thing? This command appears to have successfully
> created all the java stuff, but we never explicitly ran initjvm.sql,
 unless
> the file is called during database creation and I wasn't aware of it.
>
> --
> Dave A
>
>
> "Nevin Hahn" <nevin.hahn_at_born.com> wrote in message
> news:39BDCEF3.4A46001D_at_born.com...
> > Hi Avi,
> >
> > It is difficult to say what is wrong, please provide specifics about
> > the failure when running the initjvm.sql file. You must run this script
> > to create the DBMS_JAVA package.
> >
> > Nevin Hahn
> > nhahn_at_evoke.com
> >
> > Avi Abrami wrote:
> >
> > > Greetings,
> > > I am using Oracle 8i (8.1.6) on a SUN computer
> > > with Solaris 7. When I ran the SQL script
> > >
> > > $ORACLE_HOME/javavm/install/initjvm.sql
> > >
> > > it failed. The result is that the DBMS_JAVA
> > > package does not exist. Without this package
> > > (as I understand) I cannot create stored
> > > procedures in Java. I would like suggestions
> > > as to how I can successfully create the
> > > DBMS_JAVA package.
> > >
> > > Thanks in advance,
> > > Avi.
> >
>
>
Received on Fri Sep 15 2000 - 11:56:04 CDT