JDeveloper Installation and Setting Environment

Prerequisites 

Desktop with 1.5 GB RAM 

1.Telnet and FTP access to apps and db server 
2.Database connectivity details:
3.Apps username and password,
4.SID,
5.Host Name and port. 
6.Exact version of OA Framework on server

Get the JDeveloper software ( Ex:ZIP File  : p4141787_11i_GENERIC.zip )

Copy  into required drive ( folder ) / ( C:)
Eg: C: JDEV  ( create JDEV ( name can be any one ) folder in C-drive
Extract the ZIP file name p4141787_11i_GENERIC.zip )
Right click à WinZip à Extract To Here
After extracting it generates following
JDEV—- ( user created folder )
|____ jdevbin  
|____ Jdevdoc
|____   jdevhome
Take the shortcut of  C:JDEVjdevbinjdevbin jdevW.exe     to desktop
Copy the  TEST.dbc file form Oracle Apps Server to JDeveloper
Source Oracle Apps path:   
oracleinst_TOPappstest2applfnd12.0.0secureTEST.dbc
JDeveloprer Path: C:JDEVjdevhomejdevdbc_filessecure
 
Set the Environment variables of O/S
My Computer à Advanced à Environment Variables à New à 
Variable Name : JDEV_USER_HOME
Variable Value : C:JDEVjdevhomejdev
OK à OKàOK

Testing Functionality of Jdeveloper
Go to connection  à Right Click à New database connection à Next à 
Connection Name : test ( as desired )
Connection Type : Oracle ( JDBC )
Next :
User Name : apps
Password : apps
Next
Driver  : thin
Host Name : localhost ( if database is on the local system, else URL of DB server )
JDBC Port: 1521
SID       : VIS

For details see the vis.dbc located in the folder :

oracleinst_TOPappsfnd12.0.3secureapps
APPS_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=APPS.ora.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))
Next
Test Connection
Result: success
Next
Finish
  • October 16, 2017 | 17 views