• About Me
  • Disclaimer
  • Now it’s time to change my Oracle ACE to Oracle ACE Director.

Oadba's Blog

~ The Infinite Reference for Oracle Apps DBAs

Oadba's Blog

Monthly Archives: August 2010

Concurrent Manager Scripts

21 Saturday Aug 2010

Posted by oadba in Scripts

≈ Leave a comment


Non Destructive Script to Clean Concurrent Manager Tables
CMCLEAN.sql
(<– Click here for details & download)
This script re-sets the flags for requests to completed to allow the Managers to come up

How To Re-create Concurrent Manager Views
How To Re-create Concurrent Manager Views
(<– Click here for details & download)
This script details how to Re-create the Concurrent Manager Views

Concurrent Manager Check Script
CCM.sql
(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Concurrent Manager Check Script
FNDCCMDiagnostic115.sh
(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Internal Manager Log Script
ICMLOG.sql
(<– Click here for details & download)
This script will provide the location for Retrieving the Internal Manager Log file
Concurrent Request Log Script
CMLOGS.txt
(<– Click here for details & download)
Script for Retrieving Log Files Associated to a Concurrent Request

Concurrent Request Check Script
REQCHECK.sql
(<– Click here for details & download)
Script for diagnosing problematic Concurrent Requests

Analyze Pending Requests Script
ANALYZEPENDING.sql
(<– Click here for details & download)
Script for diagnosing Pending Concurrent Requests

Analyze Request Script
ANALYZEREQ.sql
(<– Click here for details & download)
Script for Providing a Detailed Analysis of One Concurrent Request

Who Can Run which Requests
WHOCANRUN.sql
(<– Click here for details & download)
Script that lists Responsibilities that can Run a Given Concurrent Program

Concurrent Request Diagnostic Script
FNDCCMDiagnostic115.sh
(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Concurrent Request Diagnostic Script
bde_request.sql
(<– Click here for details & download)
Process and Session info for one Concurrent Request
Printing Script
FNDPrinterValidation115.sh
(<– Click here for details & download)
This script checks a customer’s Printer configuration/setup within Oracle Applications.
Report Review Agent Script
FNDValidateFNDFS115.sh
(<– Click here for details & download)
This script checks basic setup of the concurrent processing tier report review agent.

Output Post Processor Service Not Coming Up

21 Saturday Aug 2010

Posted by oadba in Troubleshooting

≈ Leave a comment


Symptoms

After cloning when GSM profile is set to N, all managers are coming up except the Output Post Processor Manager as expected, however, when GSM is set to Y, none of the managers come up.

The error seen in the Internal Manager log file is:
Could not contact Service Manager FNDSM_<SID_HOSTNAME>. The TNS alias could not be located, the listener process on <SID> could not be contacted, or the listener failed to spawn the Service Manager process.

Reason

Service Manager for the node is not running. The service manager definition is missing under Concurrent ->Manager ->Define form.
If the Service Manager is not present/defined for a particular node, then this causes all the services provided by Service Manager like OPP,WF etc.. not to work.

Solution

To implement the solution, please execute the following steps:
1. Shutdown all the services.

2. Log in as applmgr
cd to $FND_TOP/patch/115/sql
Run the script: afdcm037.sql

3. Relink FNDSM and FNDLIBR executables as mentioned below:
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

4. Run cmclean.sql

5. Start up the managers/services and retest.

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • February 2014
  • January 2014
  • December 2013
  • September 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • February 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • May 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • August 2010
  • July 2010
  • February 2009
  • January 2009

Categories

  • AD Utilities
  • Administration
  • Application Patching
  • Career Management
  • Certification
  • Cloning
  • DEMOs
  • Essential OS Commands
  • General
  • Installation
  • Monitoring & Troubleshooting
  • MOS Docs
  • My Oracle Support (MOS)
  • Oracle Cloud
  • Oracle Fusion Apps
  • Oracle Utilities
  • Oracle VM
  • Oracle Workflow
  • Patching
  • Performance & Tuning
  • RAC Specific
  • Scripts
  • Security
  • Troubleshooting
  • Uncategorized
  • Upgrades

Meta

  • Register
  • Log in

Blog Stats

  • 86,082 hits

OADBA Blog Search

August 2010
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Jul   Oct »
Locations of visitors to this page

Documentation

  • Release 12.1 Documentation Library

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Oadba's Blog
    • Join 239 other followers
    • Already have a WordPress.com account? Log in now.
    • Oadba's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar