Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Friday, 15 April 2016

OAF JDeveloper Installation and Setting Environment

1)       Get the JDeveloper software ( ZIP File  : p8431482_R12_GENERIC.zip )

2)       Copy  into required drive ( folder ) / ( C:\)
Eg: C:\ JDEV  ( create JDEV ( name can be any one ) folder in C-drive

3)       Extract the ZIP file name p8431482_R12_GENERIC.zip )
Right click à WinZip à ExtractToHere
                After extracting it generates following
              
JDEV---- ( user created folder )
                                                |____      jdevbin
                                                |____      Jdevdoc
                                                |____   jdevhome

4)       Take the shortcut of  C:\JDEV\jdevbin\jdev\bin\ jdevW.exe     to desktop

5)       Copy the  vis.dbc file form Oracle Apps Server to JDeveloper

Source Oracle Apps path:   /u03/ERPDEV1/applmgr/inst/apps/ERPDEV_erpdev1/appl/fnd/12.0.0/Secure/ERPDEV1.dbc

See below screen shot (You can find the below screen shot by press "About the page" on any OAF page in apps)


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

6)       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

 1)  Open Jdeveloper and go to connection  Right Click  New database connection 
Next
Connection Name : test ( as desired )
Connection Type : Oracle ( JDBC )
Next :

2)       User Name            : apps
          Password               : apps
                Next

3)       Driver  : thin
   Host Name : localhost ( if database is on the local system, else URL of DB server )
   JDBC Port : 1521(your database port Number)
   SID            : VIS (Your Database SID)
For details see the vis.dbc located in the folder :

/u03/ERPDEV1/applmgr/inst/apps/ERPDEV_erpdev1/appl/fnd/12.0.0/Secure/ERPDEV1.dbc

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

4)       Test Connection
          Result : success
          Next

5)       Finish
Share this article :

0 comments:

Post a Comment