Posts

How to add utl_file_dir in database

Step1: Stop the application services and create physical folder under utl file directory utlfile/common/PROD /outbound/archive' STEP 2: Check utl file directory details in database Show parameter utl_file_dir Create utl file directory using below SQL command alter system set utl_file_dir='/utlfile/common/PROD,'/utlfile/common/PROD /outbound','/utlfile/common/PROD /inbound','/utlfile/common/PROD /outbound/archive' scope = spfile; STEP3: Shutdown database STEP 4: Start database STEP 5: Verify if new directories are visible                      Show parameter utl_file_dir STEP 6: Start Application services.

How to Identify Tuning opportunity

Every issues we have tuning opportunities but before start to troubleshoot the issue we need to analysis the Issue.
First need to collect basic level of information to user
Second task is where to get the information to server
Third task is find out the issue
Most of the common performance problem causes due to
Lack of Sufficient server hardware Ex: CPU,Memory,Storage,Network Poorly configured initialization parameters Poor application coding
Collect the basic level of information to user
Program Level:
It’s happening in Prod/Non- Prod? Oracle seeded program/Custom program? How much time it used earlier? Any recent code changes done/not? How much data is getting processed?
Application Level:
Is this happening for all user or particular user? Is this happening all forms or particular forms? Application level performance issue Document click hear

Where to get the information to server
Hardware issues:
Need to check TOP command and identify the CPU and memory consumption. Need to check file system space (df…

Output post processor in concurrent manager

Concurrent Processing using the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests.
Post-processing actions are actions taken on concurrent request output.
Example of a post-processing action is that used in Concurrent Processing support of XML Publisher.
If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output.


Tuning for Output post processor
1.Increase the number of Output Post Processor as follows:
 Logon to Applications with "System Administrator" responsibility
 Navigate to Concurrent -> Manager -> Define
 Query for "Output Post Processor"
 Click on "Work Shifts" and Increase the number of processes. (If you have 2 processes then make them 4 if required to 8).
 make sure that you have oracle.apps.fnd…

Concurrent manager log file locations in R12.2

Concurrent manager log file location: Concurrent manager log files are located under $APPLCSF and $APPSLOG home

[oracle@VIS ~]$cd $APPLCSF

[oracle@VIS conc]$pwd
/apps/applmgr/fs_ne/inst/VIS/logs/appl/conc

[oracle@VIS conc]$cd log/

[oracle@VIS log]$pwd
/apps/applmgr/fs_ne/inst/VIS/logs/appl/conc/log
[oracle@VIS log]$

Internal concurrent manager log file:
[oracle@VIS log]$ls -lrt *$TWO_TASK*

Standard manager log file:
[oracle@VIS log]$ls -lrt w*.mgr

Conflict resolution manager log file:
[oracle@VIS log]$ ls -lrt c*.mgr

Output post processer log file:
[oracle@VIS log]$ps -ef |grep OPP
Concurrent program related some basic SQL queries
How to find concurrent program status? SQL> select REQUEST_ID,phase_code,status_code,ORACLE_SESSION_ID from apps.fnd_concurrent_requests where request_id=’1234567’;
How to find concurrent request output and log file location? SQL> select LOGFILE_NAME, OUTFILE_NAME from fnd_concurrent_requests where request_id='1234567';
How to find which concurrent manger ran a spe…

Adadmin overview

Adadmin (Ad administration):
It’s performance the maintenance tasks for Oracle E-business suite.
AD Administration Main Menu
1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD Administration
1. Generate Applications Files menu
1. Generate message files 2. Generate form files 3. Generate report files 4. Generate graphics files 5. Generate product JAR files 6. Return to Main Menu

2-Maintain Applications Files
1. Relink Applications programs 2. Create Applications environment file 3. Copy files to destinations 4. Convert character set 5. Maintain snapshot information 6. Check for missing files 7. Return to Main Menu
3-Compile/Reload Applications Database Entitie

1. Compile APPS schema
2. Compile menu information
3. Compile flexfields
4. Reload JAR files to database
5. Return to Main Menu
4-Maintain Applications Database Entities
1. Validate APPS schema
2.…

What happening FS_CLONE

Adop phase=fs_clone
Validating system setup.
Checking for existing adop sessions
Checking for pending hotpatch session.
Checking for pending cleanup session.
No pending session exists.
Starting new adop session.
Phase: fs_clone
Creating a log file
Validating configuration on node
Checking for pending cleanup actions.
Blocking managed server ports.
Performing CLONE steps.
Alter logon trigger: DISABLE
Alter logon trigger: enable
Releasing managed server ports.
Synchronizing snapshots.
Stopping services on patch file system.
Stopping admin server.
Stopping node manager.
Generating log report.
The fs_clone phase completed successfully.

What happening finalize phase

Adop phase=finalize Checking for pending hotpatch session.
Checking for pending cleanup session.
Continuing with existing session [Session ID: 22].
Verifying data dictionary.
Running finalize phase database actions.
Log: @ADZDSHOWLOG.sql
Finalize System
Executing FINALIZE actions
Compiling invalid objects.
Generating log report:adzdshowlog.out
The finalize phase completed successfully.