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:\JDEV\jdevbin\jdev\bin\ jdevW.exe     to desktop

Copy the  TEST.dbc file form Oracle Apps Server to JDeveloper

Source Oracle Apps path:   

\oracle\inst_TOP\apps\test2\appl\fnd\12.0.0\secure\TEST.dbc

JDeveloprer Path: C:\JDEV\jdevhome\jdev\dbc_files\secure

 

Set the Environment variables of O/S

My Computer à Advanced à Environment Variables à New à 

Variable Name : JDEV_USER_HOME

Variable Value : C:\JDEV\jdevhome\jdev

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 :

\\oracle\inst_TOP\apps\fnd\12.0.3\secure\apps

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