There could be a requirement from client to have custom device names such as /dev/asmdisk01 for an actual device with name /dev/sdb. Follow the steps outlined in this post to set custom device names using udev. In order to create customer name (/dev/asmdisk01p1) for /dev/sdb set udev rules as below: 1. Find UUID of device First, find the the UUID of the device with the scsi_id command as shown below. # /usr/lib/udev/scsi_id -g -u /dev/sdb 1IET_00020002 Save this UUID, as this ID … [Read more...] about How to set custom device names using udev in CentOS/RHEL 7
ASM
How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6
This note explains how to set udev rule for setting the disk permission on ASM disks in multipath on CentOS/RHEL 6.x. Follow the below steps if you are using multipath and want to set udev rule on multipath device. 1. Determine partitioned alias for target device # dmsetup ls |grep p1 datap1 (253, 4) ### you would see something similar to this 2. Edit /etc/udev/rules.d/12-dm-permissions.rules file to set the above device ownership as oracle:dba. # vi … [Read more...] about How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6
Oracle Database : How to set Environment Variables Using Srvctl
The srvctl utility can be used to set environment variables for a resource, with the "srvctl setenv" command. These environment variables are then used at resource startup. When setting an environment variable for the database with "srvctl setenv database", it affects all the instances that belong to that database. To give a concrete example, if you run this command: $ srvctl setenv database -d mydb -T "TNS_ADMIN=/oracle/102/asm/network/admin" Then, this setting of TNS_ADMIN will be used … [Read more...] about Oracle Database : How to set Environment Variables Using Srvctl
How to move or rename a datafile in the same ASM diskgroup (Using ASM alias)
ASM files can be renamed like any other files in a standard filesystem. For ASM, rename is performed through some type of statements (ADD ALIAS, RENAME ALIAS, ADD DIRECTORY) to manipulate filenames, alias, and directories. Renaming datafiles is sometimes needed when database file names still contain old database name after a database on ASM is renamed (for example with nid). Then, it is required to change ASM datafile names accordingly with the new database name. RMAN backup copy doesn't … [Read more...] about How to move or rename a datafile in the same ASM diskgroup (Using ASM alias)
How to configure Partitioned Block Devices (Non-ASMLIB) And Assign Them To ASM
The post provides an example of how to configure partitioned Linux block devices using udev (non-ASMLIB) and assign them to ASM as candidate member disks. 1. This example was performed on an CentOS 6.6 configuration (ASM release 11.2.0.4 - 64-bit): $ uname -a Linux geeklab 2.6.32-504.el6.x86_64 #1 SMP Tue Sep 16 01:56:35 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux $ cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) 2. Identify the new disk in your Linux … [Read more...] about How to configure Partitioned Block Devices (Non-ASMLIB) And Assign Them To ASM
How To Create Device Alias For ASM Disks Using mknod On Linux/Unix
The post provides an example of how to define and associated meaningful device names for Candidate or Member ASM Disks on Linux/Unix using mknod. The example shown below is of a 2 node RAC setup with +ASM1 and +ASM2 instances. 1. We have below mounted on both +ASM1 & +ASM2 instances: GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 CRSDG MOUNTED EXTERN 20480 20052 2 DATADG1 MOUNTED EXTERN 102400 77005 3 DATADG2 MOUNTED EXTERN … [Read more...] about How To Create Device Alias For ASM Disks Using mknod On Linux/Unix
How To Resize An ACFS Filesystem/ASM Volume (ADVM)
The post provides an example of how to resize an ACFS Filesystem/ASM Volume (ADVM) through the command line. 1. Create the ACFSDG (8GB) diskgroup from ASM instance: SQL> CREATE DISKGROUP ACFSDG EXTERNAL REDUNDANCY DISK 'ORCL:ASMDISK8' SIZE 4157 M DISK 'ORCL:ASMDISK9' SIZE 4157M ATTRIBUTE 'compatible.asm' = '11.2', 'compatible.advm' = '11.2'; Diskgroup created. SQL> Select name, state, total_mb, free_mb from v$asm_diskgroup where name like 'ACFSDG'; NAME … [Read more...] about How To Resize An ACFS Filesystem/ASM Volume (ADVM)
How to move spfile from ASM to filesystem
The post example shows how to delete the SPFILE in the +ASM DISKGROUP and relocate it to the $ORACLE_HOME/dbs directory. This process needs an instance restart and thus an outage. 1. Create pfile from the spfile First, we will create pfile in filesystem from the existing spfile in ASM. $ . oraenv a ORACLE_SID = [testdb] ? testdb SQL> create pfile=’$ORACLE_HOME/dbs/initINFPRD.ora’ from spfile='+DG_ARCH/TESTDB/spfileINFPRD.ora'; 2. Remove the spfile from ASM We can now connect the … [Read more...] about How to move spfile from ASM to filesystem
How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup
The goal here is to move OCR, voting disk file and ASM spfile in a Grid Infrastructure with RAC cluster to a new ASM disk group. One example would be that you have created these components in the +DATA diskgroup and you wish to move the OCR, Vote File and ASM spfile to a NORMAL or HIGH redundant diskgroup. Basic steps to move to the new diskgroup are outlined below: Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files. Ensure that the new diskgroup is mounted on all … [Read more...] about How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup
How to Migrate ASM Disk Groups to another Storage Online [non ASMLIB Devices]
The post explains in detail the exact steps to migrate ASM diskgroups from one storage to another storage without a downtime. This procedure will also work for diskgroups hosting OCR and Votefiles and ASM spfile. Note: These steps are applicable to External, Normal & High redundancy diskgroups. If your plans are replacing the current disks associated to your diskgroups with a new storage, this operation can be accomplished without any downtime, so you can follow the next steps Add the … [Read more...] about How to Migrate ASM Disk Groups to another Storage Online [non ASMLIB Devices]