[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

10/29/2009 at 11:35PM PDT, ID: 24857229 | Points: 500
[x]
Attachment Details

Loadjava command in Oracle

Asked by ganeshaneesh in Oracle 8.x, Oracle 9.x, Oracle 10.x

Hi I am using loadjava command to load my java jar into the database. Following is the syntax:

loadjava {-user | -u} username/password[@database]   [-option_name [-option_name] ...] filename [filename ]...

I am working on load balancing db servers(two hosts like below example), how can i mention them with loadjava command as i have 2 hosts?

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=ora.myhost1.com)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=ora.myhost2.com)(PORT=1521))
(LOAD_BALANCE=yes)(FAILOVER=true))(CONNECT_DATA=(SERVICE_NAME=myservice)))

Thanks,
Aneesh.
[+][-]10/30/09 09:10 AM, ID: 25704361

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625