Oracle 9iAS, Oracle 9i RAC and HPUX11i

[Warren_5]

Hello everyone,

I'm presently investigating a problem faced by my customer. They are having some problems running webforms on their 3-tier application. Their setup consists of the following :

1) Oracle 9iAS
2) Oracle 9i RAC
3) HPUX11i

I would like to know if there are any users who have a similar setup and is working fine.

Thanks in advance for your response.

[Ravi_8]

Hi,

we have oracle9i r2 AS running on 11i.
it's fine. I don't think RAC shouldn't cause any problem.

[Yogeeraj_1]

hi,

we have:

1) Oracle 9iAS release 2
2) Oracle 8i (8.1.7.4)
3) HPUX11i

and is working rather well.

Our 9iAS installation was a nightmare, but we managed to make it work.

Best Regards
Yogeeraj

[Warren_5]

Ravi & Yogeeraj,

Thanks for your replies. Could you let me know the version of your software?

Let me be more specific about the software version that are used :

HPUX11i-OE-Ent version B.11.11.0109
Oracle 9iAS version 1.0.2.2.2
Oracle 9i RAC version 9.0.1.4.0
Java 2 SDK for HP-UX version 1.2.2.13
HP Apache Web Server version 1.3.19
Jserv plug-in version 1.1.2
Reports (part of 9iAS) version 6.0.8.18.0
Forms (Part of 9iAS) version 6.0.8.18.3
Java run time initiator on client machine version 1.1.8.16
Client machines are running on Windows 98 and Windows 2000

Cheers!

[Steven E. Protter]

We are running 9ias v1(Release 1)

Oracle 8.1.7.4

HP-UX 11.11 64 bit.

It was hard, but its all running pretty well.

SEP

[Warren_5]

Hi ravi,

Are you using Oracle 9iRAC? Could you let me know the version of your Java 2 SDK and HP Apache web server?

Hi Yogeeraj and Steven,

Could you let me know the version of your Java 2 SDK and HP Apache web server?

Thanks a lot!

[Yogeeraj_1]

hi,

swlist -l product|grep -i "sdk"
Jdk13 1.3.1.06.00 Java2 1.3 SDK
swlist -l product|grep -i "apache"
ApacheStrong 1.3.19.23 HP Apache-based Web Server with Strong (128bit) Encryption

but remember, my 9iAS is using the default apache that comes with the 9iAS installation itself.

hth
Yogeeraj

[Warren_5]

Let me describe the problem:

Users running on windows machines are not able to view the reports that are generated by the 9iAS server. This happens regardless of the size of the reports but very evident in huge ones. It is confirmed that the report file had been generated on the server, but when viewed on the client's browser, it will hang/crash their session. The Jserv process will be terminated and below is the error from the Jserv.log:

[17/03/2003 16:08:36:120] (EMERGENCY) ajp12: connection fail
[17/03/2003 16:08:36:120] (ERROR) an error returned handling request via protoco
l "ajpv12"
[17/03/2003 16:08:37:817] (INFO) wrapper: Java VM exited (PID=5159)
[17/03/2003 16:08:37:818] (INFO) wrapper: Java VM restarting (PID=5159)
[17/03/2003 16:08:37:820] (INFO) wrapper: Java VM spawned (PID=8096, PPID=5159)
[17/03/2003 03:08:39:229 GMT-05:00] Viewer/oracle.discoiv.Disco4iv: init
[17/03/2003 03:08:39:229 GMT-05:00] Viewer/oracle.discoiv.Disco4iv: Initializing
Discoverer 4i Viewer (4.1.36.75)

The apache log file shows the following messages:

[Mon Mar 17 16:08:32 2003] [info] [client 192.168.1.38] (32)Broken pipe: client
stopped connection before send body completed
Stack_Trace: error while unwinding stack
( 0) 0xc73029f4 report_error__FPciN21e + 0x54 [/opt/java1.2/jre/bin/../lib/P
A_RISC2.0/hotspot/libjvm.sl]
( 1) 0xc73e85f0 JVM_handle_hpux_signal + 0x390 [/opt/java1.2/jre/bin/../lib/
PA_RISC2.0/hotspot/libjvm.sl]
( 2) 0xc73e824c signalHandler__FiP9__siginfoPv + 0x14 [/opt/java1.2/jre/bin/
../lib/PA_RISC2.0/hotspot/libjvm.sl]
( 3) 0xc020fe10 _sigreturn [/usr/lib/libc.2]
[Mon Mar 17 16:08:32 2003] [info] [client 192.168.1.38] (32)Broken pipe: client
stopped connection before send body completed
[Mon Mar 17 16:08:32 2003] [error] [client 192.168.1.38] Premature end of script
headers: /servlet/RWServlet
[Mon Mar 17 16:08:32 2003] [info] [client 192.168.1.38] (32)Broken pipe: client
stopped connection before rflush completed
[Mon Mar 17 16:08:32 2003] [error] [client 192.168.1.38] Premature end of script
headers: /servlet/RWServlet
[Mon Mar 17 16:08:32 2003] [info] [client 192.168.1.38] (32)Broken pipe: client
stopped connection before rflush completed
[Mon Mar 17 16:08:32 2003] [error] [client 192.168.1.38] Premature end of script
headers: /servlet/RWServlet
[Mon Mar 17 16:08:32 2003] [info] [client 192.168.1.38] (32)Broken pipe: client
stopped connection before rflush completed


Any help is much appreciated.