Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. This is true regardless of how the connection was lost. When an Instance shut down unexpectedly […]
Monthly Archives: April 2018
Grid Plug and Play [GPNP] Profile in Oracle RAC
Grid Plug and Play [GPNP] Profile : It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global personality of a node. Each node maintains a local copy of the GPnP Profile and is maintanied by the GPnP Deamon (GPnPD) . [root@rac1 peer]# cat profile.xml <?xml version=”1.0″ encoding=”UTF-8″?> […]
Oracle RAC Dynamic Remastering
In Oracle RAC , Each and every data block is mastered by an Instance. That Instance is called Resource Master for that data block. Master Instance keeps track of the status of the data block like which instance is holding instance for this block , in which state it is being held etc.This Information is […]
SCAN listener in Oracle RAC
What is SCAN in Oracle RAC? Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. And we can say that SCAN is a cluster alias for database. The benefit is that SCAN-NAME you provide for […]
Delete a Service Instance with REST API in Oracle Cloud
The following example shows how to delete a Database Cloud Service instance by submitting a DELETE 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 service instance being deleted is named […]
Convert Single Instance Database to Oracle RAC using dbca
In this article, we will see the conversion of the non-RAC database to RAC database using DBCA. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name dbtest testrac Node 1 testrac1 RAC1 Node 2 testrac2 RAC2 Part 1: Create a template from existing database. Step 1: Run DBCA […]