Modern Oracle DBA

Changing passwords frequently helps ensure database security, Oracle Applications provides a command line utility, FNDCPASS, to change/reset Oracle Applications schema passwords. This utility changes the password registered in Oracle Applications tables, changes the schema password in the database and can also change user passwords. Key Considerations: Autoconfig Requirement: After changing the APPLSYSPUB or GUEST user passwords, need to run the autoconfig. Pre-Change Preparations: Shutdown Applications: Before changing the APPS password, make sure to shut down the application. Backup Critical Tables: Perform a backup of the FND_USER and FND_ORACLE_USER_ID tables. If anything goes wrong during the password change process, you can restore these tables to revert to the previous state. Restrictions: The system and sys user passwords cannot be changed using the FNDCPASS utility. Users not registered in the FND metadata tables cannot be modified using this utility. Syntax:

What is Control File: It is small binary file It is required for database during startup operations Each database associated only one oracle database Control File Contents: DB Name and identifiers Tablespace names Names and location of data files and redo log files Check point information Redo log and archive log information Backup information Multiplexing the control file: Check the database running SPFILE (or) PFILE. My  DB is running SPFILE Multiplexing Control file DB running in SPFILE Step 1: Check the control file location Step 2: Alter the SPFILE Alter system set command is alter the spfile to including a list of control files to be used Step 3: Shutdown the database Shutdown the database in order to create additional control files on the OS level Step 4: Create additional control files using OS copy command Step 5: Start the database When the DB started spfile will be re

Oracle Database The general purpose of a database is to store and retrieve related information. Oracle database has a logical and physical structure   Physical structure   The physical structure of database it’s the set of OS in the database It’s consist of three file types Data files : Containing the actual data in database Redo log files: Click hear Record all changes made a data It’s provide a recovery mechanism Can be organized into groups At least two groups are required Control files: Click hear Defines current status of physical database At mount stage during startup It’s a binary file Memory Structure Oracle database consists of tow memory structure System Global Area (SGA): It’s allocated at instance startup and other component of an instance Program Global Area (PGA): Allocated when the server process started De allocated when process terminated Used by only one process Sys

R11i / R12: Component Version In Oracle Applications (Doc ID 1327288.1) How to Replace Oracle Logo with Company Logo on Applications 11i Sign-On Screen (Doc ID 119319.1) How To Set Concurrent Program To Run Exclusively From A Custom Manager (Doc ID 2268941.1) How to Create a Custom Concurrent Manager (Doc ID 170524.1) Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1) How to Recover from a Lost or Deleted Datafile with Different Scenarios (Doc ID 198640.1) How To Change Log Archive Destination While the Database Is Open When the Archive Destination Is Full (Doc ID 160446.1) 12.2 E-Business Suite Applications DBA Steps To Create, Update or Rebuild The Central Inventory For Oracle Applications (Doc ID 1588609.1) E-Business Suite - ADOP Basic Usage Training Videos [Video] (Doc ID 2103131.1) How to Change IP Address in an Oracle Applications Environment (Doc ID 553318.1)          Useful E-Business Suite 12.2 Documents

What is Concurrent manager? Batch Processing Sub-System Programs are run as operating system background processes. These programs may be written using a variety of Oracle tools, programming languages for executables, or OS scripts. Internal Concurrent Manager (ICM)   Controls all other concurrent managers. It administers the startup and shutdown of managers as defined by their work shift, monitors for process failure, and cleans up if a failure occurs. Standard Manager As shipped with Oracle Applications will accept and run any concurrent requests. Conflict Resolution Manager (CRM ) Enforces rules designed to ensure that incompatible concurrent requests do not run in the same conflict domain  Output Post Processor (OPP ) Concurrent Processing uses the Output Post Processor (OPP) to enforce Post Processing Output post processor run the XML publisher Concurrent Manager – Tables FND_CONCURRENT_