At first time you must run at ODA with admin option for ODA repository creation.
You connect to the ODA oracle user("repository owner") the schema where the ODA repository will be created,
A password is the oracle ODA user's password
Choose "OK" and the tool is ready for work.
The ODA running without admin mode is intended for check dependencies only.
Admin mode allows objects data inserting and dependencies checking.
The repository owner can have any name.
After, in "Administration>Insert objects" window,
you connect to "DBA user" and specify "analyzed schema" here.
The ODA seeks dependencies in Forms/Reports triggers, block and item properties,parameters,report queries and program units.
In the beginning to load ("Insert object into repository" button, "Oracle DB" tab) in ODA repository
all DB objects. You should
try to load all Oracle schemas which Form application works against.
For correct Form upload process Oracle Developer Suite must be installed.
You can download Oracle Forms and Reports here
For Oracle forms download in Windows you can use something like:
set PATH=C:\Oracle\ids1012\bin;%PATH%
h:\my_projects\Java\jdk7_32\bin\java.exe -Xms256m -Xmx2048m -jar oda.jar admin
For the Form/PLL/Report upload ("Insert object into repository" button, "Form"/"Report" tab) - you can choose form file path; when you choose directory then all files of directory will be loaded.
ODA can search and show dependencies looking at the objects those locating in Oracle schema and
for this uses only dba_objects, public_dependency, dba_source system views.
ODA supplements the dependencies between the objects with the context of using -
shows the program code, where table or procedure is used.
Packages in this case are parsed to the procedures and the functions.
Therefore you obtain the fragment of the code with the indication of the name of the specific procedure of package.
For to logon into ODA application you connect to the ODA user what ODA repository owner.
For to add into ODA application all objects of analyzed database you connect to any oracle user can look these objects.
For ODA running in Unix/Linux OS you must
Probably, there isn't the correct Java version(the ODA needs JRE 1.6 version or higher).
If you use older Oracle forms suits (earlier than Forms 11) there's a Java version limitation. You can install java version 1.4 only.
For to solve this problem you download JRE 1.6 without full Java installation and you save it in any directory, c:\my_projects\jre6, for example.
After that you use these commands:
set JAVA_HOME= "c:\my_projects\jre6\"
set JAVA_EXE= "c:\my_projects\jre6\bin\javaw.exe"
%JAVA_EXE% -Xms512m -Xmx1200m -jar oda.jar admin
For a correct Oracle forms downloading you need to specify right encoding parameters.
%JAVA_EXE% -Xms512m -Xmx1200m -Dsun.jnu.encoding=Cp1255 -Dfile.encoding=ISO-8859-8 -jar oda.jar admin
(This example is right for hebrew)
The installation works correctly without any changes. It may be necessary to use the memory parameters, for example -ms2M -mx5M