Server Pools in Oracle RAC

Before Release of Oracle Clusterware 11g release 2, we define a specific instance belong to specific node.a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster. And it is pretty well with small no of nodes in your RAC database. But when no of nodes […]

Read More

Creating RAC database With PDBS

In this Article we will Create RAC Database with PDBS using DBCA. Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click  next: Step 2 : Select Advanced Mode and click Next Step 3 : Select RAC database as database type and Admin Managed […]

Read More

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.       Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]

Read More

View a Service Instance with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL. To know basic about RESTAPI In last post, we created an instance with RestApi. Now, in this post, we will see how to get the information about that instance. […]

Read More

Create a Service Instance with REST API in Oracle Cloud

The following example shows how to create a Database Cloud Service instance by submitting a POST request on the REST endpoint using cURL. To know basic about RESTAPI In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da” and the Oracle Cloud user name and password are “clouduser” and “Pa$$word“. The request body specifies the creation of a service instance named […]

Read More

Oracle Dataguard Architecture

In previous article , we have seen basics about Oracle Dataguard ORACLE DATAGUARD. In this article we will see oracle dataguard architecture in depth. Let us understand above diagram with example. Let us assume our primary database is in Delhi, India and standby database is in Bangalore , India. When we have just primary database […]

Read More

vipca error in Oracle RAC

Today we are going to learn about the error occurs in the Oracle RAC environment. Vipca is not opening new configuration window and is giving error

To resolve this issue Perform two steps

Now again run vipca and worked fine

Thanks for giving your valuable time to read our post. Stay tuned […]

Read More

kfed script for ASM disk troubleshooting

Today we are going to learn about the kfed “script for ASM disk troubleshooting”  As per our new DBA in the journey of Database we are normally known about troubleshooting regards errors, Now we are going to learn about disk troubleshooting. Few lines of this post explain the definition. The kfed is an undocumented ASM utility that is […]

Read More

ORA-27300: OS system dependent operation

In this article, we are going to have a look at ” ORA-27300″. In this article, we are going to learn how to solve this error. Let’s have fun with ORA-27300 During the creation of a new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted.

Cause I check […]

Read More

ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION

This is the post for the error “ORA-29702”. ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION Cause: An unexpected error occurred while performing a CGS operation.   Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors. ##################################################### ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##################################################### […]

Read More