Oracle Latest Technology: Apps DBA Tutorial

Showing posts with label Apps DBA Tutorial. Show all posts

Installation of Oracle Apps R12.2.x Step by Step guide

In this article, installation of R12.2.x has been shown with detail installation screen. This is a single node installation where database and apps will be installed in same server. This installation was done on a linux

How to Kill Inactive session in Oracle Database

The following is the process or steps to kill the inactive session in Oracle Apps.

Step by step guide for creating Disaster Recovery site for Oracle Apps R12

In this article, I tried to explain Disaster Recovery [DR] site creation for R12 in elaborate manner. It's a very much practical hands on article. By, following each steps carefully any one can create a R12 Disaster Recovery site. I tried to avoid theoretical details about Disaster Recovery unless required for practical implementation. Here I have given a real DR site creation process.

How to clone Oracle Apps R12 Online A Step by Step Guide

Most of the time Oracle Apps project requires a test instance which is almost similar to Production instance. R12 Production instance can’t be brought down for taking offline clone. So, for online cloning you need to use RMAN. The following is a step by step guide to make a clone instance as similar as Production. Here Production instance is referred as "SOURCE" and test

How to enable RMAN backup in Oracle Apps R12

-->

Check whether database is running on acrchivelog mode or not

SQL> archive log list;

Database log mode No Archive Mode

Oracle Apps Configuration Tutorial - Concurrent Manager

Here we will see in details how we can define concurrent manager in oracle R12. As you are aware a concurrent manager itself is a concurrent program which runs other concurrent manager. So, lets see how we can define this manager.

Step by step Oracle Apps R12.1.3 Rapid Cloning

Prerequisite Steps

1. If your target server holds at least one Oracle Apps R12.1.3 instance, you can skip for any OS patch or software requirement section. As the server is running a Oracle Apps instance, we can assume the server has all the

EBS R12 Migration from Solaris to Linux

How to Migrate Oracle R12 instance from Solaris to Linux

Recently I have migrated the Solaris R12.1.1 instance to Linux. The following article describes the overall process. Although we have mostly followed the oracle doc on R12 export/import and apps tier platform migration, in some of

Section 1: Prepare the source system

This section describes how to ensure that you have the required patches, create your export file, and capture important information that is required to

Oracle Apps DBA Health Checkup and performance scripts Part 3 Apache, Form and Report log file deletion scripts in R12

The following scripts will delete old report, form and apache log files. Save the following code segments in a shell scripts.

Oracle Apps DBA Health Checkup and performance scripts Part 2 Details Oracle Apps Auditing and performance check

The following script is a master script which audits and checks various Oracle Ebusiness Suite parameters in a single run. It runs a variety of Oracle Apps Health Checks. Warning section at beginning should usually return no rows.

Oracle Apps DBA Health Checkup and performance scripts Part 1 OMPN process check in R12

The following scripts is a useful script to check the opmn status of oracle apps R12 server at once. This is a handy script to check the status in one shot. Here I am checking the opmn status of $ADMIN_SCRIPTS_HOME. Alternatively