Friday , December 15 2017
Home / Oracle DBA

Oracle DBA

ARCHIVED REDO LOGFILE MANAGEMENT

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 »

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 …

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 create ASM base groups

Creating ASM base groups: >> Before  creating ASM groups, we should check “labels” and “raw partition or disk partition.” NOTE: You can see that “TYPE=”oracleasm”” disks are already configured to be used for ASM groups. >> We will use ASMCA utility for creating ASM disk groups ASMCA stands for (Automatic …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe