RCONFIG is a non interactive command line utility for converting a Single-Instance database to RAC database.It is installed by default as a executable file under $GRID_HOME/bin and $ORACLE_HOME/bin. It takes XML file as input and process the conversion procedure. Benefits of using RCONFIG : It’s very light and easy to use utility for conversion of Single Instance database […]
Category: ORACLE RAC
Converting RAC DB to Non-RAC on Normal File System
To convert RAC to Non-RAC DB on normal file system we need to first convert it into ASM storage Converting RAC db to Non-RAC db In this article we will see conversion database from ASM to Normal File System : Step 1 : Check details of ASM database and create pfile from spfile : [oracle@rac1 […]
Converting RAC db to Non-RAC db
In previous Articles we have seen conversion from Single Instance DB to RAC db using various methods.In this Article we will see conversion of RAC to Normal DB[Single Instance]. Prerequisites : RAC Instance Node RAC Node Name RAC DB Name RAC Instance Name Single Instance DB name Node 1 RAC1 test db1 test Node 2 […]
Basic on Administrator Managed and Policy Managed Database in Oracle Rac
There are two methods to manage your cluster database. Administrator Managed database Policy Managed Database Administrator Managed Database : In Administrator Managed database , a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.It is traditional way of cluster management. Policy Managed Database : It’s […]
Convert Single Instance Database to Oracle RAC
In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2. Prerequisites: we already have single instance ASM database up and running. we have already have second node with ASM running. If you want to how to convert non asm database to asm database with duplicate command: Click Here RAC […]
Convert Non ASM database to ASM Database using Duplicate Database command
You can use these steps to migrate a NON-ASM database to ASM database in Oracle 11gR2. Prerequisite – ASM instance should be created and up and running. Single Instance Non ASM DB name Single Instance ASM DB name test testdb Step 1 : Check details of Single Instance Database : SQL> select name,open_mode from v$database; NAME […]
Relink Oracle 12c Grid Infrastructure and RDBMS binaries.
In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after stopping all the services running: 1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows: [root@RAC18C ~]# $ORACLE_HOME/crs/install/rootcrs.sh -unlock Using configuration parameter file: /u01/app/18.0.0.0/grid/crs/install/crsconfig_params The log of current session can be found […]
Patch 27107360 – Oracle Grid Infrastructure PSU 11.2.0.4.180116
Patch Information GI PSUs are cumulative and include the Database PSU and associated CPU program security content. This is Jan 2018 PSU having Patch number 27107360 for 11gR2. OPatch Utility Information You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2 […]
CRS-2101:The OLR was formatted using version 3
Got this while trying to install 11.2.0.4 RAC on Redhat Linux 7.3. root.sh fails with a message like # /u01/app/11.2.0/grid/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/11.2.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of “dbhome” have not changed. […]
Fast Application Notification[FAN] Benefits :
For DBA, if a database is up and running, everything seems beautiful..!! But once a state change happens in a database, we don’t know will it take 2 min to overcome it or it will eat our infinite time. When we talk about Oracle RAC, we know there are multiple resources are available to give […]