Enable Enterprise Manager Database Control for Oracle E-Business Suite R12

Introduction

Managing the Oracle Database installed with Oracle Applications was a headache task for me specially when there is no EM console installed with the Applications Installation. And searching in this criteria always will take you to the direction of installing EM Grid or Cloud Management and trying to enable the Management Pack for E-Business which is a task you may not prefer to do if you have only one system which is the Oracle E-business Suite in our case.

Converting Oracle APPS R12 to start and work with spfile instead of pfile

In this document

• Introduction
• Changing APPS to work with spfile
• References

Solving "ORA-27037: unable to obtain file status"

There are many causes of the ORA-27037, may be a file is missing from its location or may be a file location reference is typed incorrectly in some other file.

Cause:

Planning/Installing Oracle E-Business Suite (Oracle Applications) R12.0.4 on Linux AS4 Part 2/2

In this document

• Step 4: Before Installation Tasks
• Step 5: Creating Stage
• Step 6: Installing Oracle APPS R12.0.4

Planning/Installing Oracle E-Business Suite (Oracle Applications) R12.0.4 on Linux AS4 Part 1/2

In this document

• Step 1: Planning Installation
1. Before Installation Notes
2. Settings we use.
• Step 2: Creating The Virtual Machine
• Step 3: Installing Operating System

Getting Started DB 11g - Oracle Instance Overview

Oracle Instance Overview

An Oracle database system consists of an Oracle database and an Oracle instance.


A database consists of a set of disk files that store user data and metadata.
Metadata consists of structural, configuration, and control information about the database.

An Oracle instance (or database instance) contains the set of Oracle background processes and a shared memory for them (System Global Area SGA)

Getting Started DB 11g - Basic Definitions

The Oracle Database Administrator

The Oracle DB Administrator (DBA) is the one who is responsible for the overall operation of Oracle Database. In this chapter Oracle describe common DBA tasks and tools. This chapter contains the following sections:

Database Backup - Your First Approach

-- This Article describe the actual steps done in order to backup a database
-- These are the most basic manual steps but also the most effective

-- The most basic steps are the following
 -- 1. Change database to work in ARCHIVE LOG mode
 -- 2. Perform a full backup for first time from OS
 -- 3. Create rman catalog database, register your database
 -- 4. Backup your database FULL Backup monthly, Incremental levle 0 weekly, Incremental levle 1 daily

-- Here are the actual steps