Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186

    Unanswered: VML not working on Win 2008 32 bit enterprise, 10.2.0.3 database

    Oracle version 10.2.0.3

    I currently have a win 2003 enterprise server (32bit) Intel Xeon with 16GB ram and have /3GB and /PAE in the boot.ini to enable VLM and it's all working fine using all the extra memory for db block buffers.

    I now have a Win 2008 enterprise server (32bit) Intel Xeon and have set the corresponding switches as per microsofts docs, bcdedit /Set PAE ForceEnable - Physical Address Extension (Windows) and bcdedit /Set IncreaseUserVa 3072 - Who Moved My /3GB? - Ask the Performance Team - Site Home - TechNet Blogs but I just get :
    ORA-27102: out of memory
    OSD-00034: additional error information
    O/S-Error: (OS 8) Not enough storage is available to process this command

    I've set the registry key HKLM -> Software -> Oralce -> KEY_OraDb10g_home1 -> AWE_WINDOW_MEMORY exactly the same as the 2003 box at 500000000

    I've rebooted the box again just to make sure but it still doesn't work.

    Looking at Oracle Database Architecture on Windows it does not mention win 2008 at all so is there something different for Oracle to be able to access the extra memory?

    thanks
    Robert
    There are 10 types of people in the world, those that know Binary and those that don't.

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    Is anyone running this config or have any ideas?
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    Ok, I seem to have got around the first issue using this http://bit.ly/mpWcuy

    The new box has 16 cores on the cpu whereas the old box only had 4 so I had to up AWE_WINDOW_MEMORY registry entry to 1.2GB (as the calculated 1.07GB wasn't quite enough and the suggestion was to just up it to 1.2GB!)

    However, I am now getting a different issue when trying to open the database!

    C:\>sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jun 17 12:16:43 2011

    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

    Connected to an idle instance.

    SQL> startup mount
    ORACLE instance started.

    Total System Global Area 2.2330E+10 bytes
    Fixed Size 1414384 bytes
    Variable Size 1027722000 bytes
    Database Buffers 2.1299E+10 bytes
    Redo Buffers 2129920 bytes
    Database mounted.
    SQL> alter database open;

    alter database open
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kcbvmap_1], [], [], [], [], [], [],
    []



    Also, though at this stage it doesn't matter as I can't open the database, I can't push DB_BLOCK_BUFFERS past 2600000 even though the server has 72GB RAM. 2600000 uses just 22GB of ram (including the os and everything else on the box)
    There are 10 types of people in the world, those that know Binary and those that don't.

  4. #4
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    Anyone have any ideas how to trace the issue?

    DB runs fine with VLM switched off
    There are 10 types of people in the world, those that know Binary and those that don't.

  5. #5
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Robert,

    10.2.0.3 is NOT supported (for reasons you just seemed to find out) on the Win 2008 server.

    You'll need >= 10.2.0.4 for Win 2008 R1 (a.k.a Vista) or >= 10.2.0.5 for Win 2008 R2 (a.k.a. Win 7).
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •