500 Internal Server Error

Client was getting following error while accessing the form application.

500 Internal Server Error
java.io.IOException: Too many open files at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(FileInputStream.java:106) at java.io.FileInputStream.(FileInputStream.java:66) at java.io.FileReader.(FileReader.java:41) at oracle.forms.servlet.ConfigFileParser.(Unknown Source) at oracle.forms.servlet.FormsServlet.doRequest(Unknown Source) at

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');

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.