Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Monday, June 20, 2011

500 Internal Server Error

Client was getting following error while accessing the form application.

500 Internal Server Error Too many open files at Method) at at at at oracle.forms.servlet.ConfigFileParser.(Unknown Source) at oracle.forms.servlet.FormsServlet.doRequest(Unknown Source) at

Saturday, June 11, 2011

Finding FK for a Parent table

select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
     from all_constraints
    where constraint_type='R'
    and r_constraint_name in (select constraint_name from all_constraints
    where constraint_type in ('P','U') and table_name='T_LOOKUP');

Monday, June 06, 2011

ORA-19815: WARNING: db_recovery_file_dest_size

We were getting warning in Alertlog for a database although we were not using FRA.
ORA-19815: WARNING: db_recovery_file_dest_size of 6442450944 bytes is 99.78% used, and has 14326272 remaining bytes available.