The Following Points needs to be considered when we plan to migrate our Oracle database 10gR2 to database 11gR2 and if we are using Oracle Application server 10gR2.

1. SEC_CASE_SENSITIVE_LOGON
2. Fine Grained network access (ACL)
3. Character set of old and new DBs
4. NLS setting of old and new DBs
5. Context, DB Links and DB Jobs (When Export and Import)
6. FORMS_USERNAME_CASESENSITIVE

To Compile all the forms at a time use the following code as bacth

echo ...Compilation Started...This may take few minutes...
del *.err

for %%i IN (*.pll) do frmcmp module=%%i userid=plas/plas@plas11g batch=yes module_type=LIBRARY compile_all=yes window_state=Minimize
echo Libraries Compilation completed Completed
for %%i IN (*.mmb) do frmcmp module=%%i userid=plas/plas@plas11g batch=yes module_type=MENU compile_all=yes window_state=Minimize
echo Menu Compilation completed Completed
for %%i IN (*.fmb) do frmcmp module=%%i userid=plas/plas@plas11g batch=yes module_type=FORM compile_all=yes window_state=Minimize
echo Form Compilation completed Completed

dir *.err /b >>Error_Forms.txt

Here the date modified of fmb and fmx will be changed to the run date

To convert all the reports (RDF to REP) use the following code as bacth

echo Compilation Started,This may take few minutes.

for %%i IN (*.rdf) do rwconverter source=%%i userid=plas/plas@plas11g stype=rdffile DTYPE=repfile compile_all=yes OVERWRITE=yes batch=yes

echo Reports Compilation completed Completed

Here the date modified of rep will be changed to the run date and rdf will not have any change.