• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for July 2019

Beginners Guide to Flash Recovery Area in Oracle Database

by admin

This post discusses the below topics: Benefits of using Flash Recovery Area. Explains how to Create FRA using DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST Database Files that can reside in Flash Recovery Area. How to Disable FRA What is a Flash Recovery Area? The flash recovery area can be defined as a single, unified storage area that keeps […]

Filed Under: oracle

Oracle Interview Questions – Flash Recovery Area

by admin

Naming convention: Oracle 10g: FLASH Recovery Area Oracle 11g: FAST Recovery Area 1. What is a Flash Recovery Area ? The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover […]

Filed Under: Interview Questions, oracle

How to Identify Different File types and space used in Flash Recovery Area

by admin

Question: How to find out the existence of different types of files and backups available with the usage of space in the Flash Recovery Area? Starting with Oracle 10G Release 2, a new view has been made available: V$FLASH_RECOVERY_AREA_USAGE. V$FLASH_RECOVERY_AREA_USAGE shows the percentage of the total disk quota used by different types of files, and […]

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

Database Crashed With ORA-19815, ORA-19809, ORA-16038

by admin

The Problem Instance terminated due to error 16038 as its not able to archive the log in FRA: ORA-19815: WARNING: db_recovery_file_dest_size of 99614720000 bytes is 100.00% used, and has 0 remaining bytes available. Sat Mar 8 00:57:07 2008 ************************************************************************ You have following choices to free up space from flash recovery area: 1. Consider changing RMAN […]

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

How to Verify a Lun is in Active/Optimized Mode when ALUA Is Configured on Storage

by admin

If the Linux server has device-mapper-multipath configured, you can run ‘multipath -ll’ to list how disks are grouped together. For ALUA mode, you can check if a disk is in the Active/Optimized or non-optimized group. This post, however, is to discuss how to use sg_rtpg command to check the target port group asymmetric access state […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Linux

Oracle Database – Measuring Network Capacity using oratcptest

by admin

The Basics Oratcptest is a command line tool that runs on two hosts, one in client mode and the other in server mode, to measure network bandwidth and latency between client and server. Oratcptest establishes a TCP connection between the client host and server host and then sends network messages to Oratcptest on the server […]

Filed Under: oracle

How to Create Yum Repository For System Packages Installation in CentOS/RHEL

by admin

A yum repository holds the rpms and metadata about the rpms. A yum repository must be configured in order to use yum on any yum based Linux system. This post provides steps to configure a yum repository for installing packages on CentOS/RHEL systems. Configuring yum repository server 1. Create a directory for you local repository, […]

Filed Under: CentOS/RHEL 5, CentOS/RHEL 6, CentOS/RHEL 7, Linux

Getting “parsing errors” When Running ‘yum repolist’

by admin

The Problem When adding an extra repository of the public yum into existing yum repository configuration file, the following errors are shown: # yum repolist Loaded plugins: langpacks, ulninfo File contains parsing errors: file:///etc/yum.repos.d/public-yum-ol7.repo [line 91]: name=Latest Unbreakable Enterprise Kernel Release 4 for Oracle Linux 7Server (x86_64) [line 92]: baseurl=https://yum.oracle.com/repo/OracleLinux/OL7/UEKR4/x86_64/ [line 93]: gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle [line 94]: […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Linux

How to Install Apache, MariaDB, and PHP (FAMP) stack on FreeBSD 11

by admin

In this tutorial we will show you how to install Apache, MariaDB, and PHP on FreeBSD 11. If you don’t know FAMP is the acronym of FreeBSD, Apache, MySQL/MariaDB, PHP. FreeBSD 11 is the latest version right now when this article was made. Prerequisites Before you begin with this guide, you should at least have […]

Filed Under: FreeBSD, Linux

How to configure apache virtual host on ubuntu

by admin

In this tutorial, we will guide you to configure the apache virtual host or vhost on ubuntu 16.04. Using virtual host allow the administrator to use one server to host multiple domains or sites off of a single interface or IP by using a matching mechanism. Basically, you can you one IP address to server […]

Filed Under: Linux, Ubuntu, Ubuntu 16.04

« Previous Page
Next Page »

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright