This discussion is archived
1 2 3 10 Previous Next 138 Replies Latest reply: Jul 21, 2010 10:49 AM by 786583 RSS

Forms 10g installed and running on Windows Vista

user346369 Expert
Currently Being Moderated
<font color=0000FF>Update 12-Dec-2008: </font>Oracle has published NOTE 559067.1 -- How to Install Developer Suite 10.1.2.0.2 - hence 10.1.2.3 - on Windows Vista, 24-OCT-2008 with some installation help.
<font color=0000FF>Update 07-July-2008: </font> Added text at the bottom showing how to find patchsets for Forms 10g.

<font color=0000FF>Update 29-May-2008: </font> This thread was started in November, 2007.  In January, 2008, Oracle released Patch 3 for Forms 10g, which makes Forms 10g compatible with Windows Vista.  As time permits I'll try to keep the information in this post up to date.   Updated information will be inserted <font color=0000FF>as blue text.
</font>

<font color=0000FF>Original message begins here:</font>
This is a second thread I am posting to outline the steps I have used to install Forms on a Windows Vista Home Basic laptop.   The other thread describes installing Forms 6i:
      Forms 6i installed and running on Windows Vista
Please read through the initial part of that post for the background.  I realize Oracle has not certified Forms 10g to run on Vista, but the time has come for my associates and I to upgrade our old computers to new desktop/laptop platforms, and I would hate to acquire XP machines and be stuck with them for the next 5 years.  <font color=0000FF>(Note: Since first posting this message, Oracle has certified Forms 10g Patch 3 (version 10.1.2.3.0) to run on Vista)</font>  So after another person informed me that he had Forms installed and running on Vista, I went ahead and bought one.  I found that as long as I set the compatibility mode to run Forms programs as Windows XP (and a few other changes), Forms 6i and 10g run quite satisfactorily.

<font color=0000FF>Update 29-Jan-2008: </font> Unfortunately, it turns out that the Forms 10g Builder running on Vista <font color=0000FF>had</font> a major flaw:   If you try to develop a form, the Builder will crash if you try to compile a procedure that calls another procedure in the form that has errors.  The problem is reported and described in this thread:  Error compiling a form under Vista
<font color=0000FF>Update 12-Mar-2008: </font> Installing Patch 3 on Vista does not help with this problem -- the Builder still crashes in the same situation.
<font color=0000FF>Update 25-July-2008: </font> Applying Patch 7047034 has corrected the problem.   See this link within this thread:   Forms 10g: Installing Patch 7047034 on Windows Vista

Webutil note:  I am stuck in a Forms 6i client/server world, so all my forms must run in that environment.   Therefore I have not used any Webutil software, and I do not know whether that part will run under Vista.

Internet Explorer note:  On Windows Vista, IE CANNOT be used to run the Web Forms runtime.  It crashes immediately when you try to run a form.  Instead, I can use either Firefox (Firefox 2, Firefox 3.0 Crashes with Forms 10g) or Netscape, as long as they are set to disable java.  <font color=0000FF>[ Correction:   IE7 on Vista now runs the Forms 10g forms.   You just need to add "?config=jpi" to the browser URL when starting the Web Forms session.   More IE/Vista info: [url=http://forums.oracle.com/forums/thread.jspa?threadID=642973]Vista JInitiator Problem ]</font>

The Oracle Developer Suite download page:
    http://www.oracle.com/technology/software/products/ids/index.html

Oracle Developer Suite Installation Guide:
    http://download.oracle.com/docs/cd/B25016_07//doc/dl/core/B16012_04/toc.htm

The steps below are those I followed to install Forms 10g (version 10.1.2.0.2)

I.  Preliminary system changes in Windows

When I started installing, I got the following error message:
    Install has encountered an error while
    attempting to verify your virtual memory settings.
    Please verify that the sum of the initial sizes of
    the paging files is at least 256 MB.
To fix this:  Go to Control Panel, System and Maintenance, View amount of RAM and processor speed (under "System"),
Advanced system settings (in left "Tasks" column), Advanced tab, Settings (under "performance"), Advanced tab:
Virtual Memory shows a "Total paging file size for all drives: 2337MB.
Click "change", Uncheck "Automatically manage paging file size for all drives"
Click "custom size:", set Initial size to: 2048, Max to 4096
Click set button, then OK, get message:
The changes you have made require you to restart your computer before
   they can take effect.
Restart the computer.


II.  Installing Forms 10g

1.  Download two files from Oracle:
    ds_windows_x86_101202_disk1.zip (626,122,752 bytes)
    ds_windows_x86_101202_disk2.zip (236,880,881 bytes)

2a.  Before extracting, it is a good idea to shut down any virus protection software.  It can sometimes prevent some files from being created.
2b.  Extract both into the C:\oracle directory, as disk1 and disk2.

3.  Using Windows Explorer, change the properties of setup.exe in the C:\oracle\disk1 folder.  (In windows explorer, right click, properties, Compatibility tab.)   Change the compatibility to run as Windows XP (Service Pack 2).

4.  Right click setup.exe and click "Run as administrator"

5.  Select "Installation type" = Complete (1.11 GB)

6.  Received this message:
Windows Firewall has blocked this program from 
accepting incoming network connections.  If you
unblock this program, it will be unblocked on all
public networks that you connect to.
C:\users\steve\appdata\local\temp\orainstall...
  2007-10-29_11-59-08am\jre\1.4.2\bin\javaw.exe
I clicked "Unblock"

7.  Received this message:  "Provide outgoing mail server information"  I entered the smtp mail server that I use.

8.  A summary screen displayed showing 274 products under New Installations.
I clicked the Install button.

9.   Received this message:  You can find a log of this install session at:
C:\Program Files\Oracle\Inventory\logs\installActions2007.....log

10.  The installation completed.  Installed products shows Forms 10.1.2.0.2


III.  After the install completed

1.  Create a shortcut to the Forms 10 Builder on the Desktop.

On the shortcut line, after the .exe, add *userid=userxxx/pwxxx@orcl* so Builder automatically logs into 10g database.  If you do step 4 below (creating an easily-accessible folder to use for your forms) change the "Start in" path on the shortcut so it points to that folder.  Otherwise, Forms Builder will not find referenced objects and PLL libraries when it opens a form.  Also do the same on the Start, All Programs shortcut for the Forms Builder.

Edit:  After applying Patch 3, the following steps are not necessary.
Set its compatibility to Windows XP.
Set checkbox: "Run this program as as an administrator."  (Without this, FormBuilder will NOT open a PLL library.)
Click the "Show settings for all users" and change values there.

2.  Copy "Start OC4J Instance" icon to desktop.
Set its compatibility to Windows XP.
The first time it runs, I got a Windows popup to unblock program named Java.  I clicked "Unblock".

3.  tnsnames.ora:
Rename C:\oracle\DevSuiteHome_1\network\admin\tnsnames.ora
to:  tnsnames_orig.ora

If you created a tnsnames.ora file for Forms 6i, just copy it to the path above.  If not, do this:

Create a new tnsnames.ora file, copying entries old file on my old laptop, which contains all the connections I use.
Delete the old laptop entry, replace with new entry for the new local ORCL connection on new laptop from tnsnames file renamed from the c:\oracle\... ...\10.2.0\db_1\ path.

4.  Optional:  Create an easily accessible folder to store fmb files:
C:\users\steve\.1\fmb10
You don't really want to keep drilling into C:\oracle\DevSuiteHome_1\forms, and then find your .fmb file among the several dozen oracle-supplied files.

To create a folder named .1, you have to open a CMD.exe (Windows DOS) window, and type the Make Directory command:
MD .1
That will create the folder within the current directory -- mine defaults to C:\users\steve

Note:  If you also need to use Forms 6i like me, DO NOT EVER open a .fmb file in the Forms 10 Builder from the Forms 6i folder.  If you compile it, or even worse, save the .fmb, Forms 6i *cannot ever* access the file.  Instead, always use the File Manager (Windows Explorer) to copy the fmb from the fmb6 folder into the fmb10 location.

5.  Change the Forms 10g Default.env file using a text editor.

This file replaces all the settings originally written to the Windows Registry (GREAT idea, Oracle!  I hate the registry.)  No more Regedit.  The default.env file is located at: (DevSuiteHome_1 path)\forms\server\default.env

Locate line with:  FORMS_PATH= and add:
    ;C:\users\steve\.1\fmb10

Add a new line:
FORMS_MMAP=FALSE
The above allows compiling an fmx while the form is running.

Add a new line:
FORMS_ROWLOCK_OPTIMIZATION=FALSE
(This fixes Oracle bug number 3949854, which prevents automatic skipping if the same value is typed over another value. TAR 4806199.993 Automatic Skip failure...)  See bug 4068896

Add a new Line:
FORMS_RESTRICT_ENTER_QUERY=False
This allows use of Query-Where window in enter query, after entering a colon in any input field.  Without this, Forms returns FRM-40367: Invalid criteria in field nnn in example record.  Oracle shut it down to prevent "sql injection" attacks.


6.  Jiniator setup:

Run file jinit.exe in C:\oracle\DevSuiteHime_1\jinit\jinit.exe
It installs Jinitiator 1.3.1.22.
I installed it in C:\oracle\JInitiator 1.3.1.22\
For Firefox, make sure a copy of file \bin\NPJinit13122.dll resides in   C:\Program Files\Mozilla Firefox\plugins.
For Netscape, the path is:  C:\Program Files\Netscape\Navigator 9\plugins


7.   Browser settings

See the note above about using Firefox 2 and not Firefox 3!

In Firefox 2 go to:  Tools-> Options-> Content
Uncheck the "Enable Java" checkbox
--Firefox terminates if this is not done!
Note:  After my system automatically installed updates to either java or Firefox, re-check the "Enable Java" setting.  I am suspicious that one of these installs re-enables java in the browser.

Also note:  some web sites cannot display properly if java is disabled.  Example:  U.S. time website: http://www.time.gov   Use Internet Explorer to view these.

In Netscape make the same changes as Firefox.  Without disabling java, it also terminates when you try to run a form.

Creating a url to use in the browser:
Try this:
    http://127.0.0.1:8889/forms/frmservlet
If it does not work, change the 8889 port number as follows:
Open file:  C:\oracle\DevSuiteHome_1\install\portlist.ini
Note the number in line:
Oracle Developer Suite HTTP port = 8889
Use the number as the port number.
You can also change the 127.0.0.1 to the computer name:
Control Panel, System and Maintenance, See the name of this computer (under "System").  Mine is "steve-PC"
So the alternate URL is:     http://steve-PC:8889/forms/frmservlet
To try out the URL, start the OC4J instance set up above.  Then start either Netscape or Firefox, and enter the URL.  You should get a welcome screen.

If the above URL works, start up the Forms Builder, and open Edit, Preferences.  On the General tab, uncheck the "Build before running" check box (optional).  On the Runtime tab, set the "Application Server URL to the url above.

To run a real form, add this to the URL after frmservlet, (with no spaces):
    ?form={formname}&userid={userxxx}/{passwordyyy}@{connect-string}
but replace the parts in curly braces with the appropriate values.  Example:
    http://127.0.0.1:8889/forms/frmservlet?form=ABC&userid=abc123/zyx@orcl


Setting up Forms Builder to directly run a form in the browser:
Run the Forms Builder.  Go to Edit, Preferences, Runtime tab.
Set the Application Server URL to:
    http://127.0.0.1:8889/forms/frmservlet
(or use whatever URL string you developed above)
Set the Web Browser Location to:
    "C:\Program Files\Netscape\Navigator 9\navigator.exe"
(or an equivalent to run the Firefox browser).


8.  FORMSWEB.CFG file changes
The file is located at:
C:\ORA_DS_101202\DevSuiteHome_1\forms\server\formsweb.cfg

I changed the following two lines in the file, but these are my personal preferences:
separateFrame=true
lookandfeel=Generic


9.  FMRWEB.RES file changes
For Oracle help:  Enabling Key Mappings

The file fmrweb.res defines actions (triggers that run) when a function key is pressed while running Forms.  The one released has unix-style key mapping, but I prefer keys originally mapped for Windows PC Forms users. There is a fmrpcweb.res in the same folder that can be renamed to fmrweb.res.

In the C:\oracle\DevSuiteHome_1\forms path, I renamed fmrweb.res to fmrweb_orig.res.

I have a file that I prefer to use, so I put it into the folder as fmrweb.res. The contents are listed below. It is organized so the most important keys are listed alphabetically at the top (URFD column is the sort column), followed by a group of less-important keys.  These are keys that are available to users, but they either would not use, or are disabled within most forms.  The URFD column in the second set starts with a hex A0 character, which is a high-order space, so collates after normal alphabetic characters.  (Note: If you want to copy the text below and use it, the hex A0 character has been changed by the forum software to a space. So you would need to use a text editor with hexadecimal character capabilities to replace the space with the original character. )

My file has special keys defined for F2 (I use it for a debugging Key-F2 trigger in my forms), and a "Cursor to Home" F12 function. All the rest are pretty much the same as in the released fmrpcweb.res file, only mine are organized alphabetically on the URFD column.

The Web Forms fmrweb.res file is editable using any programming editor (NOT MS Word!!!). The old Client/Server key mapping file, fmrusw.res, could only be changed using the Oracle Terminal program (and it is a pain to use).

Here is the main part of my fmrweb.res file:
#
#Jfn :Jmn:  URKS            :Ffn :  URFD
#    :   : (User-readable   :    : (User-readable
#    :   :  Key-sequence )  :    :  function description)
#--   --- -----------------  ---  -----------------------
118  : 1 : "Shift F7"       : 74 : "Clear Form"
121  : 0 : "F10"            : 36 : "Commit"
117  : 0 : "F6"             : 65 : "Create Record"
10   : 1 : "Shift Enter"    : 82 : "Cursor to Home" # sdsu uses this
123  : 0 : "F12"            : 82 : "Cursor to Home" # sdsu uses this
                                    #: --Alt+Home works, but leaves the Action (first
                                    #: --pull-down menu item) highlighted.  Press Esc or
36   : 8 : "Alt Home, then Alt" : 82 : "Cursor to Home" #-- Alt again to clear highlight.
117  : 1 : "Shift F6"       : 63 : "Delete Record"
119  : 0 : "F8"             : 77 : "Execute Query"
120  : 0 : "F9"             : 29 : "List of Values"
9    : 0 : "Tab"            : 1  : "Next Field"
40   : 0 : "Down-Arrow"     : 7  : "Next Record"
9    : 1 : "Shift Tab"      : 2  : "Previous Field"
38   : 0 : "Up-Arrow"       : 6  : "Previous Record"
112  : 0 : "F1"             : 35 : "Show Keys"
116  : 1 : "Shift F5"       : 69 : " Clear Block"
116  : 2 : "Ctrl F5"        : 3  : " Clear Field"
113  : 1 : "Shift F2"       : 80 : " Count Query Hits"
112  : 1 : "Shift F1"       : 78 : " Display Error"
114  : 0 : "F3"             : 73 : " Duplicate Item"
115  : 0 : "F4"             : 64 : " Duplicate Record"
69   : 2 : "Ctrl E"         : 22 : " Edit Field"
122  : 0 : "F11"            : 75 : " Enter " # Causes validation, w/o cursor move
118  : 0 : "F7"             : 76 : " Enter Query"
81   : 2 : "Ctrl Q"         : 32 : " Exit"
112  : 2 : "Ctrl F1"        : 30 : " Help"
34   : 0 : "Page Down"      : 66 : " Next Set of Records" 
119  : 1 : "Shift F8"       : 79 : " Print"
10   : 0 : "Enter/Return key": 27: " Enter/Next Field"
33   : 0 : "Page Up"        : 12 : " Scroll Up"
116  : 0 : "F5"             : 87 : " F5 Key for special uses"
#121 : 3 : "Shift Ctrl F10" : 82 : " Function 0" #--disabled.  Cursor to home defined above
112  : 3 : "Shift Ctrl F1"  : 83 : " Function 1"
113  : 0 : "F2"             : 84 : " Function 2"
113  : 11: "Ctrl Alt Shift F2":95: " List Tab Pages" #<-REQUIRED, or F2 cant be assigned
114  : 3 : "Shift Ctrl F3"  : 85 : " Function 3"
115  : 3 : "Shift Ctrl F4"  : 86 : " Function 4"
117  : 3 : "Shift Ctrl F6"  : 88 : " Function 6"
118  : 3 : "Shift Ctrl F7"  : 89 : " Function 7"
119  : 3 : "Shift Ctrl F8"  : 90 : " Function 8"
120  : 3 : "Shift Ctrl F9"  : 91 : " Function 9"
<B>Finding Forms 10g Patchsets</B>
Here is how to do the search: Log into metalink ( https://metalink.oracle.com ), then click on the Patches & Updates tab, then Simple Search.

In "Search by", select Product or Family. Enter "Developer Forms" in the box.

Then click the Release choices, and select "iAS 10.1.2.3"

Patch Type should be "Patchset/Minipack"
Platform or Language should be "Microsoft Windows (32-bit)"
Click Go, and the Forms 10g patch should show up. As of July, 2008 the only one available is: [url=
https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=5983622&release=1710123&plat_lang=912P&patch_num_id=943599
]5983622

Edited 2008-12-12 to add a link to Oracle Note 559067.1  and added the fmrweb.res file listing.
Edited 2008-10-28 to change text format to work better within new forum format
Edited 2008-7-7 to add patchset search information.
Edited 2008-4-21 to modify information.
Edited 2008-3-6 to add information.
Edited 2008-5-29 to update information.
  • 1. Re: Forms 10g installed and running on Windows Vista
    FrançoisDegrelle Oracle ACE
    Currently Being Moderated
    Steve,

    I think that you'd better have to also put this great information on your own site, so that it could be stay on top of something.
    I'm sure that this info would still interest people in a few years, but this thread would be probably very far in the forum history's pages.

    Francois
  • 2. Re: Forms 10g installed and running on Windows Vista
    user346369 Expert
    Currently Being Moderated
    Good idea, Francois. I hope people will post responses to it here, first, so I can correct or improve it as needed.

    And Oracle is coming out with Forms 11 soon (I hope), so some things should change.
  • 3. Re: Forms 10g installed and running on Windows Vista
    221488 Journeyer
    Currently Being Moderated
    This is really good info Steve. Thanks
  • 4. Re: Forms 10g installed and running on Windows Vista
    604396 Newbie
    Currently Being Moderated
    I followed your instructions and installed Developer Suite 10G on Windows Vista Home Premium edition. I have Oracle 11G DB running on the same machine.

    Two points, Steve:

    1. When I tried to set the maximum virtual memory to 6110 an error message displayed from Windows and told me that I can't set the maximum virtual memory to more than 4096. I set it to 4090 and it worked and I got nothing wrong during the installation process.

    2. After installing JInitiator and disabling Java on Firefox I called the http://127.0.0.1:8889/forms/frmservlet page and everything seemed to be OK because the Oracle Forms Services logo appeared and then a successful installation message appeared , but as I clicked (ok) to continue a gray screen appeared inside the browser (like the one displayed when you try to run a Java applet inside a browser) and then I wait to death till something appears but sadly nothing. I just get a blank gray screen inside my Firefox browser.

    Do you have any idea what to do to solve the problem?
    Regards
  • 5. Re: Forms 10g installed and running on Windows Vista
    user346369 Expert
    Currently Being Moderated
    MichealAngelo:

    1. I am sure the maximum virtual memory of 4096 is ok. My Vista system showed a recommended size of 3055 MB, so I used that, and then doubled it for the maximum. But it was just a guess, nothing more. I'll revise my notes above.

    2. That is what you should get.  You must change the browser's URL to run an actual form. Please note the last section above under Browser Settings:
        To run a real form, add this to the URL after frmservlet,
          (without space):
             ?form={formname}&userid={userxxx}/{passwordyyy}@{connect-string}
          but replace the parts in curly braces with the appropriate values.
          Example:
            http://127.0.0.1:8889/forms/frmservlet?form=ABC&userid=abc123/zyx@orcl
  • 6. Re: Forms 10g installed and running on Windows Vista
    612740 Newbie
    Currently Being Moderated
    Thanks for your detailed posting. I have all the informations, I want to know in a concise manner about installation Form 10g.. Once again thank you
  • 7. Re: Forms 10g installed and running on Windows Vista
    615224 Newbie
    Currently Being Moderated
    Hi,
    I just bought my new laptop(windows vista) few days back. I have installed Oracle Database 10g(10203_database_vista) on my laptop. It is working fine.

    Now I am trying to install the forms ds_windows_x86_101202_disk1 and ds_windows_x86_101202_disk2 on the same laptop. I am receiving the following error. I am just following the same instruction as you have described in this thread.

    Here is the message.....

    Using paramFile: C:\oracle\disk1\install\oraparam.ini


    Checking installer requirements...

    Checking operating system version: must be 5.0, 5.1 or 5.2. Actual 6.0
    Failed <<<<

    Exiting Oracle Universal Installer, log for this session can be found at C:\Program Files\Oracle\Inventory\logs\installActions2007-12-27_08-51-53PM.log

    Please press Enter to exit...

    Any pointer to resolve the issue is appreciated.

    thanks,

    sudam.
  • 8. Re: Forms 10g installed and running on Windows Vista
    user346369 Expert
    Currently Being Moderated
    You did not set the setup.exe compatibility to run as Window XP. It is written above:
      3.  Using Windows Explorer, change the properties of setup.exe
          in the C:\oracle\disk1 folder. (In windows explorer, right click,
          properties, Compatibility tab.)  Change the compatibility to 
          run as Windows XP (Service Pack 2).
  • 9. Re: Forms 10g installed and running on Windows Vista
    607301 Newbie
    Currently Being Moderated
    Hi Steve,

    Thanks for giving detail information about forms implementation in Window Vista.
    I tried it and it worked out.

    Thanks again genius
  • 10. Re: Forms 10g installed and running on Windows Vista
    618861 Newbie
    Currently Being Moderated
    Thank you Steve. I followed your instructions and was able to get the forms builder to work. Hopefully I will not run into any more problems as I try to finish my class homework.
  • 11. Re: Forms 10g installed and running on Windows Vista
    617554 Newbie
    Currently Being Moderated
    Awesome. This helped me alot. I look forward when 8. FORMSWEB.CFG file changes and 9. FMRWEB.RES file changes are updated ;)
  • 12. Re: Forms 10g installed and running on Windows Vista
    user346369 Expert
    Currently Being Moderated
    I'll try to get the FORMSWEB.CFG and FMRWEB.RES files posted soon. They are just configured to fit my preferences. Nothing special for the Vista environment.

    But I have just confirmed that the 10g Builder crashes under a very simple situation -- compiling procedure A where it calls procedure B. If procedure B has errors, the builder crashes. This is a major problem. I have posted a link above in the first post in this thread.
  • 13. Re: Forms 10g installed and running on Windows Vista
    567066 Newbie
    Currently Being Moderated
    Steve,

    Can you please tell me how could I have the "Start OC4J instance" always up and running in my server. I want the Forms server ( 10g) up and running all the the time. please advice how could I do that. My DB is 11g and using the Oracle Devsuite 10g. Please advice

    Thanks
    Sheik
  • 14. Re: Forms 10g installed and running on Windows Vista
    user346369 Expert
    Currently Being Moderated
    You can create a new String Value in the registry at
    HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / Windows / CurrentVersion / Run
    with command to start the OC4J application.

    Then it will start when you boot Windows.
1 2 3 10 Previous Next