How to change the db name using nid utility
Introduction to Nid Utility: NID is an utility which is used to change the database internal name and dbname of a database. The utility is placed in the $ORACLE_HOME/bin directory.…
Read MoreHigh Water Mark management in Oracle Database
Description: Each table is made up of extents and each extent is made up of oracle blocks – a common block size is 8k. So you have a table with 10 extents (80K). When any table creates the…
Read MoreMigrating Non ASM Database to ASM Database.
Database Migration from Non-ASM to ASM We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance…
Read MoreOracle 12c-Step by Step Manual Data Guard Switchover
Oracle 12c-Step by Step Manual Data Guard Switchover Prepared by Ranesh Details Primary Side Standby Side Server Name Primary Pysical Standby DB Name Warangal Mumbai IP Adresses 192.168.182.128 192.168.182.129 Step 1:- Check database role…
Read More