Home > Oracle in general > 11g Release 2 for Windows – Grid Infrastructure Installation for Single Databases

11g Release 2 for Windows – Grid Infrastructure Installation for Single Databases

The following pictures show the grid infrastructure installation of Oracle 11g Release 2 for Windows. This is a rather short posting without much text because the pictures are quite self-explaining.

Requirements

Windows

Note there is no grid infrastructure or ASM for 32-bit Windows!

According to the documentation the following Windows versions are certified for Oracle 11g Release 2:

  • Windows Server 2003 x64 with service pack 1 or higher.
  • Windows Server 2003 R2 x64
  • Windows Server 2008 x64 Standard, Enterprise, Datacenter, Web, and Foundation editions.
  • Windows Server 2008 R2 x64 Standard, Enterprise, Datacenter, Web, and Foundation editions

Windows Core Editions are NOT supported!

Storage

For storing your database you can use the following storage options:

  • plain file system (NTFS recommended or FAT)
  • ASM
  • Oracle NFS for Windows

In this guide we are using ASM for storing our data files.

Installation Slides

If no ASM disk show up you most probably have to mark disks for ASM usage first as shown in the next two slides:

Categories: Oracle in general Tags:
  1. Praveen Mall
    September 13th, 2010 at 10:23 | #1

    Hi Ronny

    Sorry if I am not putting this question in the right blog !!

    I have installed grid as well as oracle DB software on win2k8r2. As I am seeing grid installation creating the default listener which runs from grid home running on port 1521.
    I create my DB “orcl” on top of that (using dbca which is only in oracle home)
    What I see listener.ora is in ../grid/network/admin and tnsnames.ora is in …/dbhome_1/network/admin/ …I found that listener.ora (created for grid listener in grid home) is different than which gets created in oracle home (if you create listener from oracle home using netca) .
    First Question is that ..why they are different? I have seen
    SID_LIST_LISTENER = , this patricular tag doesnt come in grid by default..listener.ora
    I added it to listener.ora

    Default listener.ora

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.108.153)(PORT = 1521))
    )
    )

    Now listener.ora in grid home look like this after change:

    # listener.ora Network Configuration File: C:\app\administrator\product\11.2.0\grid\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.108.153)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\grid)
    (PROGRAM = extproc)
    (ENVS = “EXTPROC_DLLS=ONLY:C:\app\administrator\product\11.2.0\grid\bin\oraclr11.dll”)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = orcl )
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\grid)
    (SID_NAME = orcl )
    )
    )

    ADR_BASE_LISTENER = C:\app\administrator

    ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
    DIRECT_HANDOFF_TTC_LISTENER=OFF

    Second question is that : Is this the right configuration , using grid listener for database?

    Third Question: Can I have one more listener created form oracle home using netca running on port 1522?

    I did googling a lot on this but didnt find anything useful.

    Thank you

  2. Ronny Egner
    September 13th, 2010 at 10:35 | #2

    Hi,

    thats pretty normal. When you connect to your cluster you connect to the SCAN listener. After that you will be redirected to the database listener.

  3. Praveen Mall
    September 13th, 2010 at 11:07 | #3

    but there is only one listener which is running from grid home
    I am able to connect to DB successfully and able create table and all other things.

    Questions here are:
    1)Is this right config to have grid listener only and DB?
    2)The way I have edited the listener.ora in grid dir

    by adding these many lines

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\grid)
    (PROGRAM = extproc)
    (ENVS = “EXTPROC_DLLS=ONLY:C:\app\administrator\product\11.2.0\grid\bin\oraclr11.dll”)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = orcl )
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\grid)
    (SID_NAME = orcl )
    )
    )

    is that right?

  4. Ronny Egner
    September 13th, 2010 at 11:11 | #4

    Hi,

    when running 11g R2 RAC you need at least ONE scan listener. Oracle recommends three.
    Plus there are default listeners one each node.

    All other solutions are risky – if not unsupported.

    From a quick glimpse i´ve seen the following:

    (ORACLE_HOME = C:\app\administrator\product\11.2.0\grid)
    (SID_NAME = orcl )

    Is your database running from the grid installation home? I doubt this is correct.

  5. Praveen Mall
    September 13th, 2010 at 11:17 | #5

    its not a rac ..its a standalone installation both grid as well as oracle software.
    Listener is running from grid home …which got created during grid installation(netca from grid home). running on port 1521.
    DB is created using DBCA which is in oracle home.
    Thank you

  6. Ronny Egner
    September 13th, 2010 at 11:23 | #6

    I see. I tought it is a RAC: In this case you dont need a scan listener. Running the listener from grid home is also fine. With a single instance you only need one listener.

  7. Praveen Mall
    September 13th, 2010 at 11:50 | #7

    Hey thanks a lot .
    But the way default content is generated of listener.ora is grid home for grid listener is diff than content of listener.ora in 11gr2 home or previous versions

    The following content is missing in the grid listener.ora

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = “EXTPROC_DLLS=ONLY:C:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll”)
    )

    )

    We have to make the DB entry which we are going to connect using this so I need to add the below lines to listener.ora

    (SID_DESC =
    (GLOBAL_DBNAME = orcl )
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\dbhome_1)
    (SID_NAME = orcl )
    )

    I will not be able to add above lines to to listener.ora if SID_LIST_LISTENER = is missing

    So Can I add whole below thing to listener.ora

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = “EXTPROC_DLLS=ONLY:C:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll”)
    )
    SID_DESC =
    (GLOBAL_DBNAME = orcl )
    (ORACLE_HOME = C:\app\administrator\product\11.2.0\dbhome_1)
    (SID_NAME = orcl )
    )

    )

  1. April 21st, 2010 at 07:06 | #1