1. By using SqlPlus $ sqlplus / as sysasm SQL> show parameter spfile NAME TYPE VALUE —— —— ————————————————- spfile string +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169 SQL> 2. By using ASMCMD find command $ asmcmd find –type ASMPARAMETERFILE +DATA “*” +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 3. By using spget command ASMCMD> spget +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 […]
Articles Tagged: ORACLE RAC
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 […]
Steps to change SCAN IP address in RAC
To Change the SCAN IP address it must be available and need to changes on the DNS by the network admin. So we have SCAN IP address available. Steps: 1. To check the current status SCN IP address on DNS $nslookup <scan-name> $nslookup testrac-scan.abc.com Server: 160.34.11.20 Address: 160.34.11.21#40 Name: testrac-scan.abc.com Address: 160.34.11.88 Name: testrac-scan.abc.com Address: […]
Change Listener ports RAC with MGMTDB
In this post, you will know how to change the Listener Port In Oracle RAC. We can change some listener ports from 1521 to 1525 on a RAC. 1. Check the listener status [oracle@node1 ~]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): node1,node2 2. Modify the listener […]
Master Node in Oracle RAC
In this post, I will demonstrate three methods to identify the oracle clusterware’s master node. Please note that clusterware master is different from Resource master in oracle database instance. To know about how to find the resource master, Oracle ClusterWare Master’s Node information can be found By scanning ocssd logs from various nodes By scanning crsd […]
Delete a node from RAC
To remove a node from a which is part of a RAC involves several steps Stop the database and ASM on particular instance Remove the database and ASM Remove the Oracle Database Software Remove the Clustware Update the oracle inventory Current Scenario [oracle@rac1 ~]$ olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned rac3 Active […]
Adding a Database home to a 12c RAC Cluster
In previous article we added the grid home in third home (i.e rac3): Click Here Now we are going to extend the database home in 3rd home. From an existing node i.e rac1 – as the database software owner – run the following command to extend the Oracle database software to the new node “rac3” […]