To see overview of ACFS file System , Oracle ASM Cluster File System Step 1 : Basic thing to use ACFS file system is compatible.rdbms, compatible.advm parameter should be set to 11.2 or higher. [oracle@rac1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 21 23:22:52 2018 Copyright (c) 1982, 2013, Oracle. […]
Articles Tagged: ORACLE RAC
Oracle ASM Dynamic Volume Manager and ASM Cluster File System
ASM is a preferred storage for all database files – Datafiles, Controlfiles , Redo log files, Archive Logs, RMAN backups ,Flashback Logs etc. And Oracle ACFS is the preferred file manager for non-database files. It is optimized for general purpose files.Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and […]
Services in Oracle RAC
Based on the number of instances participating in your Oracle RAC Cluster and complexity and objectives of your application’s environment we need to choose optimal workload management. And there variety of considerations based on that. We can use following features of Oracle RAC to manage workload : Oracle Services Database Resource Manager Oracle Rac High […]
Transparent Application Fail-over in Oracle RAC
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 […]
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″?> […]
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 […]
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 […]
Fast Application Notification[FAN] Events
In previous articles we have seen FAN overview Fast Application Notification [FAN] overview and benefits of using FAN In this article we will see supported event types of FAN. Node Down : This event notifies that node is not reachable.The Cluster sends this event when a node is no longer able to accept work. Service Up: […]
Connection Load Balancing in Oracle RAC
Load balancing means “to distribute load among multiple entities”. In Oracle RAC ,Load Balancing feature is very well maintained. Load is distributed among all instance. However we need to take care of some things , like creating service based on group of users connecting database.Assigning number of backup instance if service fails on preferred instance […]
Convert Single Instance Database to RAC Database using RCONFIG
In Previous article we learned about overview of RCONFIG . In this Article we will see Conversion of Single Instance DB to RAC DB with RCONFIG Prerequisites : Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name test TEST Node 1 db1 RAC1 Node 2 db2 RAC2 Step […]