I have installed Oracle 9.2.0.1 (Release 2) Enterprise edition on Windows 2000 Server. Then I installed Oracle Clinical application 4.5 (database) on the same server and configured it.
The database Server is a domain controller with a domain name techobs.com. This machine is linked to another Windows Server 2000 machine on which I have installed Oracle 9iAS. However, I have not installed the entire components of the CD. As per my Oracle Clinical install manual, this is supposed to house the WebServer and the Reports server. And then there is a client on another machine making it a three tier architecture. all machines have been partitioned with Windows Server 2000 OS on a seperate partition and Oracle on another partition.
Machine 1 is W2KOCSVR.techobs.com - Oracle DB server 9.2.0.1 patched to 9.2.0.3 with Oracle Clinical 4.5 patched with relevant patches as per the install manual.
Machine 2 - is OCMIDTIER.techobs.com - Oracle Clinical Front end installed against Oracle_806 home which houses Oracle forms 6i. Component - Oracle forms and Repirts server was chosen from the CD.
Then the installation also installs the Webserver compoenents in a new home - Oracle\iSuites.
The Oracle Pharma application home is E:\opapps45.
OC4J is part of the front end install with port number 7881
On mc-2 - I also installed Oracle 9iDS (COMPLETE) which is the compenent used for Oracle Clinical Reports server. This is in a another home Oracle\9iDS. So there are 3 homes on the middle tier machine - 2 OCMIDTIER.techobs.com
All patches were applied to Oracle 9iDS as per the install Oracle Clinical install manual.
All the machines have been networked through a Linksys router. The Apache server was configured on the middle tier as per the patch instructions. Note: Oracle Forms server 6i is not used but a Forms servlet is used instead.
I can ping machine 2 from machine 1 and vice versa. I can TNSPING the OC database on machine 1 from machine 2 but only from the Oracle\9iDS home. When I TNSPING the Oracle Clinical DB server (W2KOCSVR machine 1) from the Oracle\806 home on (OCMIDTIER mc-2), it comes up with a message attempting to contact ADDRESS=(PROTOCOL=TCP)(HOS
T=W2KOCSVR
)(PORT=152
1) and comes out. (I am not sure why because the PATH variables have been set to include all the 3 homes on OCMIDTIER (mc-2).
Problem 1 - I see a message oracle.net.config.ServiceA
liasExcept
ion: 10 in the EM console even though the dbase starts up without a problem. (minor issue but needs to be fixed)
Problem 2 - IMPORTANT and the reason for this request. When I bring up the launch page to log into the application from the middle tier (as client), the first time, it downloads the Jinitiator 1.1.8.21 and installs it. Then when I attempt to connect to the database with a username and passowrd, I get a FORMS RUNTIME ERROR.
Error: FRM-92101 A failure has occured on the server. You will need to re-establish your session.
==========================
==========
==========
==========
==========
=========
Details of the error below: 500 POINTS to have this resolved.
==========================
==========
==========
==========
==========
==========
Tue Mar 14 22:27:02 EST 2006
==========================
==========
==========
==========
==========
==========
Oracle JInitiator version 1.1.8.21
Using JRE version 1.1.8.21
User home directory = C:\Documents and Settings\opareps
JAR caching enabled.
Cache directory: C:\Program Files\Oracle Corporation\Oracle JInitiator 1.1.8.21\jcache
Maximum cache size: 50000000 bytes
Getting JAR file sizes...
---------REMOVED LINES related to jar files -------
Opening
http://ocmidtier.techobs.com/servlet/opaservlet?JServSessionIdroot=27vtf4q4k1.pQbHokfOokjM/BfzmQvJmBaImQXHcALJmQ5Go6XNr3CNa34R no proxy
Forms Applet version is : 60825
oracle.forms.net.Connectio
nException
: Forms session <1> aborted: unable to communicate with runtime process.
at java.lang.Throwable.<init>
(Compiled Code)
at java.lang.Exception.<init>
(Compiled Code)
at java.io.IOException.<init>
(IOExcepti
on.java:45
)
at oracle.forms.net.Connectio
nException
.<init>(Un
known Source)
at oracle.forms.net.Connectio
nException
.createCon
nectionExc
eption(Com
piled Code)
at oracle.forms.net.HTTPNStre
am.getResp
onse(Compi
led Code)
at oracle.forms.net.HTTPNStre
am.doFlush
(Compiled Code)
at oracle.forms.net.HTTPNStre
am.flush(C
ompiled Code)
at java.io.DataOutputStream.f
lush(DataO
utputStrea
m.java:92)
at oracle.forms.net.StreamMes
sageWriter
.run(Compi
led Code)
Opening
http://ocmidtier.techobs.com/forms60java/oracle/ewt/alert/resource/AlertBundle_en_US.class no proxy
Opening
http://ocmidtier.techobs.com/forms60java/oracle/ewt/alert/resource/AlertBundle_en_US.properties no proxy
=============== ----------------- ==========================
CONTENTS of Jserv.log
Perspective for Java Version 1.1.
Copyright(C) 1998-99 Three D Graphics, Inc.
Environment: Sun Microsystems Inc.
Operating System: Windows NT
Java Version: 1.2.2
Imaging Model: Lightweight
Locale: en_US
Build Number [tdgswing.0415.07].
[14/03/2006 15:47:12:781 EST] Viewer/oracle.discoiv.Disc
o4iv: Initialized Discoverer 4i Viewer (4.1.38.16.0)
[14/03/2006 22:26:59:186 EST] f60servlet/oracle.forms.se
rvlet.Form
sServlet: init
FormsServlet init():
configFileName: D://ORACLE//806/forms60/se
rver/forms
web.cfg
testMode: false
baseHTMLJinitiator: D://ORACLE//806/forms60/se
rver/basej
ini.htm
baseHTMLJpi: null
baseHTMLie: D://ORACLE//806/forms60/se
rver/basei
e.htm
baseHTML: D://ORACLE//806/forms60/se
rver/base.
htm
[14/03/2006 22:26:59:202 EST] f60servlet/FormsServlet init():
configFileName: D://ORACLE//806/forms60/se
rver/forms
web.cfg
testMode: false
baseHTMLJinitiator: D://ORACLE//806/forms60/se
rver/basej
ini.htm
baseHTMLJpi: null
baseHTMLie: D://ORACLE//806/forms60/se
rver/basei
e.htm
baseHTML: D://ORACLE//806/forms60/se
rver/base.
htm
[14/03/2006 22:27:04:718 EST] opaservlet/oracle.forms.se
rvlet.List
enerServle
t: init
ListenerServlet init()
EnvFile: D:\ORACLE\806\forms60\serv
er\opa45.e
nv
WorkingDirectory: null
Executable: null
WaitTime: 500
MaxBlockTime 1000
[14/03/2006 22:27:04:718 EST] opaservlet/ListenerServlet
init()
EnvFile: D:\ORACLE\806\forms60\serv
er\opa45.e
nv
WorkingDirectory: null
Executable: null
WaitTime: 500
MaxBlockTime 1000
Forms session <1> aborted: unable to communicate with runtime process.
[14/03/2006 22:27:48:124 EST] opaservlet/Forms session <1> aborted: unable to communicate with runtime process.
[14/03/2006 22:27:48:124 EST] opaservlet/Forms session <1> exception stack trace:
java.io.IOException: FRM-93000: Unexpected internal error.
Details : No HTTP headers received from runform
at oracle.forms.servlet.Liste
nerServlet
.forwardRe
sponseFrom
Runform(Un
known Source)
at oracle.forms.servlet.Liste
nerServlet
.doPost(Un
known Source)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
521)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
588)
at org.apache.jserv.JServConn
ection.pro
cessReques
t(JServCon
nection.ja
va:456)
at org.apache.jserv.JServConn
ection.run
(JServConn
ection.jav
a, Compiled Code)
at java.lang.Thread.run(Threa
d.java, Compiled Code)