0 Comments

Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c to 19c in Multitenant Architecture 0 (0)

Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c to 19c in Multitenant Architecture In a recent post, we demonstrated Step by Step Manual Upgrade Oracle Database from 12c to 19c, click here to read about it. In this article, we are going to demonstrate Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c […]

 344 Total Views,  3 Views Today

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

 407 Total Views,  5 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,669 Total Views,  11 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,665 Total Views,  1 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,065 Total Views,  3 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,585 Total Views,  6 Views Today

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,204 Total Views,  6 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 […]

 4,021 Total Views,  4 Views Today

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,312 Total Views,  10 Views Today