• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

ASM

CRSCTL Command Examples in ASM Standalone Configurations

by admin

The CRSCTL command utility is an essential tool to master in the DBA toolbox for Clusterware maintenance and administration. It provides Clusterware monitoring functions as well as the ability to add and remove key components of the Oracle Clusterware such as adding or removing vote disks and management of Clusterware processes and resources. With the […]

Filed Under: ASM, oracle, RAC

Add Disk to ASM Disk Group using asmca

by admin

ASM Configuration Assistant is a GUI tool, introduced in Oracle 11g, that can be used to install and configure an ASM instance, disk groups, volumes, and ACFS. Like the DBCA, ASMCA can also be used in silent mode. Oracle Universal Installer internally uses ASMCA in silent mode to configure ASM disk groups to store OCR […]

Filed Under: ASM, oracle

oracleasm Command Examples (Cheat Sheet)

by admin

After the storage administrator provides you with the disk for the database and presents the disk to the server, you want to stamp the disks as ASMLIB disks using the oracleasm command. All options to the oracleasm script that are not read-only actions require root privileges to execute. Such options include commands to configure, create, […]

Filed Under: ASM, oracle

ASM disk addition/deletion hung with no rebalancing

by admin

The Problem 1. Several disks have been added to an existing diskgroup in RAC environment and sqlplus session initiating adding operation does not return the control which have to be disconnected manually. 2. Rebalance is not occuring from v$asm_operation: SQL> select * from gv$asm_operation; no rows selected 3. “disk validation pending” message in other nodes […]

Filed Under: ASM, oracle, RAC

Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication

by admin

This method takes advantage of a new feature of RMAN in 12c allowing you to clone database files and apply incrementals to those files from an active database without requiring staging areas. In addition, the source PDB application activity can continue while the cloning and incremental applies are being performed. To get the datafiles in […]

Filed Under: ASM, Data Guard, oracle, oracle 12c

Oracle RAC: How to Change private network interface name, subnet or netmask

by admin

It may be necessary to change or update interface names, or subnet associated with an interface if there is a network change affecting the servers, or if the original information that was input during the installation was incorrect. It may also be the case that for some reason, the Oracle Interface Configuration Assistant (‘oifcfg’) did […]

Filed Under: ASM, oracle, oracle 12c, RAC

How To Create “A CRS Managed” ACFS FileSystem On Oracle RAC Cluster (ASM/ACFS 11.2)

by admin

1. Create the mount points on all the nodes (as root user): # mkdir /goldengate 2. Connect to the ASM instance & create the ACFS diskgroup (from the +ASM1 instance): SQL> CREATE DISKGROUP ACFSTEST EXTERNAL REDUNDANCY DISK ‘ORCL:ASMDISK18’ SIZE 4157 M DISK ‘ORCL:ASMDISK19’ SIZE 4157 M ATTRIBUTE ‘compatible.asm’ = ‘11.2’, ‘compatible.advm’ = ‘11.2’; Diskgroup created. […]

Filed Under: ASM, oracle, RAC

How to Use Udev Rules to Create oracleasm Disks in CentOS/RHEL 8

by admin

This post will help to configure Oracleasm disks using Udev rules in 2 node cluster. On first node 1. List the disks: [root@node01 ~]# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 2G 0 disk sdb 8:16 0 2G 0 disk Note: Create partitions for the disks. 2. Find the disk ID: […]

Filed Under: ASM, CentOS/RHEL, CentOS/RHEL 8, Linux, oracle

How to Disable os-prober in CentOS/RHEL 7

by admin

What is os-prober The os-prober package detects all operating systems available on the machine and returns the results in a generic machine-readable format. Sometimes os-prober may cause problems when probing some special disks (Ex: Oracle ASM disks). This post describes how to disable os-prober. Disabling os-prober os-prober is invoked by the command grub2-mkconfig when generating […]

Filed Under: ASM, CentOS/RHEL, CentOS/RHEL 7, oracle

How to check and repair ACFS with FSCK

by admin

The Problem You noticed many inconsistencies in different asm metadata views, asmcmd and os outputs that are associated with the ACFS file system. Database shows corruption in RMAN or from dbverify. Database uses ACFS. ALTER DISKGROUP CHECK REPAIR comes back clean but you still see errors or check for corruption returns back positive, eg: $ […]

Filed Under: ASM, oracle

Next Page »

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright