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 11.2.0.4 to 12.1.0.2 on the command line

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

Now we are extracting the source files for 12.1.0.2 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

Rebuilding / Moving MGMTDB on Grid Infrastructure 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically:

If your […]

Read More