Oracle ASM on Solaris 11.3 Post: 303015834

Sponsored Content

Operating Systems Solaris Oracle ASM on Solaris 11.3 Post 303015834 by gull04 on Friday 13th of April 2018 09:58:33 AM

04-13-2018

Registered User

Hi Guys,

Thanks very much for the feed back on this thread, the final decision was to go with the ASM raw devices - however there were a couple of things that I discovered that might be worth sharing.

The first point worth noting is that when you create the ASM disks in format, make sure that cylinder zero is not available in the slice as ASM can over write the label - which the OS seems to protest about. So the disks were formatted as follows;

Code:

partition> pr
Current partition table (original):
Total disk cylinders available: 2558 + 2 (reserved cylinders)

Part      Tag    Flag     Cylinders        Size            Blocks
  0 unassigned    wm       1 - 2557        4.99GB    (2557/0/0) 10473472
  1 unassigned    wm       0               0         (0/0/0)           0
  2     backup    wm       0 - 2557        5.00GB    (2558/0/0) 10477568
  3 unassigned    wm       0               0         (0/0/0)           0
  4 unassigned    wm       0               0         (0/0/0)           0
  5 unassigned    wm       0               0         (0/0/0)           0
  6 unassigned    wm       0               0         (0/0/0)           0
  7 unassigned    wm       0               0         (0/0/0)           0

partition>

A second point worth noting is that the disk should be commented in format to ensure that somebody doesn't grab it and re-format it.

Thirdly, it's worth giving the disks meaningful names when setting up the services as follows;

Code:

root@fvssphsun01:/export/home/e415243# ldm list-services
VCC
    NAME             LDOM             PORT-RANGE
    primary-vcc0     primary          5000-5100

VSW
    NAME             LDOM             MAC               NET-DEV   ID   DEVICE     LINKPROP   DEFAULT-VLAN-ID PVID VID                  MTU   MODE   INTER-VNET-LINK
    primary-vsw0     primary          00:14:4f:fa:b3:18 aggr0     0    switch@0              1               1                         1500         on
    primary-vsw1     primary          00:14:4f:f9:66:7a aggr1     1    switch@1              1               1                         1500         on

VDS
    NAME             LDOM             VOLUME         OPTIONS          MPGROUP        DEVICE
    primary-vds0     primary          nhh_ba_vol1                                    /dev/rdsk/c0t600507680C808278000000000000048Fd0s0
                                      nhh_ba_vol2                                    /dev/rdsk/c0t600507680C8082780000000000000491d0s0
                                      nhh_db_vol1                                    /dev/rdsk/c0t600507680C808278000000000000048Ed0s0
                                      nhh_db_vol2                                    /dev/rdsk/c0t600507680C8082780000000000000490d0s0
                                      nhh_asm_01                                     /dev/rdsk/c0t600507680C8082780000000000000492d0s0
                                      nhh_asm_02                                     /dev/rdsk/c0t600507680C8082780000000000000493d0s0
                                      nhh_asm_03                                     /dev/rdsk/c0t600507680C8082780000000000000494d0s0
                                      nhh_asm_04                                     /dev/rdsk/c0t600507680C8082780000000000000495d0s0
                                      nhh_asm_05                                     /dev/rdsk/c0t600507680C8082780000000000000496d0s0
                                      nhh_asm_06                                     /dev/rdsk/c0t600507680C8082780000000000000497d0s0
                                      nhh_asm_07                                     /dev/rdsk/c0t600507680C8082780000000000000498d0s0
                                      nhh_asm_08                                     /dev/rdsk/c0t600507680C8082780000000000000499d0s0
                                      nhh_asm_09                                     /dev/rdsk/c0t600507680C808278000000000000049Ad0s0
                                      nhh_asm_10                                     /dev/rdsk/c0t600507680C808278000000000000049Bd0s0

root@fvssphsun01:/export/home/e415243# ldm ls
NAME             STATE      FLAGS   CONS    VCPU  MEMORY   UTIL  NORM  UPTIME
primary          active     -n-cv-  UART    16    32G      0.1%  0.1%  3d 43m
fbasphnhhp01     active     -n----  5001    16    32G      0.0%  0.0%  1d 7h 30m
fdbsphnhhp01     active     -n----  5000    48    96G      0.1%  0.0%  1d 7h 22m
root@fvssphsun01:/export/home/e415243#

Other things that I noticed were that OVM 3.5 is a long way from LDOMS for Solaris 1.0.1.

I eventually managed to get the local repo set up, not without incident and have the local LDOM's pointing at it.

Regards

Gull04

gull04

View Public Profile for gull04

Visit gull04's homepage!

Find all posts by gull04

9 More Discussions You Might Find Interesting

1. Solaris

asm vs disksuite for oracle

I'm running solaris, with solstice disksuite. With other systems, i run veritas volume manager. My dba want to implement ASM with oracle 10g. Is it possible to create volumes with disksuite for ASM. Oracle want a volume name ex: vol1 My question is, what is the best STANDARD solution. ...

2. Red Hat

ORACLE RAC ASM disk question

Perhaps someone here has some experience with this. machine os RHE 4 6 oracle 10g RAC disk is SAN attached clariion. I have presented new disks to the host, so the machine sees all needed LUNS. powermt shows them, they are labeled and i have fdisk'd them. They are visible across all RAC...

3. Solaris

Command to format Oracle ASM raw disk

Hi, Can any one please provide the command to format an Oracle Raw Disk in Solaris 10. I have been used the following commands: dd if=/dev/zero of=<raw disk path> Thanks ---------- Post updated at 12:20 PM ---------- Previous update was at 10:11 AM ---------- Well this didn't give...

4. AIX

Oracle ASM accidentally messed with my hdisk

I have AIX 5.3 with oracle 10g ( test server). While trying to create RAW disk for Oracle ASM I have accidentally messed with rootvg (hdisk0 & hdisk1) When I do # lspv hdisk0 0516-066 : Physical volume is not a volume group member. Check the physical volume name specified. ...

5. Programming

Help on a perl script to connect to oracle ASM as sysdba

I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database. This is because, a cluster has more than 4 databases running and a check on...

6. Shell Programming and Scripting

Use perl to connect to Oracle ASM as sysdba

7. Solaris

Can we add Oracle ASM in sun cluster3.3 or 4.0 in failover mode

Hi I am new to this forum & oracle DBA also, I would like to know that can we add Oracle ASM in failover mode in sun cluster 3.3 or 4.0 means that if suppose oracle is running along with ASM on node1 & this node went down due to hardware issue then both oracle along with ASM must move to...

8. UNIX for Advanced & Expert Users

Script to automate add/resize datafile in Oracle ASM Storage

Hi all, Could anyone please share ideas or logic on how to automate add/resize datafile in Oracle ASM Storage for Oracle RAC/Single Node databases when any tablespace space alert is trigerred by OEM? Thanks for your help and time on it! Thanks&regards, a1_win Please DON'T use CODE tags...

9. Solaris

Missing ASM Disks in Solaris 11.3 LDOM

Hi Guys, Just a quick question hopefully someone will have seen this before and will be able to enlighten me. I have been doing some Infrastructure Verification Testing and one of the tests was booting the primary domain from alternate disks, this all went well - however on restarting one of...