Applications DBA FAQ

What's an ERP ?

ERP is termed as Enterprise Resource Planning . An enterprise application is an software application that helps to automate and manage business data and functions. In short its a package Single, integrated software program that runs off a single database Various departments can more easily share information and communicate with each other.

Architecture – 11.5.9 release

Client
Oracle JInitiator 1.1.8.16 on Client, soon to be 1.3
Middle Tier
Apache Web Server 1.3.19 (Full – jsp, JServ)
JRE (Java Runtime Environment) 1.1.8
JDK (Java Development Kit) 1.3.1_02
Self Service Framework 5.7H
Oracle Forms/Reports 6i (6.0.8.21 – Patch 12)
Workflow 2.6.2+
Database Tier
Oracle9i Enterprise Edition 9.2.0.3
Other Oracle Home Software Directories
Apps 8.0.6.3 for forms, reports and Discoverer,
iAS 8.1.7 = 9iAS 1.0.2.2.2 (Release 1)
Oracle Portal 3.0.9.8.4
Discoverer 4i (4.1.46)
GSM – Generic Services Manager

Who is an Oracle Apps DBA ?

An Oracle Apps DBA is one who is responsible for maintaining Oracle Apps ebusinesss suite.

What are the responsibilities of an Oracle Apps DBA ?

Installing
Configuring
Maintaining
Patching,Upgrades and Cloning
Troubleshooting

What is a patch ?

Patch is a fix for a bug or an enhancement request. Its a solution for a bug in the product or its a new feature added .we will talk more about this in the next blog