Oracle AS 11gR1 greška - FRM-92090: unexpected fatal error

Nakon nepravilnog restarta servera (zbog problema sa napajanjem) aplikacija koja radi na Oracle 11gR1 Forms&Reports Services Application Server-u daje sledeću grešku:

Greška FRM-92090 je generička greška i ona ne daje baš puno informacija o stvarnom problemu na AS servisu. Debugging nastalog problema dodatno usložnjava činjenica da su sve komponente AS servisa startovane i rade bez problema:

Detalnom analizom logova aplikativnog servera nisam mogao da utvrdim šta tačno može biti problem.

Pretragom Metalink-a naišao sam na jednu note-u (433023.1) koja me je navela na moguće riješenje problema. U note-i se kaže da navedeni problem može nastati u sledećim slučajevima:

-------------------------------------------------------------------------------------------------------------------------
 1. The Registry.dat file was modified and now is corrupted
or
2. This happens when the FORMSxx_MESSAGE_ENCRYPTION is set to true/1.
or
3. If you issue a ulimit -a at the command prompt you receive the following output:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2097148
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 64
vmemory(kbytes) unlimited
-------------------------------------------------------------------------------------------------------------------------

Zato su i ponuđena tri riješenja navedenog problema:

-------------------------------------------------------------------------------------------------------------------------
1. Restore the original Registry.dat file and restart the OC4J / WLS_FORMS.
or
2. Set the FORMSxx_MESSAGE_ENCRYPTION environment variable to
0/false.
or
3. use ulimit -n xxx where xxx is the new number
For example if you have 300 users connecting, set it to a number higher then 300. In our case, we increased it to 128 and were able to
connect with 123 users instead of failing with the 61st user.
-------------------------------------------------------------------------------------------------------------------------

Riješenja pod 2. i pod 3. odmah sam odbacio jer ne odgovaraju navedenom okruženju (sistemu). 

Provjerom sam utvrdio da fajl Registry.dat koji se nalazi na lokaciji

 %WEBLOGIC_HOME%\user_projects\domains\domain.name\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config\forms\registry\oracle\forms\registry

ima veličinu 0kb, odnosno prazan je. To znači da je taj fajl oštećen, verovatno zbog nepravilnog restarta servera.

Srećom, imao sam backup navedenog fajla tako da nakon što sam fajl vratio iz backup-a i nakon što sam restartovao AS-a aplikacija je proradila!!!!