He has image of undying i.e. He has no effect of time
Index of all the posts of Gurpartap Singh's Blog
After you start all the machines clusterware will bring up everything as below.
Logon on to node 1 as oracle/oracle
. oraenv
crs
$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.DATA1.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE rac1
ora.gsd ora.gsd.type 0/5 0/ ONLINE ONLINE rac1
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac1
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac2
ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE rac1
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1
oracle : rac1.rac.meditate.com : @crs : /home/oracle
$
Now run ASMCA , X11 should have been fowarded through putty as we did earlier and Xming should be running.:
$ . oraenv
ORACLE_SID = [crs] ? +ASM1
The Oracle base for ORACLE_HOME=/u02/app/11.2.0.1/grid is /u01/app/oracle
oracle : rac1.rac.meditate.com : @+ASM1 : /home/oracle
$ asmca
It will open the following window. Right click on disk group "DISK1" and click add disks and select 3 disks and add them.
Then you will see teh following screen.
Then the following message. Click ok on this.
Now on the following screen click create to create the new diskgroup.
I namded it "RECV1" and click external and click show candidate and pick 2 disks here and click ok.
Then you will see the following screen.
and then at the following screen click ok.
Now on the following screen verify both the disk groups are mounted on both the nodes.
Then on the following screen click exit and then yes on next screen.
Now we are ready to install database software.
Now we are ready to install database software as:
cd /software
Now unzip the database software as:
unzip linux.x64_11gR2_database_1of2.zip
and then
unzip linux.x64_11gR2_database_2of2.zip
and after that we can remove the zipped files as:
rm linux.x64_11gR2_database_1of2.zip
and
rm linux.x64_11gR2_database_2of2.zip
oracle : rac1.rac.meditate.com : @+ASM1 : /software
$ cd database
oracle : rac1.rac.meditate.com : @+ASM1 : /software/database
$ ls -lart
total 44
-rwxr-xr-x 1 oracle oinstall 3226 Aug 15 2009 runInstaller
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 2009 rpm
drwxr-xr-x 4 oracle oinstall 4096 Aug 15 2009 install
drwxr-xr-x 14 oracle oinstall 4096 Aug 15 2009 stage
drwxrwxr-x 2 oracle oinstall 4096 Aug 15 2009 sshsetup
drwxrwxr-x 2 oracle oinstall 4096 Aug 15 2009 response
drwxr-xr-x 12 oracle oinstall 4096 Aug 16 2009 doc
-rw-r--r-- 1 oracle oinstall 5402 Aug 17 2009 welcome.html
drwxr-xr-x 8 oracle oinstall 4096 Aug 20 2009 .
drwxr-xr-x 3 oracle oinstall 4096 Jul 1 16:06 ..
Now Xming should be running and X11 should have been forwarded on putty.
oracle : rac1.rac.meditate.com : @+ASM1 : /software/database
$ ./runInstaller
and you will see the following screens.
Now we are ready to install database software as:
cd /software
Now unzip the database software as:
unzip linux.x64_11gR2_database_1of2.zip
and then
unzip linux.x64_11gR2_database_2of2.zip
and after that we can remove the zipped files as:
rm linux.x64_11gR2_database_1of2.zip
and
rm linux.x64_11gR2_database_2of2.zip
oracle : rac1.rac.meditate.com : @+ASM1 : /software
$ cd database
oracle : rac1.rac.meditate.com : @+ASM1 : /software/database
$ ls -lart
total 44
-rwxr-xr-x 1 oracle oinstall 3226 Aug 15 2009 runInstaller
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 2009 rpm
drwxr-xr-x 4 oracle oinstall 4096 Aug 15 2009 install
drwxr-xr-x 14 oracle oinstall 4096 Aug 15 2009 stage
drwxrwxr-x 2 oracle oinstall 4096 Aug 15 2009 sshsetup
drwxrwxr-x 2 oracle oinstall 4096 Aug 15 2009 response
drwxr-xr-x 12 oracle oinstall 4096 Aug 16 2009 doc
-rw-r--r-- 1 oracle oinstall 5402 Aug 17 2009 welcome.html
drwxr-xr-x 8 oracle oinstall 4096 Aug 20 2009 .
drwxr-xr-x 3 oracle oinstall 4096 Jul 1 16:06 ..
Now Xming should be running and X11 should have been forwarded on putty.
oracle : rac1.rac.meditate.com : @+ASM1 : /software/database
$ ./runInstaller
and you will see the following screens.
Uncheck "I wish to receive security updates via My oracle Support"
Click yes
Click install database software only.
Click Real application cluster database installation and make sure both nodes rac1 and rac1 are checked and clicked SSH connectivity and enter oracle password just to make sure silent SSH between nodes is Ok and then click "TEST".
On the following screen click OK.
Select english and click OK.
Click enterprise edition and then click next.
and click next.
Pick default i.e. dba and then click next.
Next it will do pre-checks
Here click next.
You will see the installation screens. Depending on your RAM and CPU the speed of install will vary. Have patience as it may take long time and you will see the following screens.
Now run the root.sh scritps as:
First run on node1 i.e. rac1 as following and accept defaults for all the questions as:
[root@rac1 ~]# /u01/app/oracle/product/11.2.0.1/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.1/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 /etc/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.
[root@rac1 ~]#
and then on node 2 as:
[root@rac2 ~]# /u01/app/oracle/product/11.2.0.1/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.1/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 /etc/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.
[root@rac2 ~]#
Then go back to root.sh screen and click ok and then on the following screen click close.
[root@rac1 ~]# /u01/app/oracle/product/11.2.0.1/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.1/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 /etc/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.
[root@rac1 ~]#
and then on node 2 as:
[root@rac2 ~]# /u01/app/oracle/product/11.2.0.1/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.1/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 /etc/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.
[root@rac2 ~]#
Then go back to root.sh screen and click ok and then on the following screen click close.
Now we are all set to create the database. Stop the machines and take the backup of all the machines and restart then with SAN machine being the first to be started and last to be switched off.
Remember:
On the journey where no one knows you, with the Name of the Lord, you shall be recognized.
Part 1 - Vmware Setup
Part 2 - Setup Base Brick Machine
Part 3 - SAN Setup
Part 4 - RAC VM Setup
Part 5 - Install Grid Infrastructure
Part 6 - Run asmca and Install RDBMS Software
Part 7 - Create RAC database with DBCA
Part 8 - Add node and instance to existing 11gR2 Cluster db
Part 9 - Delete node and inst from existing 11gR2 cluster db
hi Gurpartap Singh's tank you for all posts
ReplyDeletei have two problème in part 6
1. when i have lunch asmca i don't see the disks, thus i don't do this opération
2. when i run the runInstaller for install the rdbms software i have a error. the ssh vérification it's work success but when i click next i have "[INS-08109] Unexpected error occured while validating inputs at state 'nodeSelectionPage'"
tank's again and sorry for my english i am francophone
Thanks for visiting my blog,
ReplyDeleteCheck output of:
tgtadm --lld iscsi --op show --mode target
Does this matche as in post 3.
Also, does the output of following command in post 4 matches with ollowing:
Now discover the luns with the following command:
iscsiadm -m discovery -t sendtargets -p san.rac.meditate.com
and you should see:
10.10.1.175:3260,1 iqm.mgmt.volumes-san
You should also be able to see the devices using
"fdisk -l" and
ls -l /dev/sd*
Regards,
Gurpartap Singh
hello Gurpartap Singh tanks for reply quickly
ReplyDeleteI verified your recommendation but I think is not a cause of problem.
on the SAN machine command
"tgtadm --lld iscsi --op show --mode target"
display all my 4 LUNs
and on the RACs machines I see all the LUNs as sdb...sde
-------------
[root@san ~]# tgtadm --lld iscsi --op show --mode target
Target 1: iqm.mgmt.volumes-san
System information:
Driver: iscsi
State: ready
I_T nexus information:
I_T nexus: 1
Initiator: iqn.1994-05.com.redhat:182d71bf3a7e
Connection: 0
IP Address: 10.10.1.176
I_T nexus: 3
Initiator: iqn.1994-05.com.redhat:182d71bf3a7e
Connection: 0
IP Address: 10.10.1.177
I_T nexus: 4
Initiator: iqn.1994-05.com.redhat:182d71bf3a7e
Connection: 0
IP Address: 10.10.1.177
LUN information:
LUN: 0
Type: controller
SCSI ID: IET 00010000
SCSI SN: beaf10
Size: 0 MB, Block size: 1
Online: Yes
Removable media: No
Readonly: No
Backing store type: null
Backing store path: None
Backing store flags:
LUN: 1
Type: disk
SCSI ID: IET 00010001
SCSI SN: beaf11
Size: 2147 MB, Block size: 512
Online: Yes
Removable media: No
Readonly: No
Backing store type: rdwr
Backing store path: /disks/disk1.dat
Backing store flags:
LUN: 2
Type: disk
SCSI ID: IET 00010002
SCSI SN: beaf12
Size: 2147 MB, Block size: 512
Online: Yes
Removable media: No
Readonly: No
Backing store type: rdwr
Backing store path: /disks/disk2.dat
Backing store flags:
LUN: 3
Type: disk
SCSI ID: IET 00010003
SCSI SN: beaf13
Size: 2147 MB, Block size: 512
Online: Yes
Removable media: No
Readonly: No
Backing store type: rdwr
Backing store path: /disks/disk3.dat
Backing store flags:
LUN: 4
Type: disk
SCSI ID: IET 00010004
SCSI SN: beaf14
Size: 2147 MB, Block size: 512
Online: Yes
Removable media: No
Readonly: No
Backing store type: rdwr
Backing store path: /disks/disk4.dat
Backing store flags:
Account information:
ACL information:
ALL
[root@san ~]#
----------------------
[root@rac1 oracle]# ll /dev/sd*
brw-r----- 1 root disk 8, 0 Sep 28 15:28 /dev/sda
brw-r----- 1 root disk 8, 1 Sep 28 15:29 /dev/sda1
brw-r----- 1 root disk 8, 2 Sep 28 15:28 /dev/sda2
brw-r----- 1 oracle oinstall 8, 16 Sep 28 16:55 /dev/sdb
brw-r----- 1 oracle oinstall 8, 32 Sep 28 16:50 /dev/sdc
brw-r----- 1 oracle oinstall 8, 48 Sep 28 15:29 /dev/sdd
brw-r----- 1 oracle oinstall 8, 64 Sep 28 15:29 /dev/sde
[root@rac1 oracle]#
---------------------
I run cluster verification command
"cluvfy stage -post crsinst -n all -verbose" and I see that all verification passed except the SCAN resolution.
I have the following :
ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "scan.rac.meditate.com"
SCAN Name IP Address Status Comment
--------- ---------- --------- -------
scan.rac.meditate.com 10.10.2.166 failed NIS Entry
ERROR:
PRVF-4657 : Name resolution setup check for "scan.rac.meditate.com" (IP address: 10.10.2.166) failed
ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "scan.rac.meditate.com"
--------------------------
note: the contents of my /etc/hosts file is identical to your.
thank you again for your time
Hello Ilyas,
ReplyDeleteHow did the install go, have you recovered from this error? Hopefully you would have a running cluster by now :)
Sorry for very late reply.
Regards,
Gurpartap Singh
hi yes I could finish and it works. I thank you enormously.
ReplyDeleteI have the same error as Ilyas, can you please explain the resoloution? Many thanks!
ReplyDelete