Friday, July 2, 2010

Install Oracle RAC 11gR2 on Vmware with Windows 7 64-bit as host OS and Linux as guest OS (Part 6, Run asmca and Install RDBMS software)

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.



And then on the following screen.
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.



Here change oracle home to:
/u01/app/oracle/product/11.2.0.1/dbhome_1
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.




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.

6 comments:

  1. hi Gurpartap Singh's tank you for all posts
    i 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

    ReplyDelete
  2. Thanks for visiting my blog,

    Check 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

    ReplyDelete
  3. hello Gurpartap Singh tanks for reply quickly
    I 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

    ReplyDelete
  4. Hello Ilyas,

    How 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

    ReplyDelete
  5. hi yes I could finish and it works. I thank you enormously.

    ReplyDelete
  6. I have the same error as Ilyas, can you please explain the resoloution? Many thanks!

    ReplyDelete