Wednesday, 29 August 2012

Oracle Apps 11i/R12 Maintenance mode

Maintenance mode – (adadmin)
when you are going to install a patch on application the recommended option is that enable maintenance node. to bring the application in maintenance mode. when you enable or disable ‘maintenance mode’, adadmin will execute the script.
enable maintenance mode:
@>/ad_top/patch/115/sql/adsetmmd.sql enable
disable maintenance mode:
@>/ad_top/patch/115/sql/adsetmmd.sql disable
to verify if the environment is in maintenance mode or not execute following script.
select fnd_profile.value('APPS_MAINTENANCE_MODE') as status
from dual;
if the status
“maint” =       maintenance mode has been enabled and the users will not be able to login.
“normal”       =       maintenance mode has been de-activated and the users will be able to login.
how to enable the maintenance mode
set the environment variable on application instance.
run the ad administration utility by typing adadmin on console window. chose option 5 from the selection menu.
1.generate applications file menu.
2.maintain applications file menu.
3.compile/reload applications database entities menu.
4.maintain applications database entities menu.
5.change maintenance mode.
6.exit ad administration.

Tuesday, 21 August 2012

Oracle apps 11i after clone: Internal Server Error When try to see any log file for concurrent request

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Actually the solution was to copy and relink the FNDFS from the production to clone.

Don't forget to run the adrelink after each clone !!

roubleshooting Issues with Report Review Agent (FNDFS) in APPS 10SC [ID 98093.1]

Mailer Fails to Send Email Notifications after cloning

After cloning, mails were not floating through workflow mailer although all agent listener and notification mailer was up and running.

After some time we checked latest mailer log FNDCPGSCXXXXX.txt at $APPLCSF/$APPLLOG.
Below error was their in logs:-
'Problem obtaining the HTML content Unable to invoke method HTTPClient.HTTPConnection.Get caused by: Connection refused'

what i got to know after bit of investigation is at the time we brought down source instance for cold back up, some of the workflows were in queue and they might be using source instance webserver address. After clone Since the mailer still had some events with the old url in the queue, the mailer fails with connection refused error and goes down after 10 attempts.

Solution is to purge the wf_notification_out outbound message queue and repopulates from the WF_NOTIFICATION table.

PFB complete solution:-

1. Stop the Workflow mailer.

2. Purge the wf_notification_out queue and recreate it out of the wf_notifications table by executing:
cd $FND_TOP/patch/115/sql
sqlplus APPS/ @wfntfqup.sql APPS APPLSYS

3. Start the mailer

4. Retest the issue by submitting the same workflow again.

Monday, 20 August 2012

Current workflow mailer log file location

select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','maile r container','WFALSNRSVC','listener container',fcq.concurrent_queue_name),
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;

Sunday, 19 August 2012

oracle apps after clone HTTP internal server error 500

Cannot Access Pls Pages: 'mod_security: Access denied with code 400' [ID 389558.1

Kill a list of unix process

kill -9 'ps -ef | grep Apache | grep applupgr | grep -v grep | awk '{print $2}''

Request URI:/OA_HTML/AppsLocalLogin.jsp java.lang.NoClassDefFoundError

Oracle Applications login page sometimes will have the Exception: java.lang.NoClassDefFoundError.
Request URI:/OA_HTML/AppsLocalLogin.jsp

The workaround used to solve this Exception: java.lang.NoClassDefFoundError was to rebounce the Apache server in Oracle Applications. Aside from rebounce the Apache server in Oracle Applications, you have to remove the server side cache as well.
Stop the Apache Web Listener
$ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
$ ./ stop
Rename the Apache server side cache _pages folder to another name
$ mv $COMMON_TOP/_pages $COMMON_TOP/_pages_backup
Start the Apache Web Listener
$ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
$ ./ stop
For a permanent solution to solve java.lang.NoClassDefFoundError:
This error was caused by the Distributed JVM Cache was enabled and it can be solve by disabling Distributed JVM Cache is achieved by changing “LONG_RUNNING_JVM=” from “true” to “false” in the
This is controlled by AutoConfig parameter “s_long_running_jvm”. You can change the setting “s_long_running_jvm” in $CONTEXT_FILE and run the Autoconfig to reflect the setting. Please do refer Metalink for the changes you going to make and please test it before apply it to any Production server. Monitor the frequency of java.lang.NoClassDefFoundError after deploying the solutio

Saturday, 11 August 2012

How to find ICM log on Oracle Apps 11i and R12

All Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.The following bellow options are available to get the latest log files.

Login to Apps User and source environment file
ls -lrt *$TWO_TASK*
  • Internal Concurrent Manager Log:_MMDD.mgr
Here you can see other list of log files which are related to concurrent mangers.The name conversation for the concurrent manger log files are
  • Standard manager log: w.mgr
  • Transaction manager log: t.mgr 
  • Conflict Resolution manager log: c.mgr
Where: is the concurrent process id of the manager
Log-in to the Apps User
Run Source environment file
Connect to sqlplus and run this query
SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'
AND fcp.process_status_code = 'A';
Sample Output:
Log in to Sysadmin Responsibility
Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.

How to find log files locations in 11i and R12

The following log files location could help you to find-out issues and errors from your application 11i instance.

Database Tier Logs are

Alert Log File location:

Trace file location:

Application Tier Logs

Start/Stop script log files location:

OPMN log file location

Apache, Jserv, JVM log files locations:

Concurrent log file location:

Patch log file location:

Worker Log file location:

AutoConfig log files location:
Application Tier:

Database Tier:

Error log file location:
Application Tier:

Database Tier :

In Oracle Applications R12, the log files are located in $LOG_HOME (which translates to $INST_TOP/logs)
Below list of log file locations could be helpful for you:

Concurrent Reqeust related logs
$LOG_HOME/appl/conc - > location for concurrent requests log and out files
$LOG_HOME/appl/admin - > location for mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN)
$LOG_HOME/ora/10.1.3/Apache - > Location for Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee - > location for j2ee related log files
$LOG_HOME/ora/10.1.3/opmn - > location for opmn related log files

Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)

Startup/Shutdown Log files location:

Patch log files location:

Clone and AutoConfig log files location in Oracle E-Business Suite Release 12 

Logs for the are located: 
On the database tier: 
RDBMS $ORACLE_HOME/appsutil/log/< context >/StageDBTier_< timestamp >.log 

On the application tier: 
$INST_TOP/admin/log/StageAppsTier_< timestamp >.log 

Where the logs for the are located? 
On the application tier: 
$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log 

Number of Visitors