0 Comments

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

To Find Sessions In RAC 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 RAC to […]

 643 total views,  3 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. […]

 401 total views,  2 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 […]

 775 total views

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

 724 total views,  3 views today

Spread the love

0 Comments

How to check ASM diskgroup Size. 0 (0)

Sometime we need to fetch ASM diskgroup utilization of database. Below is the sql query to find ASM diskgroup size in database which includes Name,Total_GB,Free_GB,Used_GB and Free_percentage of disk. Sql query to fetch ASM diksgroup size. Click here to get sample output . Reference: How to add disk into ASM diskgroup. click here Hope so […]

 185 total views

Spread the love

0 Comments

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

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

 1,198 total views

Spread the love

3 Comments

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

Transparent Application Failover (TAF) is used for failover process, if the database instance connection goes fails it would reconnect to available database instance. TAF can be configure in a 2 ways.1.server Side2. Client Side. IN this Blog, we will configure server side TAF. To configure TAF policy use SRVCTL as in the following example srvctl […]

 1,132 total views,  1 views today

Spread the love