iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

September 22, 2017, 08:57:41 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: ASM 2 Linux  (Read 13 times)
Johni
Administrator
Newbie
*****
Posts: 1


« on: September 12, 2017, 03:31:14 PM »

As root
------------
Error on scaning your security enhancement is enable
# sestatus
# vi /etc/sysconfig/selinux
# SELINUX=enforcing
SELINUX=disabled
 
Reboot to change sysconfig
# init 6

==========
# fdisk -l | grep emcpower
# ll /dev/emcpower*
# fdisk /dev/emcpowera b c d e f

# oracleasm createdisk asmdisk0a /dev/emcpowera1        using multiple scsi
# oracleasm deletedisk asmdisk0a

# ll /dev/oracleasm/disks
# oracleasm listdisks
# oracleasm scandisks

--- grid
SQL> DROP DISKGROUP audit_dg;
SQL> oracleasm deletedisk ASMDISK0B
SQL> SELECT name, path, header_status FROM V$ASM_DISK
SQL> CREATE DISKGROUP audit_dg EXTERNAL REDUNDANCY DISK 'ORCL:ASMDISK0B';
SQL> ALTER DISKGROUP audit_dg ADD DISK 'ORCL:ASMDISK0C';

SQL> ALTER DISKGROUP audit_dg DROP DISK 'ORCL:ASMDISK0C';

SQL> ALTER DISKGROUP systemdata ADD DISK 'ORCL:ASMDISK0A';
SQL> ALTER DISKGROUP recovery ADD DISK 'ORCL:ASMDISK0B', 'ORCL:ASMDISK0C';
SQL> ALTER DISKGROUP eventdata ADD DISK 'ORCL:ASMDISK0D', 'ORCL:ASMDISK0E', 'ORCL:ASMDISK0F';


SQL> ... v$asm_disk   diskgroup
SQL> ALTER DISKGROUP asmdiskb01 ADD  DISK '/devices/sdb01';

SQL> CREATE DISKGROUP dgroup_01 EXTERNAL REDUNDANCY DISK '$ORACLE_HOME/disks/c*';

As root
------------------
# oracleasm scandisks -s
# oracleasm liskdisks

# ll /dev/oracleasm/disks
# ll /dev/oracleasm
# ll /dev
# ll /devices
# ll /dev/mapper/      -- after fdisk
# ll 
+ASM1> crsctl stat res ora.TEST.dg -t       -- as grid

CREATING ORACLEASM DISKS
# oracleasm createdisk DG_TEST /dev/mapper/raw_vote_03

VERIFYING ASK DISK LABEL BY PROVIDING DISK
[root@bhuora01 ~]# oracleasm querydisk /dev/mapper/raw_vote_03

VERIFYING DISK USING listdiks
[root@bhuora01 ~]# oracleasm listdisks
[root@bhuora01 ~]# ls -alrt /dev/oracleasm/disks/DG*

Make ASM disks available to other nodes in the cluster by running the scandisk command. This needs to be run on all other nodes.
[root@bhuora02 ~]# oracleasm scandisks

CREATING THE DISK GROUP IN COMMAND PROMPT
oracle +ASM1 bhuora02> sqlplus / as sysasm
SQL> CREATE DISKGROUP TEST EXTERNAL REDUNDANCY
DISK '/dev/oracleasm/disks/DG_TEST', '/dev/oracleasm/disks/DG_TEST1',
'/dev/oracleasm/disks/DG_TEST2'
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '11.2.0.2.0',
'compatible.rdbms' = '11.2.0.2.0',
'compatible.advm' = '11.2.0.2.0';
Diskgroup created.

SQL> select * from v$asm_diskgroup where name='TEST';

ON NODE#2 if you run the same queries on the second node, it shows there is no disk group with the name. When I check further on the issue, I found that we need to manual mount in all the cluster nodes.
SQL> select * from v$asm_diskgroup where name='TEST';
SQL> alter diskgroup test dismount;

THEN MOUNT THE DISK GROUP
SQL> alter diskgroup test mount;
SQL> select * from v$asm_diskgroup where name='TEST';

I have the DISK GROUP is automatically added in the cluster registry.
oracle +ASM1 bhuora02> crsctl stat res ora.TEST.dg -t
Logged
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!