Advertisement

03.14.2006 at 07:51PM PST, ID: 21774150
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

FRM-92101 RUNTIME error - No HTTP headers received from runform

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)(HOST=W2KOCSVR)(PORT=1521) 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.ServiceAliasException: 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.ConnectionException: 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>(IOException.java:45)
      at oracle.forms.net.ConnectionException.<init>(Unknown Source)
      at oracle.forms.net.ConnectionException.createConnectionException(Compiled Code)
      at oracle.forms.net.HTTPNStream.getResponse(Compiled Code)
      at oracle.forms.net.HTTPNStream.doFlush(Compiled Code)
      at oracle.forms.net.HTTPNStream.flush(Compiled Code)
      at java.io.DataOutputStream.flush(DataOutputStream.java:92)
      at oracle.forms.net.StreamMessageWriter.run(Compiled 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.Disco4iv: Initialized Discoverer 4i Viewer (4.1.38.16.0)
[14/03/2006 22:26:59:186 EST] f60servlet/oracle.forms.servlet.FormsServlet: init
FormsServlet init():
    configFileName:     D://ORACLE//806/forms60/server/formsweb.cfg
    testMode:           false
    baseHTMLJinitiator: D://ORACLE//806/forms60/server/basejini.htm
    baseHTMLJpi:        null
    baseHTMLie:         D://ORACLE//806/forms60/server/baseie.htm
    baseHTML:           D://ORACLE//806/forms60/server/base.htm
[14/03/2006 22:26:59:202 EST] f60servlet/FormsServlet init():
    configFileName:     D://ORACLE//806/forms60/server/formsweb.cfg
    testMode:           false
    baseHTMLJinitiator: D://ORACLE//806/forms60/server/basejini.htm
    baseHTMLJpi:        null
    baseHTMLie:         D://ORACLE//806/forms60/server/baseie.htm
    baseHTML:           D://ORACLE//806/forms60/server/base.htm
[14/03/2006 22:27:04:718 EST] opaservlet/oracle.forms.servlet.ListenerServlet: init
ListenerServlet init()
    EnvFile:          D:\ORACLE\806\forms60\server\opa45.env
    WorkingDirectory: null
    Executable:       null
    WaitTime:         500
    MaxBlockTime      1000
[14/03/2006 22:27:04:718 EST] opaservlet/ListenerServlet init()
    EnvFile:          D:\ORACLE\806\forms60\server\opa45.env
    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.ListenerServlet.forwardResponseFromRunform(Unknown Source)
      at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java, Compiled Code)
      at java.lang.Thread.run(Thread.java, Compiled Code)




Start your free trial to view this solution
Question Stats
Zone: Software
Question Asked By: ceecil
Solution Provided By: bpeterse
Participating Experts: 1
Solution Grade: A
Views: 237
Translate:
Loading Advertisement...
03.15.2006 at 03:57PM PST, ID: 16200405

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.15.2006 at 04:14PM PST, ID: 16200513

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.30.2006 at 06:14AM PST, ID: 16332456

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.06.2006 at 04:18AM PDT, ID: 16390646

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.10.2006 at 03:51AM PDT, ID: 16415976

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
03.15.2006 at 03:57PM PST, ID: 16200405
Sounds like quite the hornet's nest you got there. ;-p

Could you please post the contents of the formsweb.cfg and opa45.env files?  All my experience has been on Unix but there are similarities.  

I assume your default form is a login form of some sort?

>I am not sure why because the PATH variables have been set to include all the 3 homes on OCMIDTIER (mc-2).<

Paths & ENV vars are extremely important when starting up forms & reports.  Is there a startup script/bat files when you start the middle tier or are there a number of executables?  The solution could be as simple as having the correct paths & vars stated before starting each component.  


/bp/
Accepted Solution
 
03.15.2006 at 04:14PM PST, ID: 16200513
Hello bPeterse

Thank you for your comments. I will post the files soon. I am actually now upgrading the database to the latest release as per the new release manuals.  The reason as to why there are 3 homes is because of Oracle's crap. They use 806 forms and whose dll's are incompatible with the DB dlls.  They than changed it to a 3 tier architecture where they brought in the Oracle application server.  That installs 2 homes 1. Oracle\806 and 2. Oracle\iSuites. To make matters worse, they don't use the Forms server service but servlets instead after patching.  And then they user Oracle\9iDS for the reports server which became the third home.

I am presently upgrading and I will let you know the status before I post the upgraded files. But if you want them sent to you directly, let me know.

Thanks

Cecil
 
03.30.2006 at 06:14AM PST, ID: 16332456
Peterse:

I upgraded my Database server to 9.2.0.6.0, reinstalled the applicaton Oracle Clincial server side again. Then created the database for Oracle Clinical.

I upgraded the Middle Tier by actually re-installing the components again but this time using Oracle 10G for the reports server. All the services were up and running fine.

The entire installation requirments are a mess from Oracle. They use Oracle 9iAs for the Middle tier and infrastructure. and forms and reports server. Then I had to disable or remove the Forms and Reports server SERVICE. Patch the Forms server with some patch from Metalink.

The Reports server - I had to use Oracle 10G - Forms and Reports server component only. ( I had to remove Oracle 9iDS that was installed earlier and replace it with Oracle 10G).

The problem I had after all this was that I could not TNSPING my database from the Middle Tier. I tried to use the forum but did not succeed. then I thought of simply trying to connect through the application itself.  I started the DB server and brought up the database.  Then I started the Middle Tier and decided to launch the Oracle Cclinical application. After keying in the user name and pasword and db name, it usddenly connected and brought up the applicatin screen. nothing culd be better at this time. However, I still have not tested the Reports server to know whether it is working as I  have would first have to configure the applicaton to make sure that all relevant details have been enetered and mapped within the application before I test if all is well. But for the moment, my initial peoblem has been fixed.

Thanks for the inout. You can take 100 points for your effort to help resolve this issue.

This issue is now CLOSED.



 
04.06.2006 at 04:18AM PDT, ID: 16390646
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: bpeterse {http:#16200405}

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

anand_2000v
EE Cleanup Volunteer
 
04.10.2006 at 03:51AM PDT, ID: 16415976
Forced accept.

DarthMod
Community Support Moderator
 
 
20080236-EE-VQP-29