Oracle ASM on Solaris 11.3 Post: 303015761

Sponsored Content

Operating Systems Solaris Oracle ASM on Solaris 11.3 Post 303015761 by Peasant on Thursday 12th of April 2018 12:11:56 AM

04-12-2018

Moderator

1.You can accomplish with zpool using ZVOLs
Would not recommend nor advise, unless used in lab.
Performance hit would be noticable.

2. Oracle database on ZFS filesystem (no ASM) will require a lot of tuning to even touch ASM performance.
Expect performance drop on multiTB databases, especially after fragmentation starts regardless of the above statement.
It can be close to ASM, with a lot more effort and zpool separation per oracle database component (redo, archive,data)

3. Use symlinks to link /dev/rdsk/cxtxdxs6 (or the slice selected ofc) to human device name to use in ASM.
Choosing a right naming policy will be of great help here.

Also, use one slice (say s6) for all ASM disk, don't mix, since this will make it harder to administer in case of problems or as management says these days challenges.

I see no need to use metadevices, since ASM is actually an oracle database volume manager supporting mirroring, striping by default etc.

There are some corner cases in which SVM can be useful.
Like, if you require a volume to be raid 5 or raid 6 protected and used by ASM, this can only be done using metadevices (AFAIK, ASM only support mirrors - two way, three way).
But i have never meet this need in practice, since i mostly use storage side luns which are added as is in ASM (partitioned and symlinked, without ASM protection)

Hope that helps
Regards
Peasant.

Peasant

View Public Profile for Peasant

Find all posts by Peasant

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

LEARN ABOUT OPENDARWIN

suninstall

suninstall(1M)						  System Administration Commands					    suninstall(1M)

NAME

       suninstall - install the Solaris operating system

SYNOPSIS

       suninstall

DESCRIPTION

       install-solaris(1M) is now the preferred command for starting and restarting the Solaris Installation program. It should be used instead of
       suninstall. suninstall is symbolically linked to install-solaris.

       suninstall is a forms-based and graphical subsystem for installing the operating system.

       suninstall exists only on the Solaris installation media (CD or DVD) and should only be invoked from there. Refer to the Solaris 10 Instal-
       lation Guide: Basic Installations for more details.

       suninstall allows installation of the operating system onto any standalone system. suninstall loads the software available on the installa-
       tion media. Refer to the Solaris 10 Installation Guide: Basic Installations for disk space requirements.

USAGE

       Refer to the Solaris 10 Installation Guide: Basic Installations for more information on the various menus and selections.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcdrom (Solaris  instal-  |
       |			     |lation media)		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       pkginfo(1), install(1M), install-solaris(1M), pkgadd(1M), attributes(5)

       Solaris 10 Installation Guide: Basic Installations

NOTES

       It is advisable to exit suninstall by means of the exit options in the suninstall menus.

SunOS 5.10							    9 Sep 2004							    suninstall(1M)