In this post, You can convert a conventional disk group ie created before Oracle ASM 18c to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option. Migrating (converting) to a flex disk group can be performed for a NORMAL or HIGH redundancy disk group with the CONVERT REDUNDANCY TO FLEX […]
Monthly Archives: March 2018
New look of ASMCA in Oracle 18c
Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS). In addition, you can use the ASMCA command-line interface as a non-GUI utility. In Oracle 18c database, ASMCA comes up with new GUI interface which looks cool and easy to […]
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 […]
Upgrading to Oracle Database 12cR2 Using Transient Logical Standby Method
Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database. This note will document the steps for performing the Advanced Data Guard method of Transient Logical Rolling Upgrade. The following picture provides the general flow for an example migration of on-premise database […]
Upgrading Oracle Grid Infrastructure 11gR2 to 18c
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]
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 […]
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: […]
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. […]