To provide best solutions to business issues in any organization has to set up its infrastructure. In the world of technology, business focus on it’s better setup of IT departments. Day by day new technology introduces by the champions of IT. New requirements of clients demand new technology as soon as possible. For providing better services organizations […]
Category: ORACLE RAC
Background Processes in Oracle ASM
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas the RDBMS instance processes begin with ora. On Unix, the ASM processes can be listed using the following command: ps […]
Background Processes in Oracle RAC
Oracle RAC Background Processes Image Source The GCS and GES processes, and the GRD collaborate to enable Cache Fusion. The Oracle RAC processes and their identifiers are as follows: 1. ACMS: Atomic Controlfile to Memory Service (ACMS) In an Oracle RAC environment, the ACMS per-instance process is an agent that contributes to ensuring a distributed […]
RAC : 11gR2 Clusterware Startup Sequence
Here is the brief explanation that how the clusterware brings up step by step . 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. […]
Back Up & Restore an Oracle ASM Password File with pwget Command
In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]
Use spget and spmove command in Oracle ASM
Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]
Rename Empty Diskgroup on ASM 11gR2
The goal here is to rename the DATA diskgroup to DG_PROD_DATA – here is the situation before the rename operation : # asmcmd lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 32756 31828 244 15792 0 N DATA_OCR/ MOUNTED EXTERN N 512 4096 1048576 16378 […]
Quorum failure group in Oracle ASM
Voting files manage information about node membership. OCR is a system that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. A quorum failure group is a special type of failure group and disks in these failure groups do not contain user data. A quorum failure group is not considered when determining […]
Upgrade Oracle Grid and Database (11.2.0.1 to 11.2.0.4)
This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4). [oracle@india2 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n india1,india2 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/11.2.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/logs -verbose |tee /home/oracle/logs/runcluvfy1210.out [oracle@india2 logs]$ more runcluvfy.out |grep -i ‘failed’ india2 missing 9413827 or 9706490 failed india1 missing 9413827 or 9706490 failed Result: Check for Oracle patch […]
Converting Standard to Flex Cluster
Introduction Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is […]