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

2. Check the current status SCAN-VIP in the resource file

3. Request network […]

Read More

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

2. Modify the listener

3. Bounce the listener

4. Change the MGMTDB listener

5. Restart the MGMTDB […]

Read More

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 […]

Read More

Upgrading the Grid Infrastructure from to on the command line

Currently I have two node Grid Infrastructure on The node names are node1 and node2:

Now we are extracting the source files for and make necessary folder.

Now we creating the response file for installation of new grid on both nodes.

Now we are installing grid home with response […]

Read More

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

Step 1: Stop the instance

Step 2: Remove the instance


Read More

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” […]

Read More

Adding a Grid node to a 12c RAC Cluster

The generic steps to follow when adding the new node to the cluster are: Install Operating System Install required software Add/modify users and groups required for the installation Configure network Configure kernel parameters Configure services required such as NTP Configure storage (multipathing, zoning, storage discovery, ASMLib?) We assume that our OS,storage and network is already […]

Read More

ACCIDENTALLY data file is added without “+” sign

In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log.

Solution 1.  Find out the data file number( It is available in the alert log) 2.  use the rman to copy the data to ASM disk group. 3.  offline the […]

Read More