Kurt Van Meerbeeck

FRM-92095: Oracle Jnitiator version too low - please install version 1.1.8.2 or higher

kurtvm — Sun, 29 Jan 2012 18:07:02 +0100

A customer of mine who deploys Oracle Forms 10g on the wild wild internet, ran into a little problem.

They don't have control over the java plugin being installed on the client machine and with the latest java 1.7 update

they encountered the following forms error :

FRM-92095: Oracle Jnitiator version too low - please install version 1.1.8.2 or higher

Doh - we're running java 1.7 - not Oracle's obscure Jnitiator.

This seems to be a know issue on metalink see

FRM-92095 Error When Running Forms Using JRE 7 (JRE 1.7) [ID 1348436.1]

A bug has been filed Bug:11782681 APPS6: FORMS DO NOT LAUNCH WITH BETA JRE 1.7

There's no patch yet(not even for the latest 11g Forms). And because Forms 10.1.2.x permier support

ended in December 2011... God only knows there will be a back-port. So for now - we're on our own !

However ... why does the Forms applet thinks it is running on an Oracle Jnitiator ?

Can it be that Java's vendor system property changed from 'Sun Microsystems Inc' to 'Oracle Corporation' ?

A little test program will show :

import java.util.* ;

class test

{

public static void main(String args[])

{

System.out.println("java.version =" + System.getProperty("java.version") ) ;

System.out.println("java.vendor =" + System.getProperty("java.vendor") ) ;

}

On java 1.6:

java test

java.version =1.6.0_30

java.vendor =Sun Microsystems Inc.

On java 1.7:

java.version =1.7.0_02

java.vendor =Oracle Corporation

I tracked down where in the Forms code the version is checked - it's situated in the HTTPConnection.class which compares

the vendor property string of the plugin with either 'MICROSOFT' or 'Oracle Corporation' and then acts accordingly.

This property string for Java 1.6 and below is 'Sun Microsystems Inc' - starting from 1.7 it is 'Oracle Corporation'.

Oracle Jnitiator also used the vendor string 'Oracle Corporation'.

So - Forms now thinks it is running on an old jnitiator instead of the latest java 1.7 plugin.

This is easily fixed with an hexeditor or decompiler but it's not really elegant and can affect other parts of the code.

(with a hexeditor - unjar frmall.jar - open HTTPConnection.class - look for string 'Oracle Corporation' in the neighborhood of 'MICROSOFT' - change

the string in something else - save - jar classes ... haven't tested it - should work)

Instead I used a bootstrapper applet which sets the vendor property back to 'Sun Microsystems inc' like this :

- System.setProperty("java.vendor", "Sun Microsystems Inc.") ;

Then the applet(stub) loads Oracle Forms' main engine class.

- Class oforms = Class.forName("oracle.forms.engine.Main");

- init and start the Forms applet

I can't share the code nor class as the IP belongs to my employer but this fixed the problem and we can now run Forms on Java 1.7 !

The great part of this is - we don't touch the original frmall.jar, which is important if 3000 end users need a new jar downloaded over limited bandwidth !

Then, I went into a creative overdrive :-)

In the spirit of the 80's and 90's atari and amiga demo scene I added an intro with plasma effect.

Check out the flash screen capture I've made of the application loading :-)))

http://www.ora600.be/forms_java7swf.swf

Oracle ASS - one time it will save yours !

kurtvm — Mon, 31 Oct 2011 10:25:43 +0100

For those who don't know Oracle ASS - it's an awk script that is hidden in Oracle's LTOM (aka Lite Onboard Monitoring).

You can download it from metalink - see note ID 352363.1.

It's an awk script that formats system state dumps. I now and then use it to format massive trace files to something I can actually use.

A couple of months ago I had to investigate why a 2 node RAC on windows kept on crashing.

The dba managing it didn't really bother to check the system state dump - instead they just open a call with Oracle and uploaded the trace files.

As usual, the dba blamed the developers - 'it's the app - it's the app' - and I had to defuse the situation and as the developers couldn't see anything wrong and the relationship started to turn sour.

I wasn't allowed access to the system but I was able to have a look at the trace files - or as the dba called it 'a very complex logfile'.

Fair enough - the system state dump was several megabytes larges but luckely I had Oracle ASS ;-)

Within minutes I kind of figured out what the problem was.

Just looking at some of the wait events from the output below:

SGA: allocation forcing component growth

cursor: pin S wait on X

row cache lock

This looks like an sga resize operation, at which point library cache locks arise.

A sga resize operation can hang the database for brief moments of time especially when the shared pool needs to be resized.

However it this case, the instance was crashing.

With no access to the system I told the dba to have a look v$sga_resize_ops. If there are excessive resize operations, the sga might simply be sized too small.

I also got hand of the alert logs - as the instances were frequently crashing, I could see the startup in the alert.log, showing me sga settings.

And I kid you not - these 2 nodes were configure with SGA_TARGET=256M !!! I was surprise this thing even started !

Bumping up sga_target basically solved all issues.

This puppy was running in production for a month, had lots of issues and yet, the dba hadn't even bothered to check even the most basics settings.

Instead, they just blamed the app, opened a call with oracle, getting some general advise and be done with it. Amazing...

awk -f ass109.awk tracefile.trc > out

Starting Systemstate 1

..............................................................................

.................................................................

Ass.Awk Version 1.0.9 - Processing xyz_ora_4948.trc

System State 1

~~~~~~~~~~~~~~~~

2: waiting for 'pmon timer'

3: waiting for 'DIAG idle wait'

4: waiting for 'rdbms ipc message'

5: waiting for 'rdbms ipc message' [Latch received-location:]

6: waiting for 'ges remote message'

7: waiting for 'gcs remote message'

8: waiting for 'gcs remote message'

9: waiting for 'gcs remote message'

10: waiting for 'gcs remote message'

11: waiting for 'gcs remote message'

12: waiting for 'gcs remote message'

13: last wait for 'rdbms ipc message'

14: waiting for 'rdbms ipc message'

15: waiting for 'rdbms ipc message'

16: waiting for 'rdbms ipc message'

17: waiting for 'rdbms ipc message'

18: waiting for 'rdbms ipc message'

19: waiting for 'SGA: allocation forcing component growth'

20: waiting for 'enq: DR - contention' [Enqueue DR-00000000-00000000]

21: waiting for 'SGA: allocation forcing component growth'

22: waiting for 'SGA: allocation forcing component growth'

23: waiting for 'SGA: allocation forcing component growth'

24: waiting for 'rdbms ipc message'

25: waiting for 'SGA: allocation forcing component growth'

Cmd: Select

26: waiting for 'ASM background timer'

27: waiting for 'rdbms ipc message'

28: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

29: waiting for 'rdbms ipc message'

30: waiting for 'rdbms ipc message'

31: waiting for 'Streams AQ: qmn coordinator idle wait'

32: waiting for 'cursor: pin S wait on X'

Cmd: Select

33: waiting for 'PX Deq: Parse Reply'

34: waiting for 'SQL*Net message from client'

35: waiting for 'PX Deq: Parse Reply'

Cmd: Select

36: waiting for 'cursor: pin S wait on X'

Cmd: Select

37: waiting for 'cursor: pin S wait on X'

Cmd: Select

38: waiting for 'cursor: pin S wait on X'

Cmd: Select

39: waiting for 'cursor: pin S wait on X'

Cmd: Select

40: waiting for 'SGA: allocation forcing component growth'

Cmd: Select

41: waiting for 'Streams AQ: qmn slave idle wait'

42: waiting for 'PX Deq: Parse Reply'

Cmd: Select

43: for 'Streams AQ: waiting for time management or cleanup tasks'

44: waiting for 'PX Deq: Execution Msg'

Cmd: Select

45: waiting for 'PX Deq: Parse Reply'

Cmd: Select

46: waiting for 'PX Deq: Execution Msg'

Cmd: Select

47: waiting for 'PX Deq: Parse Reply'

Cmd: Select

48: waiting for 'enq: PS - contention' [Enqueue PS-00000002-00000E0C]

Cmd: Select

49: waiting for 'class slave wait'

50: waiting for 'SGA: allocation forcing component growth'

Cmd: PL/SQL Execute

51:

52: waiting for 'PX Deq: Parse Reply'

53: waiting for 'SGA: allocation forcing component growth'

Cmd: PL/SQL Execute

54: waiting for 'PX Deq: Execution Msg'

Cmd: Select

55: waiting for 'PX Deq: Parse Reply'

Cmd: Select

56: waiting for 'PX Deq: Parse Reply'

57: waiting for 'SGA: allocation forcing component growth'

58: waiting for 'PX Deq: Execution Msg'

Cmd: Select

59: waiting for 'SGA: allocation forcing component growth'

Cmd: Select

60: waiting for 'SGA: allocation forcing component growth'

Cmd: Select

61: waiting for 'PX Deq: Execution Msg'

Cmd: Select

62: waiting for 'PX Deq: Parse Reply'

63: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

64: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

65: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

66: waiting for 'PX Deq: Parse Reply'

67: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

68: waiting for 'SGA: allocation forcing component growth'

69: last wait for 'ksdxexeotherwait' [Rcache object=000007FF88BFD200,]

70: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

71: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

72: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

73: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

74: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

75: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

76: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

77: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

78: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

79: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

80: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

81: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

82: waiting for 'row cache lock' [Rcache object=000007FF88AC2658,]

83: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

84: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

85: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

86: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

87: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

88: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

89: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

90: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

91: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

92: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

93: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

94: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

95: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

96: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

97: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

98: waiting for 'row cache lock' [Rcache object=000007FF88AC2658,]

99: waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

100:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

101:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

102:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

103:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

104:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

105:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

106:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

107:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

108:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

109:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

110:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

111:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

112:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

113:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

114:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

115:waiting for 'row cache lock' [Rcache object=000007FF88AC2658,]

116:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

117:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

118:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

119:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

120:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

121:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

122:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

123:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

124:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

125:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

126:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

127:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

128:waiting for 'row cache lock' [Rcache object=000007FF88AC2658,]

129:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

130:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

131:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

132:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

133:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

134:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

135:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

136:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

137:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

138:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

139:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

140:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

141:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

142:waiting for 'row cache lock' [Rcache object=000007FF88BFD200,]

143:waiting for 'row cache lock' [Rcache object=000007FF88AC2658,]

Blockers

~~~~~~~~

Above is a list of all the processes. If they are waiting for a resource

then it will be given in square brackets. Below is a summary of the

waited upon resources, together with the holder of that resource.

Notes:

~~~~~

o A process id of '???' implies that the holder was not found in the

systemstate.

Resource Holder State

Latch received-location: ??? Blocker

Enqueue DR-00000000-00000000 ??? Blocker

Rcache object=000007FF88BFD200, 57: waiting for 'SGA: allocation forcing component growth'

Enqueue PS-00000002-00000E0C 48: Self-Deadlock

Rcache object=000007FF88AC2658, 68: waiting for 'SGA: allocation forcing component growth'

Query Co-Ordinator to Query Slave Mapping

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

QC= 33: [Count=1]

Communicates with Slave 0 (hex) on instance 2 (PS-02-0E0E)