Oracle Applications R12 Architecture

Introduction:- Being a core Oracle DBA we have deep knowledge of Oracle Database Architecture. In any architecture, we go through the proper function. After having a good knowledge of database architecture we must work beyond of it. In this article, we are going o have a tour of Oracle Application R12c architecture. This architecture is totally different from […]

Read More

Creation of Physical Standby in Oracle One Node

Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data […]

Read More

Installing Oracle Statspack

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about Oracle Statspack. We are going to learn what is Oracle Statspack? how does it work, why do we need of Oracle Statspack? Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. […]

Read More

Monitoring changes to Oracle tables

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The main purpose of this type of monitoring, in my opinion, is to know the most altered tables, the amount of changes in these tables since the last collection of statistics. Why since the last collection of statistics? Because every time a […]

Read More

Rebuilding / Moving MGMTDB on Grid Infrastructure 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically:

If your […]

Read More

Deleting diskgroup via asmcmd

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups:

So we tried to delete the diskgroup:

Note that […]

Read More

Difference between Oracle DBA and Oracle Apps DBA

Normally people start their journey from a software engineer in Information Technology. We all are aware of few fields of IT like testing engineer, data analyst, software engineer, web designer, coder etc. But in information-technology, we have an ocean of different kind of professions.  In IT sectors administration plays an important role in business. without an administrator, IT projects can not […]

Read More

Introduction to Oracle AWR

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Today let’s talk a little about a fantastic feature we have in Oracle Database that helps us in performance analysis: the AWR. What is AWR? AWR stands for Automatic Workload Repository, ie it is a repository of information about the […]

Read More

Amount of redo generated during user-managed backup

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: –  In this article, we have a quick journey on redo log during user-managed backup. RMAN is the most recommended tool for performing backup and recovery of an Oracle database, but we know that this is not always the case and many […]

Read More