RCONFIG overview

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 […]

Read More

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 […]

Read More

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 […]

Read More

OPatch failed with error code 135 – Argument(s) Error… Given ‘ocmrf’ file does not exists

Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows: 2017-09-23 04:24:41: s_run_as_user2: Running /bin/su oracle -c ‘ /oracle/product/11.2.0/db/OPatch/opatch napply /software_dump/latestpatch/18706472/18522509 -local -silent -ocmrf /home/grid/responsefile/file.rsp -oh /oracle/product/11.2.0/db -invPtrLoc /oracle/product/11.2.0/db/oraInst.loc ‘ 2017-09-23 04:24:42: Removing file /tmp/filexagz0g 2017-09-23 04:24:42: Successfully removed file: /tmp/filexagz0g 2014-09-23 04:24:42: /bin/su exited with rc=135 2017-09-23 04:24:42: […]

Read More

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 […]

Read More

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. […]

Read More

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 […]

Read More

Converting an Administrator-Managed Database to a Policy-Managed Database

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 […]

Read More

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 […]

Read More