In this article, We can convert Administrator managed database to Policy managed database : First of all, let’s check the configuration of the database : [oracle@rac1 ~]$ srvctl config database -d demo Database unique name: demo Database name: demo Oracle home: /appndb/oracle/product/11.2.0/db_1 Oracle user: oracle Spfile: +DATA/demo/spfiledemo.ora Domain: Start options: open Stop options: immediate Database […]
Category: ORACLE RAC
Relocating Service in Oracle RAC
In this article, we will see Relocation of Service from One Instance to another Instance. I have service called myservice already running at orcl1 instance. Let us check status of myservice [oracle@rac1 ~]$ srvctl status service -d orcl -s myservice Service myservice is running on instance(s) orcl1 [oracle@rac1 ~]$ Now relocate service from orcl1 to […]
Creating Deleting and Modifying Services in Oracle RAC
1.Creating Service in Oracle RAC : Step 1: To create a service in Oracle RAC [oracle@rac1 ~]$ srvctl add service -d orcl -s myservice -r orcl1 -a orcl2 -P BASIC Here I have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation : [oracle@rac1 […]
ols.pl – A script to display GI/RAC Flex Cluster
Oracle Clusterware command olsnodes displays node number/status/type/VIP, this is useful but not enough. To clearly display a node’s functional role in 12c, including but not limited to CRSD PE Master/Standby, CTSS/UI/ONS Master as well as Leaf-to-Hub connections etc, ols.pl is written to automatically present this info in a clear and handy way. You can download the […]
Fast Application Notification [FAN] overview
As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]
Grid Naming Service in Oracle RAC
When we use Oracle RAC, all clients must be able to reach the database. All public addresses, VIP addresses and SCAN addresses of Cluster must be resolved by the clients.And GNS[Grid Naming Service] helps us resolve this problem. GNS is linked to the domain name server (DNS) so that clients can resolve these dynamic addresses […]
Miscellaneous Oracle RAC wait events
Miscellaneous Oracle RAC wait events 1. gc remaster : resource remastering happens based on 2 situation : 1.When Instance leaves or joins cluster. 2.Dynamic remastering from a less busy instance to an instance where demand for that object is too high.This is also called resource affinity. 2. gc cr grant busy : The gc cr […]
Rebootless node fencing in Oracle RAC
Oracle Grid Infrastructure 11.2.0.2 has many features including Cluster Node Membership, Cluster Resource Management, and Cluster Resources monitoring. One of the key areas where DBA need to have expert knowledge on how the cluster node membership works and how the cluster decides to take out node should there be a heartbeat network, voting disk or […]
Node eviction in Oracle RAC
Node eviction is quite sometimes happening in Oracle RAC environment on any platform and troubleshooting and finding root cause for node eviction is very important for DBAs to avoid same in the future. There can be many reasons behind node eviction like , Network Heartbeat Missed Voting Heartbeat Missed CSSD Agent/ Monitor hung RDBMS instance […]
Split Brain and Amnesia in Oracle RAC
Split Brain and Amnesia Two types of problems can arise from cluster partitions: split brain and amnesia. Split brain occurs when the cluster interconnect between hosts is lost and the cluster becomes partitioned into subclusters, and each subcluster believes that it is the only partition. A sub-cluster that is not aware of the other subclusters […]