Below are the new features of Oracle 12c version. 1. Connecting to ASM instance of remote node: Now we can connect to asmcmd prompt(asm instance) of remote node from local node. SYNTAX – asmcmd –inst < REMOTE ASM INSTANCE NAME> asmcmd –inst +ASM2 2.Move ASM password file using pwmove: We can move the asm pwfile […]

Below are the steps for doing RMAN from RAC to RAC. Steps will be same from NON RAC TO RAC . For standalone database  – Rman active cloning for standalone 12c database SOURCE DB RAC NODE- prodb1-host,prodb2-host DBNAME – PRODB : Oracle 12.1.0.2 INSTANCE NAMES – PRODB1,PRODB2 Oracle 12.1.0.2 TARGET DB RAC NODE – clonedb1-host,clonedb2-host DBNAME […]

      PROBLEM: One of the junior DBA mistakenly created a datafile in local filesystem instead of ASM disk group in RAC database 11g. But he is quick to realize his mistake. Below steps need to be followed to move the datafile to ASM disk group.   SOLUTION: 1. Make the datafile offline; SQL> […]

Copying file between mount points between different servers is straight forward and can be done using scp or ftp command. But transfering file between asm diskgroups of different servers  will be a tricky one. There are two methods to do it. 1. Using cp command of asmcmd 2. Using DBMS_FILE_TRANSFER package   1. Using cp command of asmcmd SYNTAX: […]

         Below are the steps for renaming an ASM diskgroup with database files present inside for a running database.   EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST.  The database present inside the diskgroup is TESTDB2 .   1. Check configuration of the database: srvctl config database -d TESTDB2 […]

  Below are the steps for dropping database in Oracle RAC.   1. Make cluster database to FALSE SQL> alter system set cluster_database=FALSE scope=spfile sid=’*’; System altered. 2. Stop the db service Srvctl stop database –d DBACLASS 3. start the database in mount exclusive mode: SQL> startup mount exclusive restrict ORACLE instance started. Total System […]

       While dropping a diskgroup, error may come like ORA-15073: diskgroup mounted by another instance.   Problem: SQL> drop diskgroup NSMREDOA including contents; drop diskgroup NSMREDOA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup NSMREDOA is mounted by another ASM instance   Solution: For rac with multiple node, you […]

                    Oracle always recommends to keep the controlfile in multiple diskgroups.  For standalone database multiplexing controlfile is straight forward, But for RAC ,we need to follow below steps.   1. Check the controlfile location:   SQL> show parameter control_file NAME TYPE VALUE ———————————— ———– —————————— control_file_record_keep_time […]

While running the opatchauto   command in oracle grid you may face the jdk version error as below. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /crsapp/app/oracle/product/grid12c opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_09-27-57_analyze.log NOTE: opatchauto is […]

                    While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition […]