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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 24 Mar 2003 14:31:35 -0600
Message-Id: <24765.322928@fatcity.com>

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 interested in Java stored procedures, as near as I can tell. 2. Java thick client
3. Java thin client
Either way, you probably have an application server installed somewhere, like Oracle 9i A.S., Tomcat, BEA WebLogic, etc. For #2 and #3 you don't need to do anything in Oracle. #3 doesn't even use SQL*Net, from what I can see. The A.S. administrators will probably want to do connection pooling, so they will ask you to create a login with broad access so several applications can use it.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: mike mon [mailto:mccdba_at_yahoo.com] Sent: Monday, March 24, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L Subject: How to enable Java on ORACLE 9ir2 database???

We have ORACLE 9ir2 on SUN Solaris. We plan to use Java on ORACLE very soon and need you help.

how to check the database we have is "java enable"?
If database on "java enable", which files we need run to make it "java" enable"?
on init.ora file their has a entry call "java_pool_size = ????". What value should I put in there?
except "java_pool_size = ??", does their has other entry we need put on "init.ora" file to support JAVA?

Thanks.

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: mike mon
INET: mccdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 also send the HELP command for other information (like subscribing). Received on Mon Mar 24 2003 - 14:31:35 CST