Convert Single Instance Database to Oracle RAC

In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2. Prerequisites: we already have single instance ASM database up and running. we have already have second node with ASM running. If you want to how to convert non asm database to asm database with duplicate command: Click Here RAC […]

Read More

Convert Non ASM database to ASM Database using Duplicate Database command

You can use these steps to migrate a NON-ASM database to ASM database in Oracle 11gR2. Prerequisite – ASM instance should be created and up and running. Single Instance Non ASM DB name Single Instance ASM DB name test testdb Step 1 : Check details of Single Instance Database :

Optionally, we can check size […]

Read More

Relink Oracle 12c Grid Infrastructure and RDBMS binaries.

In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after stopping all the services running: 1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows:

2) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home […]

Read More

Patch 27107360 – Oracle Grid Infrastructure PSU 11.2.0.4.180116

Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]

Read More

CRS-2101:The OLR was formatted using version 3

Got this while trying to install 11.2.0.4 RAC on Redhat Linux 7.3. root.sh fails with a message like

This is bug 18370031. Need to apply the patch before running root.sh. Install of Clusterware fails while running root.sh on OL7 – ohasd fails to start (Doc ID 1959008.1)

Execute the root.sh script once you applied the patch.

Thank […]

Read More

Fast Application Notification[FAN] Benefits :

For DBA, if a database is up and running, everything seems beautiful..!! But once a state change happens in a database, we don’t know will it take 2 min to overcome it or it will eat our infinite time. When we talk about Oracle RAC, we know there are multiple resources are available to give […]

Read More

Converting an Administrator-Managed Database to a Policy-Managed Database

In this article, We can convert Administrator managed database to Policy managed database : First of all, let’s check the configuration of the database :

In above output, we can see the last line shows us my demo database is an administrator-managed database. Now next we need to create a server pool.

In […]

Read More

Relocating Service in Oracle RAC

In this article, we will see Relocation of Service from One Instance to another Instance. I have service called myservice already running at orcl1 instance. Let us check status of myservice

Now relocate service from orcl1 to orcl2

-i represents an old instance -t represents a new instance Now check the status of […]

Read More

Creating Deleting and Modifying Services in Oracle RAC

1.Creating Service in Oracle RAC : Step 1: To create a service in Oracle RAC

Here I have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation :

Step 2: Check the status of service :

We can see here service […]

Read More

ols.pl – A script to display GI/RAC Flex Cluster

Oracle Clusterware command olsnodes displays node number/status/type/VIP, this is useful but not enough. To clearly display a node’s functional role in 12c, including but not limited to CRSD PE Master/Standby, CTSS/UI/ONS Master as well as Leaf-to-Hub connections etc, ols.pl is written to automatically present this info in a clear and handy way. You can download the […]

Read More