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 […]
Monthly Archives: April 2018
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 […]
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 […]
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. […]
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 […]
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 […]
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 [root@node2 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])] To resolve this issue Perform two steps [root@node2 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node2 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect [root@node2 […]
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 […]
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. Error Details are ORA-27300: […]
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 ##################################################### […]