ORACLE RAC

How to create ACFS file system in RAC using command line:

ACFS i.e Oracle ASM Cluster File System is cluster file system service used for High availability services. Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS for goldengate relate files. In this article, we will show how to create a ACFS file system in oracle RAC using command line. […]

Create password files for database in ASM diskgroup

Below are the steps for creating password file for database in ASM diskgroup . This method is valid only for oracle 12c onwards. SYNTAX – ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path}  {sys_password} Example: Here we will create a password file with dbuniquename PRDPRE.

Check whether new pwdfile is created or not:

We can check […]

ASM_POWER_LIMIT in oracle ASM

ASM_POWER_LIMIT specifies the disk rebalancing speed of the ASM instance. The higher the limit, the faster rebalancing operation, but consume lot of CPU. Lower values will take longer, but consume fewer processing and I/O resources. Rebalancing happens when we add or drop a disk from a diskgroup. Import points: Background process ARBx performs the rebalance […]

OPATCHAUTO-72046: No wallet option provided

PROBLEM: I was applying proactive bundle patch on oracle 12c RAC database. And during execution of opatchauto apply command on rdbms binary, got below error. $ORACLE_HOME/OPatch/opatchauto apply /softdump/OCTBP2017/26635880 -oh /oracle/app/oracle/product/12.1.0.2/dbhome_1 OPatchauto session is initiated at Wed Nov 8 11:48:21 2017 OPATCHAUTO-72046: No wallet option provided. OPATCHAUTO-72046: Wallet option is not provided which is required during […]

oracleasm utility for ASMLIB

ASMlib driver is required on  Linux operating systems, to enable a disk readable by ASM. Without ASMLIB, disks can’t be used at asm disks. Below are the steps for configuring ASMlib and marking disks as ASM.   Download Asmlib: You can download these rpm packages directly from OTN: http://www.oracle.com/technetwork/server-storage/linux/downloads/index-088143.html Else, if your system is registered […]

ASMCA utility in oracle

ASMCA ( ASM Configuration Assistant) is a GUI utility provided by grid, to manage ASM instances and diskgroups like , create diskgroup, adding disk/diskgroup, dropping disk/diskgroup, mount/dismount diskgroup etc. Start asmca:

Creating diskgroup: Click on Create:   Mention the disk group name, redundancy and select the candidate disks that to be used for the […]

Adding new disk to ASM diskgroup

Adding a disk to an ASM diskgroup is really simple, just an alter command. But when if you are doing this in a production database, then before adding we have to make sure that the disk is healthy. We will follow below steps to confirm that the disk is healthy. 1.First, create the disk using […]

Multiplex redolog in Oracle RAC

This article explains the steps for multiplexing redologs in oracle RAC. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to that of multiplexing in standalone, Only change is RAC will have threads for node. i.e a 2 node RAC will have 2 threads. So while adding redolog group, […]

Useful CRSCTL commands

CRSCTL Utility is used to managed oracle clusterware resources and components. 1. STOP & START CRS: ( run from root user)

2. Enable/Disable auto restart of CRS.

3. Find the cluster name

4. Find grid version: SYNATX – $GRID_HOME/bin/crsctl query crs softwareversion <hostname)

5. check cluster component status

6. Find […]

Useful srvctl commands

SRVCTL is known as server control utility, which is used to add, remove,relocate and manage different crs services or components in RAC database. 1. STOP DATABASE : SYNTAX – srvctl stop database -d db_name [-o stop_options] where stop_options is normal/immediate(default)/transactional/abort e.g

2. START DATABASE SYNTAX – srvctl start database -d db_name [-o start_options] where start_option […]

Page 1 of 41234
Skip to toolbar