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
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
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.
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?
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.
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
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.
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 )
)
)