Oracle JDeveloper Installation – OAF
Installing JDeveloper and Run Hello World page
Topics:
- Download Correct JDeveloper Version
- Install JDeveloper
- Setup the Environment Variable
- Copying JDBC File
- Start JDeveloper Application, Configure DB connection and Test Sample Application
- Database is 12c..? May get an error while DB configuration, how to solve.
Download Correct JDeveloper Version:
Log into oracle support/metalink and search for the document id: Doc ID 416708.1
OA Framework – How to Find the Correct Version of JDeveloper for OA Extensions to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1). We are using Oracle Applications : 12.1.3, so I have downloaded patch 9879989. Download option may vary based on oracle application version.
Install JDeveloper:
Download the JDeveloper patch as mentioned above.
Extract the patch into specific folder like: C:\Anand\OAF
Once the extraction completed, you could see the folder structure as below.
Now configure environment variable in your system.
Setup the Environment Variable:
Navigation: My computer -> Properties -> Advanced System Settings -> Advanced -> Environment Variables
Now go to run and type cmd(command prompt) and type set JDEV_USER_HOME
Copying JDBC File:
JDBC file available in server #FND_SECURE top, we need to copy that file and place into OAF folders (local system).
Login into Putty tool and WinSCP tool and type below commands
Cd $FND_SECURE ($FND_SECURE is the top)
ls -ltr (Will give you list of files in that folder)
pwd (will give you path of the file)
Winscp: Copy the file (TEST.dbc) from server using above path to local system.
Copy TEST.dbc file into OAF folder: OAF\jdevhome\jdev\dbc_files\secure
Start JDeveloper Application, Configure DB connection and Test Sample Application:-
Run the application from the below path, create desktop shortcut
Path: C:\Anand\OAF\jdevbin\jdev\bin
While opening this application you might get couple of prompt, just click on ok.
Once toolbox application is open, then right click on the Tutorial and click on the project properties.
Run time connection setup is completed. Now configure the Database connection as shown below
Above connection failure happens if the database is 12c.
After upgrading to Oracle 12c database, I start getting ORA-28040: No matching authentication protocol.
Contact DBA to update the sqlnet.ora file as mentioned below.
SQLNET.ALLOWED_LOGON_VERSION=8
Sqlnet.ora file will be available in $TNS_ADMIN
Before Update:
After Update:
Once it’s done, go ahead and test the database connection.
Click on Finish button and go to JDeveloper run the HelloWorldPG.xml
Right click on HelloWorldPG.xml and click on Run
If you see this page then we are done with the installation and start using JDeveloper