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 the

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

2003-03-24 Thread mike mon
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? 2. If database on java enable, which files we need run to make it java enable? 3. on init.ora file their has a entry call java_pool_size = .

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 on SUN

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

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

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 files we need

How to enable Java

2002-05-21 Thread Joe LaCascio
Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist

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 of the

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

Re: How to enable Java

2002-05-21 Thread Rick_Cale
: Sent by: Subject: How to enable Java [EMAIL PROTECTED

RE: How to enable Java

2002-05-21 Thread Rodrigues, Bryan
by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our

RE: How to enable Java

2002-05-21 Thread Joe LaCascio
space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java

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

RE: How to enable Java

2002-05-21 Thread Miller, Jay
jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om