0 Comments

Steps to Upgrade Grid Infra – Standalone (GI) and Oracle Database from 12.2 to 19.14 0 (0)

Steps to Upgrade Grid Infra – Standalone (GI) and Oracle Database from 12.2 to 19.14 In recent two blogs, we discuss Applying the latest JAN-22 RU 33583921 on Grid Infra – Standalone and Database Home (OH) 12.2 Click here to read more. & Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure […]

 305 Total Views,  5 Views Today

0 Comments

RMAN Active Duplicate Database in Oracle from ASM to ASM 0 (0)

RMAN Active Duplicate Database in Oracle from ASM to ASM In a recent article, we demonstrated about Step by Step Migrate Database from Non-ASM to ASM in Oracle click here to know more about it. In this article, we will demonstrate step by step RMAN Active Duplicate Database in Oracle from ASM to ASM with […]

 748 Total Views,  3 Views Today

0 Comments

How to Find Sessions in RAC Oracle All in One 5 (3)

How to Find Sessions In RAC Oracle All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to monitor application connected sessions, etc. Here we are going to show various scenarios to find connected sessions in RAC databases. Here we have a two-node […]

 2,563 Total Views,  1 Views Today

0 Comments

Starting and stopping an Oracle ASM instance for Noncluster Databases 0 (0)

Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called Oracle Instance.  The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and background processes. […]

 2,551 Total Views,  9 Views Today

2 Comments

What is Cluster and How can we find if a Database is running on Cluster 4.6 (5)

What is Cluster and How can we find if a Database is running on Cluster Oracle Real Application Cluster provides its users to run a single database into multiple servers. These multiple servers act as a single system. It provides fast recovery at the time of any site failure. To avoid the outage and provide […]

 2,009 Total Views,  2 Views Today

0 Comments

ORA-01102: Cannot Mount Database in EXCLUSIVE mode 5 (2)

ORA-01102: Cannot Mount Database in EXCLUSIVE mode When we are doing database refresh from Prod to Dev (lower environment), At that time we put the cluster database parameter to false. This parameter is spfile file specific, so we need to bounce the database. After the refresh completed successfully, we are trying to start the node, […]

 2,508 Total Views,  3 Views Today

Spread the Knowledge!

2 Comments

How to check ASM diskgroup Size in Oracle 5 (1)

Sometimes we need to fetch ASM diskgroup utilization of the database in Oracle. Below is the SQL query to find ASM diskgroup size in a database which includes Name, Total_GB, Free_GB, Used_GB and Free_percentage of the disk. SQL query to fetch ASM diksgroup size. Click here to get sample output. Click here to know about […]

 3,024 Total Views,  4 Views Today

2 Comments

Add Disks to ASM Disk Group in Oracle 4.9 (12)

How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new application to fulfil testing. As per requirement, we need additional space in our database. Below are the steps that we have to follow to add […]

 3,891 Total Views,  7 Views Today

Spread the Knowledge!

3 Comments

Transparent Application Fail-over in Oracle RAC 4.5 (22)

Transparent Application Fail-over in Oracle RAC Transparent Application Failover (TAF) is used for the failover process, if the database instance connection goes fails it would reconnect to the next available database instance. TAF can be configured in 2 ways. 1. Server-Side2. Client-Side. In this blog, we will configure server-side TAF. To configure TAF policy use […]

 2,255 Total Views,  3 Views Today

Spread the Knowledge!