Re: How to enable Java on ORACLE 9ir2 database???

2003-04-02 Thread Joan Hsieh
Mike, Hope this is not too late. I just had time to read some email from the list. Please check note:102717.1 and 149393.1. That's what you needed. joan mike mon wrote: > > We have ORACLE 9ir2 on SUN Solaris. We plan to use > Java on ORACLE very soon and need you help. > > 1. how to check th

Re: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Govindan K
--- mike mon <[EMAIL PROTECTED]> wrote: > We have ORACLE 9ir2 on SUN Solaris. We plan to use > Java on ORACLE very soon and need you help. > > 1. how to check the database we have is "java enable"? > connect as system/sys and SQL> desc dbms_java > 2. If database on "java enable", which f

RE: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Stephane Paquette
1. Check in dba_objects, you should have java objects as the object type. You should have java class, java data, java resource, java source 2. It depends what you want to do, at minimum run initjvm. You have to run more scripts to use xml and other stuff, check on metalink. 3. At least 50M 4.

RE: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread DENNIS WILLIAMS
Mike How are you planning to use Java? Generally, there are 3 ways: 1. Java stored procedures, like PL/SQL stored procedures. This is where the java_pool_size setting becomes very important. Otherwise, set it low after installation so it doesn't waste memory. Most sites don't seem very intereste

Re: How to enable Java on ORACLE 9ir2 database???

2003-03-24 Thread Darrell Landrum
On your system, look in your $ORACLE_HOME/javavm/doc/readme.txt; I think it answers all of these questions and provides other necessary information regarding Java in Oracle. Darrell Landrum Database Administrator Zale Corporation >>> [EMAIL PROTECTED] 03/24/03 01:44PM >>> We have ORACLE 9ir2 o

RE: How to enable Java

2002-05-21 Thread Miller, Jay
You don't need this article if in 8.1.6. Java installations and upgrades became a lot more complicated as of 8.1.7. Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I don't have an account with metalink, and I can't get to th

RE: How to enable Java

2002-05-21 Thread Joe LaCascio
Thanks for the help folks. We are moving along with our IAS install now. It's funny, I've been using the command line with Oracle for so long, I didn't know that dbassist was even there. And once again, the GUI failed where good ole SQL prompt resolved the problem. Thanks, Joe -- Please s

RE: How to enable Java

2002-05-21 Thread Joe LaCascio
I don't have an account with metalink, and I can't get to this article on technet. Anyplace else to get this. Also, I'm trying to do this in 8.1.6. Thanks, Joe On Tue, 21 May 2002, Rodrigues, Bryan wrote: > Hi Joe, > > Check out oracle document note:156477.1 JVM installation on 8.1.7 for > d

RE: How to enable Java

2002-05-21 Thread Rodrigues, Bryan
Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.s

Re: How to enable Java

2002-05-21 Thread Rick_Cale
Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run.

RE: How to enable Java

2002-05-21 Thread Mercadante, Thomas F
Joe, Log on to your server, and change your directory to : ORACLE_HOME/JAVAVM/INSTALL Start up Sqlplus, connecting as SYS and run the INITJVM.SQL file. Be sure hat Java_Pool_Size = 52428800 is in your init.ora file. This takes about 20 minutes to complete. This will install the Java engine

Re: How to enable Java

2002-05-21 Thread paquette stephane
You can installed java with scripts. Check metalink note 156477.1 Use more space (10-20M more )than specified on the note for java_pool_size and shared_pool --- Joe LaCascio <[EMAIL PROTECTED]> a écrit : > > Hi folks: > > I'm installing IAS on our web server which is a DEC > Alpha 800, one