ARCHIVE LOG MANAGEMENT: A database has ARCHIVE LOG and NO ARCHIVE LOG modes. We can can query “archive log list” to know your database archive log mode. When the database is in NO ARCHIVE LOG mode, redo log files will get overwritten each time all the redo groups are switched …
Read More »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
DBA CENTRE Blog for Database Administrators & Cloud Admins