Re: Ugh! Java and Oracle 8.1.7

Hey Roby,

Just installed JVM on 8.1.7 and didn't run into any ORA-600's (new database, not upgrade). But I did use svrmgrl instead of sqlplus due to earlier problems with some scripts executing properly in sqlplus in previous 8i releases (hmmmm, have those been fixed ??).

Here are the scripts I ran, any additional ones needed??

@$ORACLE_HOME/javavm/install/initjvm.sql
@$ORACLE_HOME/rdbms/admin/initplsj.sql
@$ORACLE_HOME/javavm/install/init_jis.sql
@$ORACLE_HOME/javavm/install/initjsp.sql 

initjsp.sql appeared to hang, but eventually finished....

Suzy

Roby Sherman wrote:
>
> <VENT>
> <ORACLE817>
> Well, I've been officially playing with 8.1.7 on Sun for 2 days now.
> Other than the "thrown-in" Apache stuff that you have to hack and slash
> the config files to make it do anything useful, the JavaVM is really
> screwy in this release. Here's some of the quick points I'm working on
> at the moment:
>
> * There is a total lack of documentation on what script(s) need to be
> executed in order to upgrade an 8.1.6 JVM to 8.1.7 - There is one
> upgrade script in the $ORACLE_HOME/javavm/install directory, but it
> doesn't seem to take care of the new namespace code (required for
> sess_sh and others) that needs to get in there. If you are building a
> database from scratch, initjvm does not call init_jis which is also used
> to build the namespace code.
>
> * ORA-600 hell - The initjvm.sql script dies with an ORA-600 the first
> few times it is executed, but eventually runs. (I still hate the fact
> that V$OPTION shows Java as false)
>
> I'm also working on these issues, but it is possible that they are
> somehow related to the ORA-600 problem mentioned above:
>
> * The ncomp (native compiler) program doesn't seem to work properly -
> Right now it's looking for a fragile-set.lst file that was alledgely
> generated but I cannot locate it with the find command.
>
> * The setup for servlets and jsps are kludgy, at best - Following the
> README instructions in the $ORACLE_HOME/javavm directory to install
> Servlet/JSP support hangs the database session.
>
> * I've been logging Itars like crazy, all of which specify "CALL ME". So
> what does support do? Their front-line folks paste in the good-ol canned
> responses and soft-close my tar without so much as an E-mail or a
> voice-mail. Am I supposed to be a MIND READER!? I've already escalated
> several I-tars to duty managers, we'll see how that goes.
>
> *THIS* is a TERMINAL RELEASE? Ugh. I've got a real hard time
> recommending that our enterprise java apps move over to this release
> until a few patch sets come out.
>
> Needless to say, it will be a few more days before I can get my new
> ncomp java perf numbers out to everyone. Sorry for the delay.
>
> --Roby
>
> </ORACLE817>
> </VENT>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roby Sherman
> INET: rxsherm_at_interealm.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Nov 14 2000 - 13:19:56 CST