ORACLE 12C

Restore missing datafile in standby database oracle 12c

        In oracle 12c, if datafile is missing is standby database, then it can be restored easily from primary database using RESTORE DATAFILE FROM SERVICE command. This is one of the new feature of dataguard 12c .    DEMO: PRIMDB – Primary database STYDB – Standby database Check status of primary and […]

Rolling forward standby database when archives missing in primary in 12c

                                  There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby  . Till 11g , we can make standby db sync with primary by taking an incremental […]

GRANT READ PRIVILEGE – Oracle 12c new feature

                                                A new privilege GRANT READ privilege has been introduced in oracle 12c . While the function of GRANT READ privilege is almost same as that of GRANT SELECT privilege, but with a difference […]

How to open the PDBS automatically when CDB restarts

              In oracle 12c , when we startup the CDB, the PDBS will be in MOUNTED stage. We need to open them manually using alter pluggable PDB open. To make the PDBS open automatically, we can use the saved state option . This feature is available from Oracle 12.1.0.2  onwards  […]

Convert non CDB database to PDB database in oracle 12c

     Below are steps for converting a non CDB/PDB database to PDB database in oracle. i.e Plugging a normal 12c non pdb database to a container database.   READ more about CDB and PDB: Oracle 12c Multitenent architecture  DEMO: NON-CDB DB -NAME -> NONCDB CDB DB NAME -> DBATEST Prerequisites:  Make sure One container […]

Cross platform migration using transportable tablespace 12c with zero downtime

     In oracle 12c, transportable tablespace feature has been enhanced a lot. We can do cross platform migration using this feature with zero downtime.  This method uses both RMAN and datapump utility . The first step will take a full backup of the script, when the tablespaces are online and restore the same in […]

Upgrade database using OEM 12C cloud control

 We can upgrade an oracle database using OEM 12c cloud control also.  Here I will show how to upgrade database from 12.1.0.1 to 12.1.0.2 .  Note – Make sure that 12.1.0.2 ORACLE_HOME is installed.  SOURCE ORACLE_HOME(12.1.0.1) – /oracle/app/oracle/product/12.1.0 TARGET ORACLE_HOME(12.1.0.2)  – /oracle/app/oracle/product/12.1.0.2_CRM/dbhome_1   Enable Flashback: Before starting the upgrade, Enable flashback in the database, so […]

ORA-600:[kpdbModAdminPasswdInRoot: Not CDB]

                          While changing the password of internal oracle users in oracle 12c , after it got expired, you may get error as below.   ORA-600:[kpdbModAdminPasswdInRoot: Not CDB] SQL> connect system/oracle ERROR: ORA-28001: the password has expired Changing password for system New password: Retype […]

ORA-20013: DBMS_QOPATCH ran mostly in non install area

             While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem:

  Solution: Check the patching related directories from dba_directories.  

  Check the ORACLE_HOME : echo $ORACLE_HOME /oracle/app/oracle/product/12.1.0.2/dbhome_1 We can see that directories are […]

How to apply JVM patch in oracle 12c database

                  Below are the steps for applying JVM patch in oracle 12c database.   Steps 1 : Download the respective patch from oracle support  and unzip it in the server. unzip 21555660_hxuz.zip cd 21555660 Steps 2 : check the conflict against ORACLE_HOME  

  Step 3: […]

Page 4 of 6« First...23456
Skip to toolbar