JDeveloper
Installation and Setting Environment
1)
Get the JDeveloper software ( ZIP File : p4141787_11i_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 p4141787_11i_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: D:\oracle\visappl\fnd\11.5.0\secure\VIS_apps\vis.dbc
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)
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 )
SID : VIS
For details see the
vis.dbc located in the folder :
D:\oracle\visappl\fnd\11.5.0\secure\VIS_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
4)
Test Connection
Result : success
Next
5)
Finish
No comments:
Post a Comment