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 à
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
SID : VIS
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
No comments:
Post a Comment