asm imp

Please download to get full document.

View again

of 3
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 2 | Pages: 3

Extension: PDF | Download: 0

Share
Related documents
Description
asm
Tags
Transcript
  http://www.sqlpanda.com/2013/01/install-oracle-11gr2-on-oracle-linux-63.htmlhttp://emarcel.com/installing-oracle-database-11g-r2-on-linux-with-asm/http://askdba.org/weblog/2009/09/11gr2-database-installation-with-asm-on-oel5/http://www.zhongweicheng.com/?p=1554http://spotdba.blogspot.in/2012/06/creating-asm-instance-in-oracle-11gr2.htmlhttp://wadhahdaouehi.tn/2015/04/creation-of-asm-disks-on-oracle-linux-using-asmlib/http://wadhahdaouehi.tn/2015/04/creation-of-asm-disks-on-oracle-linux-using-asmlib/http://d-h-n.de/blog/install-oracle-grid-infrastructure-11-2-0-3-0-for-standalone-server-on-oracle-linux-6-2/var/log/oracleasmASMLib Troubleshootingrpm -qa |grep asmdf -ha |grep asmYou want to ensure that the oracleasm has been loaded by the kernel:# /sbin/lsmod |grep oracleasmhttp://askdba.org/weblog/2009/09/11gr2-database-installation-with-asm-on-oel5/http://www.zhongweicheng.com/?cat=65On the /dev/oracleasm/disks directory are located the ASMLib mappings of ASM devices to physical devices[root@vasm ~]# ls -l /dev/oracleasm/disks total 0 brw-rw  - 1 oracle oinstall 8, 17 Feb 20 15:58 VOL1 brw-rw  - 1 oracle oinstall 8, 33 Feb 20 15:58 VOL2 brw-rw  - 1 oracle oinstall 8, 49 Feb 20 15:58 VOL3 brw-rw  - 1 oracle oinstall 8, 65 Feb 20 15:58 VOL4 # /etc/init.d/oracleasm querydisk VOL1Disk VOL1 is a valid ASM disk on device [8, 17]You can find out which devices this represents with the following:# grep 8 17 /proc/partitions8 17 60817392 sdb1Still paranoid that this might not be your device, check the contents of the disk header:# od -c /dev/sdb1 |head -10The major and minor numbers permit to map the ASM Disks to the physical devices[root@vasm ~]# ls -l /dev/* | grep 8, | grep 17 brw-r   1 root disk 8, 17 Feb 20 15:58 /dev/sdb1 [root@vasm ~]# ls -l /dev/* | grep 8, | grep 33 brw-r   1 root disk 8, 33 Feb 20 15:58 /dev/sdc1 [root@vasm ~]# ls -l /dev/* | grep 8, | grep 49 brw-r   1 root disk 8, 49 Feb 20 15:58 /dev/sdd1  [root@vasm ~]# ls -l /dev/* | grep 8, | grep 65 brw-r   1 root disk 8, 65 Feb 20 15:58 /dev/sde1 Users,Roles and Groups for Installationosdba group for ASM - Membership in the OSDBA group allows access to the files managed by Automatic Storage Management. It can be same as database osdba group. We will be using group dba in our setup.OSASM group - Members of the OSASM group can use SQL to connect to an Automatic Storage Management instance as SYSASM using operating system authentication. The SYSASM privileges permit mounting and dismounting disk groups, and other storage administration tasks. SYSASM privileges provide no access privileges on an RDBMS instance. We will use asmadminOSOPER group - Similar to SYSOPER privilege in RDBMS, this is used for limited privileges like starting up and stopping the Oracle ASM instance. We will not be using separate group for it, will be selecting dba in our setupoinstall - This is similar to previous releases, and used for Oracle Inventory grouphttp://www.sqlpanda.com/2013/01/install-oracle-11gr2-on-oracle-linux-63.htmlhttp://www.sqlpanda.com/2013/01/asm.htmlhttp://www.sqlpanda.com/2013/01/oracle-automated-storage-management-asm.htmlhttp://emarcel.com/installing-oracle-database-11g-r2-on-linux-with-asm/https://nadeemmohammed.wordpress.com/2012/09/24/oracle-11-2-standalone-database-creation-using-asm-manually/https://saruamit4.wordpress.com/category/asm/http://wadhahdaouehi.tn/2015/04/creation-of-asm-disks-on-oracle-linux-using-asmlib/http://spotdba.blogspot.in/2012/06/creating-asm-instance-in-oracle-11gr2.htmlhttp://www.dbms-notes.com/2010/10/oracle-asm-on-11g-r2-installing-grid.htmlhttp://bulldba.com/automatic-storage-management-asm-in-oracle-database-10g/http://www.sqlpanda.com/2013/01/asmcmd.htmlhttp://www.sqlpanda.com/2013/01/asm-operations.htmlhttp://www.sqlpanda.com/2013/01/dns-server.htmlhttp://www.sqlpanda.com/2013/01/oracle-rac-management-1-srvctl-and.htmlhttp://www.sqlpanda.com/2013/01/oracle-rac-management-3-ocrcheck-and.htmlhttp://www.sqlpanda.com/2014/09/setup-database-alerts.htmlhttp://emarcel.com/installing-oracle-database-11g-r2-on-linux/http://emarcel.com/installing-oracle-database-11g-r2-on-linux-with-asm/http://www.sqlpanda.com/2012/12/oracle-linux-62-installation-on-virtual.htmlhttp://askdba.org/weblog/2009/09/11gr2-database-installation-with-asm-on-oel5/After having set the asm_diskstring parameter we can see the disks matching the pattern /dev/raw/raw*SQL> select disk_number,mount_status,header_status,mode_status,state,path from v$asm_disk ; Discovering Block DevicesWe also defined block devices like /dev/sdb1, /dev/sdc1 etc. We will add this definition also to the diskstring.We can see the the devices used to create disks with ASMLib appear as PROVISION  ED SQL> SELECT a.ksppinm parameter , b.ksppstvl session value , c.ksppstvl instance value FROM x$ksppi a, x$ksppcv b, x$ksppsv c WHERE a.indx = b.indx AND a.indx = c.indx AND a.ksppinm LIKE '/_%' escape '/' 8 AND a.ksppinm LIKE '%_asm_allow_only_raw_disks%';
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks