	[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.

View the Solution FREE for 30 Days

20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625

1. sdstuber63,342
2. mrjoltcola40,257
3. schwertner16,102
4. MarkusId14,280
5. sujith8012,500
6. angelIII11,772
7. Andytw9,105
8. markgeer9,048
9. johnsone9,000
10. flow018,270
11. nav_kum_v6,800
12. awking006,064
13. Henka5,455
14. MikeOM_...5,375
15. Milleniuma...5,000
15. HainKurt5,000
17. dbmullen4,102
18. Suresh_...4,100
19. Geert_Gr...3,829
20. jwahl3,772
21. woolmilkp...3,500
22. dvz3,248
23. k_murli_...3,000
23. shajukg3,000
23. reb733,000

1. sdstuber182,139
2. schwertner81,962
3. angelIII67,904
4. johnsone56,406
5. sujith8047,870
6. mrjoltcola40,257
7. MikeOM_...33,050
8. markgeer28,723
9. nav_kum_v28,152
10. jinesh_ka...25,850
11. aiklamha25,350
12. dbmullen22,417
13. dvz19,837
14. slightwv19,425
15. shajukg16,782
16. MarkusId15,535
17. jwahl14,252
18. Akenathon11,050
19. Milleniuma...10,550
20. rolutola10,500
21. awking0010,419
22. flow0110,130
23. Henka9,955
24. joebednarz9,675
25. Andytw9,105