ARCHIVELOG MANAGEMENT: A database has ARCHIVELOG and NOARCHIVELOG modes. We can can query “archive log list” to know your database archive log mode. When the database is in NOARCHIVELOG mode, redo log files will get overwritten each time all the redo groups are switched and we cannot have backups of …
Read More »MySQL DBA Interview Questions and Answers
MySQL Interview Questions Before you even start asking questions pay attention to how YOU pronounces MySQL. The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way. The reason …
Read More »oracle 12c Release Install – PRVF-0002 : could not retrieve local node name
Error:- PRVF-0002 : could not retrieve local node name if you face this type of error while installing Oracle 12c Release 2 , make sure see you hostname if not properly set, change it with a proper name. Here you can find my host name dbacentre save and if your …
Read More »How to install Oracle 11g Grid Infrastructure software and step by step process for ASM configuration
Tools and Software’s used for this Demonstration: VMware Workstation 10.0 Oracle Enterprise Linux 6.0 (64-Bit) Oracle Grid Infrastructure software 11.2.0.1 (64-Bit) Oracle Database software 11.2.0.1 (64-Bit) Step 1: Install prerequisites packages for Oracle Database. You can get them from link as per your operation system version. Step 2: Setup ASM …
Read More »Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)
Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated PGA management by introducing PGA_AGGREGATE_TARGET parameter. Oracle 10g continued this trend by automating SGA management using the SGA_TARGET parameter. Oracle 11g takes this one step further by allowing you to allocate one chunk of memory, …
Read More »How to perform RMAN cloning (Easy process to clone a database on different server)
Cloning is a process of making a separate copy from one database to another. Cloning is a different kind of operation to replicate and backup in the cloned environment it is fully functional and separate in its own right. Cloning is helpful for duplicating production databases which can be used …
Read More »Step by Step process on how to configure Dataguard for Standby Database
Dataguard is used to create standby database for live production database which will be used as disaster recovery for the live database. Below are the steps to be followed to configure dataguard. Steps to be followed in Primary Database: STEP 1: Check whether the database is in Archive Log Mode …
Read More »Moving a database from Normal File System to ASM storage
Default storage for oracle database is File System, where database files resides on local storage. In order to configure ASM storage and move existing database from normal File System to ASM, follow below steps: Step 1: Check locations for data files, control files, redo log files and temp files on …
Read More »INS-41814 The installer has detected that some of the services of Oracle Grid Infrastructure are not running on this system.
ERROR DESCRIPTION ================= INS-41814 The installer has detected that some of the services of Oracle Grid Infrastructure are not running on this system. ERROR DETAILS ============= CRS-4124: Oracle High Availability Services startup failed. CRS-4000: Command Start failed, or completed with errors. ohasd failed to start: Inappropriate ioctl for device Read …
Read More »How To Add New Disk To The Existing Disk Groups in ASM
Process to check existing Disk Groups: Step 1: Export oracle SID for ASM instance and connect sqlplus as sysasm user. Step 2: We can use v$asm_diskgroup to query existing disk groups information. NOTE: You can see that there are 2 disk groups are available. Step 3: In order to check …
Read More »