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
Main Topics
Browse All Topics





by: bpetersePosted on 2006-03-15 at 15:57:10ID: 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/