Sunday, 28 Feb 2010 9:44 PM
With CRS successfully installed and running, we can proceed with installation of Oracle RAC binaries and configure a RAC database. In this section we will see the screenshots for Oracle RAC database creation.
Perform Pre requisite checks
At this stage, we can run the cluvfy utility (stage is pre database installation) as follows
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
| $ ./cluvfy stage -pre dbinst -n rac-node-01,rac-node-02 -r 11gR2 -osdba dba -verbose
Performing pre-checks for database installation
Checking node reachability...
Check: Node reachability from node "rac-node-01"
Destination Node Reachable?
------------------------------------ ------------------------
rac-node-01 yes
rac-node-02 yes
Result: Node reachability check passed from node "rac-node-01"
Checking user equivalence...
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
rac-node-02 passed
rac-node-01 passed
Result: User equivalence check passed for user "oracle"
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 2GB (2097152.0KB) 1GB (1048576.0KB) passed
rac-node-01 2GB (2097152.0KB) 1GB (1048576.0KB) passed
Result: Total memory check passed
Check: Available memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 615.9883MB (630772.0KB) 50MB (51200.0KB) passed
rac-node-01 391.2266MB (400616.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 3.4939GB (3663576.0KB) 3GB (3145728.0KB) passed
rac-node-01 3.4939GB (3663576.0KB) 3GB (3145728.0KB) passed
Result: Swap space check passed
Check: Free disk space for "rac-node-02:/crs/app/11.2.0/grid"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/crs/app/11.2.0/grid rac-node-02 /crs 4.1658GB 583.68MB passed
Result: Free disk space check passed for "rac-node-02:/crs/app/11.2.0/grid"
Check: Free disk space for "rac-node-01:/crs/app/11.2.0/grid"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/crs/app/11.2.0/grid rac-node-01 /crs 4.1462GB 583.68MB passed
Result: Free disk space check passed for "rac-node-01:/crs/app/11.2.0/grid"
Check: Free disk space for "rac-node-02:/var/tmp/"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/var/tmp/ rac-node-02 / 2.8651GB 1GB passed
Result: Free disk space check passed for "rac-node-02:/var/tmp/"
Check: Free disk space for "rac-node-01:/var/tmp/"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/var/tmp/ rac-node-01 / 2.8636GB 1GB passed
Result: Free disk space check passed for "rac-node-01:/var/tmp/"
Check: User existence for "oracle"
Node Name Status Comment
------------ ------------------------ ------------------------
rac-node-02 exists(100) passed
rac-node-01 exists(100) passed
Checking for multiple users with UID value 100
Result: Check for multiple users with UID value 100 passed
Result: User existence check passed for "oracle"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
rac-node-02 exists passed
rac-node-01 exists passed
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
rac-node-02 exists passed
rac-node-01 exists passed
Result: Group existence check passed for "dba"
Check: Membership of user "oracle" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
rac-node-02 yes yes yes yes passed
rac-node-01 yes yes yes yes passed
Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed
Check: Membership of user "oracle" in group "dba"
Node Name User Exists Group Exists User in Group Comment
---------------- ------------ ------------ ------------ ----------------
rac-node-02 yes yes yes passed
rac-node-01 yes yes yes passed
Result: Membership check for user "oracle" in group "dba" passed
Check: Run level
Node Name run level Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 3 3 passed
rac-node-01 3 3 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
rac-node-02 hard 65536 65536 passed
rac-node-01 hard 65536 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
rac-node-02 soft 65536 1024 passed
rac-node-01 soft 65536 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
rac-node-02 hard 16384 16384 passed
rac-node-01 hard 16384 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
rac-node-02 soft 16384 2047 passed
rac-node-01 soft 16384 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 64-bit amd64 kernel modules 64-bit amd64 kernel modules passed
rac-node-01 64-bit amd64 kernel modules 64-bit amd64 kernel modules passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 5.10-2009.09.16.15.09 5.10-2008.10 passed
rac-node-01 5.10-2009.09.16.15.09 5.10-2008.10 passed
Result: Kernel version check passed
Check: Kernel parameter for "project.max-sem-ids"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 100 100 passed
rac-node-01 100 100 passed
Result: Kernel parameter check passed for "project.max-sem-ids"
Check: Kernel parameter for "process.max-sem-nsems"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 256 256 passed
rac-node-01 256 256 passed
Result: Kernel parameter check passed for "process.max-sem-nsems"
Check: Kernel parameter for "project.max-shm-memory"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 4294967296 4294967295 passed
rac-node-01 4294967296 4294967295 passed
Result: Kernel parameter check passed for "project.max-shm-memory"
Check: Kernel parameter for "project.max-shm-ids"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 100 100 passed
rac-node-01 100 100 passed
Result: Kernel parameter check passed for "project.max-shm-ids"
Check: Package existence for "SUNWarc-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWarc-11.10.0-2005.01.21.16.34 SUNWarc-... passed
rac-node-01 SUNWarc-11.10.0-2005.01.21.16.34 SUNWarc-... passed
Result: Package existence check passed for "SUNWarc-..."
Check: Package existence for "SUNWbtool-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWbtool-11.10.0-2005.01.21.16.34 SUNWbtool-... passed
rac-node-01 SUNWbtool-11.10.0-2005.01.21.16.34 SUNWbtool-... passed
Result: Package existence check passed for "SUNWbtool-..."
Check: Package existence for "SUNWhea-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWhea-11.10.0-2005.01.21.16.34 SUNWhea-... passed
rac-node-01 SUNWhea-11.10.0-2005.01.21.16.34 SUNWhea-... passed
Result: Package existence check passed for "SUNWhea-..."
Check: Package existence for "SUNWlibm-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWlibm-5.10-2004.12.18 SUNWlibm-... passed
rac-node-01 SUNWlibm-5.10-2004.12.18 SUNWlibm-... passed
Result: Package existence check passed for "SUNWlibm-..."
Check: Package existence for "SUNWlibms-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWlibms-5.10-2004.11.23 SUNWlibms-... passed
rac-node-01 SUNWlibms-5.10-2004.11.23 SUNWlibms-... passed
Result: Package existence check passed for "SUNWlibms-..."
Check: Package existence for "SUNWsprot-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWsprot-5.10-2004.12.18 SUNWsprot-... passed
rac-node-01 SUNWsprot-5.10-2004.12.18 SUNWsprot-... passed
Result: Package existence check passed for "SUNWsprot-..."
Check: Package existence for "SUNWtoo-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWtoo-11.10.0-2005.01.21.16.34 SUNWtoo-... passed
rac-node-01 SUNWtoo-11.10.0-2005.01.21.16.34 SUNWtoo-... passed
Result: Package existence check passed for "SUNWtoo-..."
Check: Package existence for "SUNWi1of-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWi1of-6.6.2.7400-0.2004.12.15 SUNWi1of-... passed
rac-node-01 SUNWi1of-6.6.2.7400-0.2004.12.15 SUNWi1of-... passed
Result: Package existence check passed for "SUNWi1of-..."
Check: Package existence for "SUNWxwfnt-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWxwfnt-6.6.2.7400-0.2004.12.15 SUNWxwfnt-... passed
rac-node-01 SUNWxwfnt-6.6.2.7400-0.2004.12.15 SUNWxwfnt-... passed
Result: Package existence check passed for "SUNWxwfnt-..."
Check: Package existence for "SUNWlibC-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWlibC-5.10-2004.12.20 SUNWlibC-... passed
rac-node-01 SUNWlibC-5.10-2004.12.20 SUNWlibC-... passed
Result: Package existence check passed for "SUNWlibC-..."
Check: Package existence for "SUNWcsl-..."
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 SUNWcsl-11.10.0-2005.01.21.16.34 SUNWcsl-... passed
rac-node-01 SUNWcsl-11.10.0-2005.01.21.16.34 SUNWcsl-... passed
Result: Package existence check passed for "SUNWcsl-..."
Check: Operating system patch for "Patch 137104-02"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 141445-09 Patch 137104-02 passed
rac-node-01 Patch 141445-09 Patch 137104-02 passed
Result: Operating system patch check passed for "Patch 137104-02"
Check: Operating system patch for "Patch 139575-03"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 139556-08 Patch 139575-03 passed
rac-node-01 Patch 139556-08 Patch 139575-03 passed
Result: Operating system patch check passed for "Patch 139575-03"
Check: Operating system patch for "Patch 139556-08"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 139556-08 Patch 139556-08 passed
rac-node-01 Patch 139556-08 Patch 139556-08 passed
Result: Operating system patch check passed for "Patch 139556-08"
Check: Operating system patch for "Patch 120754-06"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 120754-07 Patch 120754-06 passed
rac-node-01 Patch 120754-07 Patch 120754-06 passed
Result: Operating system patch check passed for "Patch 120754-06"
Check: Operating system patch for "Patch 119961-05"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 119961-05 Patch 119961-05 passed
rac-node-01 Patch 119961-05 Patch 119961-05 passed
Result: Operating system patch check passed for "Patch 119961-05"
Check: Operating system patch for "Patch 119964-14"
Node Name Applied Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 Patch 119964-16 Patch 119964-14 passed
rac-node-01 Patch 119964-16 Patch 119964-14 passed
Result: Operating system patch check passed for "Patch 119964-14"
Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Current group ID
Result: Current group ID check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
rac-node-02 022 0022 passed
rac-node-01 022 0022 passed
Result: Default user file creation mask check passed
Checking CRS integrity...
The Oracle clusterware is healthy on node "rac-node-02"
The Oracle clusterware is healthy on node "rac-node-01"
CRS integrity check passed
Checking Cluster manager integrity...
Checking CSS daemon...
Node Name Status
------------------------------------ ------------------------
rac-node-02 running
rac-node-01 running
Oracle Cluster Synchronization Services appear to be online.
Cluster manager integrity check passed
Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed
Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
Node Name Status
------------------------------------ ------------------------
rac-node-02 passed
rac-node-01 passed
Result: CTSS resource check passed
Querying CTSS for time offset on all nodes...
Result: Query of CTSS for time offset passed
Check CTSS state started...
Check: CTSS state
Node Name State
------------------------------------ ------------------------
rac-node-02 Active
rac-node-01 Active
CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Reference Time Offset Limit: 1000.0 msecs
Check: Reference Time Offset
Node Name Time Offset Status
------------ ------------------------ ------------------------
rac-node-02 0.0 passed
rac-node-01 0.0 passed
Time offset is within the specified limits on the following set of nodes:
"[rac-node-02, rac-node-01]"
Result: Check of clock time offsets passed
Oracle Cluster Time Synchronization Services check passed
Checking time zone consistency...
Time zone consistency check passed.
Pre-check for database installation was successful.
$ |
Create ASM Diskgroup for Data, Index, FRA
The diskgroup created during CRS installation – ACFS_DG was used for Voting disk and OCR. We must create diskgroups for storing database
1
2
3
4
5
6
| Login as oracle user
Set ORACLE_HOME, ORACLE_SID and PATH
$ export ORACLE_HOME=/crs/app/11.2.0/grid
$ export ORACLE_SID=+ASM1
$ export PATH=$PATH:.:$ORACLE_HOME/bin |
Login to the ASM instance as SYSASM, You will get ORA-15260: permission denied on ASM disk group if you login as SYSDBA
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| SQL> col path format a30
SQL> select a.group_number, b.name, a.path, a.state, a.mount_status
from v$asm_disk a,
v$asm_diskgroup b
where a.group_number = b.group_number(+);
GROUP_NUMBER NAME PATH STATE MOUNT_S
------------ ------------------------------ ------------------------------ -------- -------
0 /dev/rdsk/c1t4d0s0 NORMAL CLOSED
0 /dev/rdsk/c1t5d0s0 NORMAL CLOSED
0 /dev/rdsk/c1t6d0s0 NORMAL CLOSED
0 /dev/rdsk/c1t8d0s0 NORMAL CLOSED
0 /dev/rdsk/c1t9d0s0 NORMAL CLOSED
1 ACFS_DG /dev/rdsk/c1t1d0s0 NORMAL CACHED
1 ACFS_DG /dev/rdsk/c1t2d0s0 NORMAL CACHED
1 ACFS_DG /dev/rdsk/c1t3d0s0 NORMAL CACHED
8 rows selected. |
Disks 1 to 3 are used by ACSFS_DG. We will use the other available disks to create the diskgroups
The diskgroups are created as follows
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| SQL> create diskgroup DATA_DG
2 EXTERNAL REDUNDANCY
3 DISK '/dev/rdsk/c1t4d0s0','/dev/rdsk/c1t5d0s0','/dev/rdsk/c1t6d0s0';
Diskgroup created.
SQL> create diskgroup INDEX_DG
2 EXTERNAL REDUNDANCY
3 DISK '/dev/rdsk/c1t8d0s0';
Diskgroup created.
SQL> create diskgroup FRA_DG
2 EXTERNAL REDUNDANCY
3 DISK '/dev/rdsk/c1t9d0s0';
Diskgroup created. |
Check the status of the diskgroups now
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| SQL> select a.group_number, b.name, a.path, a.state, a.mount_status
2 from v$asm_disk a,
3 v$asm_diskgroup b
4 where a.group_number = b.group_number(+);
GROUP_NUMBER NAME PATH STATE MOUNT_S
------------ ------------------------------ ------------------------------ -------- -------
1 ACFS_DG /dev/rdsk/c1t1d0s0 NORMAL CACHED
1 ACFS_DG /dev/rdsk/c1t2d0s0 NORMAL CACHED
1 ACFS_DG /dev/rdsk/c1t3d0s0 NORMAL CACHED
2 DATA_DG /dev/rdsk/c1t4d0s0 NORMAL CACHED
2 DATA_DG /dev/rdsk/c1t5d0s0 NORMAL CACHED
2 DATA_DG /dev/rdsk/c1t6d0s0 NORMAL CACHED
3 INDEX_DG /dev/rdsk/c1t8d0s0 NORMAL CACHED
4 FRA_DG /dev/rdsk/c1t9d0s0 NORMAL CACHED
8 rows selected.
SQL> |
Mount these diskgroups on NODE 2
1
2
3
4
5
6
7
8
9
10
11
12
13
| SQL> alter diskgroup DATA_DG mount;
Diskgroup altered.
SQL> alter diskgroup INDEX_DG mount;
Diskgroup altered.
SQL> alter diskgroup FRA_DG mount;
Diskgroup altered.
SQL> |
Install and configure Oracle RAC 11gR2 database
Once all the pre requisites are passed, and the disk groups are created, proceed with running the runinstaller from the database installation binaries. Extract both the zip files downloaded into a single folder. Follow these screenshots and complete the installation.
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
Run Installer
In case your DBCA fails due to memory constraint, you can ignore it depending on the stage you are at, or rerun dbca (by dropping and recreating)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| 1* select comp_name, version, status from dba_registry
SQL>
SQL> /
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
OWB 11.2.0.1.0 VALID
Oracle Application Express 3.2.1.00.10 VALID
Oracle Enterprise Manager 11.2.0.1.0 VALID
OLAP Catalog 11.2.0.1.0 VALID
Spatial 11.2.0.1.0 VALID
Oracle Multimedia 11.2.0.1.0 VALID
Oracle XML Database 11.2.0.1.0 VALID
Oracle Text 11.2.0.1.0 VALID
Oracle Expression Filter 11.2.0.1.0 VALID
Oracle Rules Manager 11.2.0.1.0 VALID
Oracle Workspace Manager 11.2.0.1.0 VALID
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
Oracle Database Catalog Views 11.2.0.1.0 VALID
Oracle Database Packages and Types 11.2.0.1.0 VALID
JServer JAVA Virtual Machine 11.2.0.1.0 VALID
Oracle XDK 11.2.0.1.0 VALID
Oracle Database Java Packages 11.2.0.1.0 VALID
OLAP Analytic Workspace 11.2.0.1.0 VALID
Oracle OLAP API 11.2.0.1.0 VALID
Oracle Real Application Clusters 11.2.0.1.0 VALID
19 rows selected. |
Run the root.sh script once your installation is completed on both nodes
Node 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| # cd /oracle/app/oracle/product/11.2.0/dbhome_1
# ./root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
# |
Node 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| # cd ./oracle/product/11.2.0/dbhome_1/
# ./root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
# |
Popularity: 79% [?]
[...] Part 1 – Oracle 11gR2 RAC Solaris 10 – Introduction By Ramesh Menon This entry is part 1 of 10 in the series 11gR2 RAC on x86 64bit Solaris 10 11gR2 RAC on x86 64bit Solaris 10 Part 1 – Oracle 11gR2 RAC Solaris 10 – IntroductionPart 2 – Oracle 11gR2 RAC Solaris 10 – Hardware SetupPart 3 – Oracle 11gR2 RAC Solaris 10 – VMWare InstallationPart 4 – Oracle 11gR2 RAC Solaris 10 – Virtual Machine Setup & ConfigurationPart 5 – Oracle 11gR2 RAC Solaris 10 – Install Solaris 10 OSPart 6 – Oracle 11gR2 RAC Solaris 10 – Configure OSPart 7 – Oracle 11gR2 RAC Solaris 10 – Clone and configure second nodePart 8 – Oracle 11gR2 RAC Solaris 10 – Prepare for CRS installationPart 9 – Oracle 11gR2 RAC Solaris 10 – CRS InstallationPart 10 – Oracle 11gR2 RAC Solaris 10 – Installation and configuration of RAC database [...]
Great information! I’ve been looking for something like this for a while now. Thanks!
I found this article very useful. But, i have questions about the way listeners are configured. I have installed grid infrastructure and installed the database. I am creating the database using dbca but has 012560 – TNS protocol adapter error. Shouldn’t a dbca know that this is a fresh install and configure Listeners and create a database? anyway, I ahve manually run netca to create listeners for the db apart from the default listener created by the grid installation. grid infrastrucutre has also created a scan listener. So,
my question is:
1. do we need 3 listeners: db listener, grid listener, scan listener?
2. if yes, i have all 3 listeners running but dbca would not create the database. why?
3. This is a 2 node cluster with
LISTENER – default grid listener
LISTENER_SCAN1, LISTENER_SCAN2 – scan listeners on 2 nodes
LISTENER_NODE, LISTENER_NODE – db listeners on 2 nodes with the same name. netca created them with the same name on 2 nodes. is this correct?
4. if you have sample tnsnames, sqlnet, listener for both db and grid, could you pleas share them. i would really appreciate it.
1) No. We do not need 3 listeners. One listener would do just fine for ASM and DB. However, since we separate Oracle and ASM Homes, it would be better if we used different listeners. (What if Oracle asks you to patch only Oracle Home? So we keep homes separate, in 11gR2 is separate by default) SCAN Listener is optional except for policy based dbs in 11gR2 (as per documentation)
2) What error did you get? I didn’t get any while creating the DB using DBCA. Do let me know.
3) If you are using the setup only for educational purposes, don’t bother configuring up scans.
4) Listener.ora from my test setup
Node 1
Listener.ora
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mydb)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = MYDB1)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.200) (PORT = 1521))
)
ADR_BASE_LISTENER = /crs/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
ADR_BASE_LISTENER_SCAN1 = /crs/app/oracle
Node 2 Listener
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
I get a TNS 02560 Protocol Adapter Error. Is the Listener.ora from the db home or grid home? which listener are you using? Are the contents of both listener.ora’s similar?
It is from GRID HOME. I am using this listener
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.200) (PORT = 1521))
)
I didn’t face any issue with listener at time of DBCA.
Regards
Ramesh
Good Work and Great Information
Keep It Up
Hoping for many good posts like this in the future