Monday, 16 October 2017

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


1 comment:

  1. BlueHost is definitely the best hosting provider with plans for any hosting needs.

    ReplyDelete