For EBS Concurrent Requests, often we find the concurrent program is not completing within the expected time. In this case we can investigate the performance problems of the program with a database session trace while the program is running under the Concurrent Processor. Listed below are the steps to configure the trace of the concurrent program. 1) Connect into database as APPS user, execute command bellow. A) -- Activate Trace from concurrent. update apps.fnd_concurrent_programs set enable_trace='Y' where application_id=30000 and CONCURRENT_PROGRAM_ID = '57181'; commit; B)- Check Trace Location. SELECT 'Request id: ' || request_id, 'Trace id: ' || oracle_process_id, 'Trace Flag: ' || req.enable_trace, 'Trace Name: ' || dest.VALUE || '/' || LOWER (dbnm.VALUE) || '_ora_' || oracle_process_id || '.trc', 'Prog. Name: ' || prog.user_concurrent_program_name, 'File Name: ' || execname.execution_file_nam
Posts
EM 13c, 12c: How to Configure the Enterprise Manager Management Service (OMS) with Secure Socket Layer (SSL) Certificates
EM 13c, 12c: How to Configure the Enterprise Manager Management Service (OMS) with Secure Socket Layer (SSL) Certificates (Doc ID 2202569.1) To Bottom In this Document Purpose Details A. How to determine the certificates used by the OMS B. How to create a wallet and import third-party certificates to the wallet C. How to secure/renew EM Cloud Control Console Access with third-party certificates D. How to secure the OMS using third-party certificates E. How to import third-party / custom SSL certificates used at SLB to the OMS and Agents F. How to renew third-party certificates used with the OMS G. How to increase the keystrength and signature algorithm of certificates used with the OMS H. How to rollback the OMS to default EM demo certificates(Also applicable when OMS certificates are Expired) References APPLIES TO: Enterprise Manager Base Platform - Version 12.1.0.2.0 and later Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later Information in this
EM 13c: How To Renew Oracle Management Server (OMS) And Agent Server Default Certificate Expired?
EM 13c: How To Renew Oracle Management Server (OMS) And Agent Server Default Certificate Expired? (Doc ID 2801064.1) To Bottom In this Document Goal Solution References APPLIES TO: Enterprise Manager Base Platform - Version 13.2.0.0.0 and later Information in this document applies to any platform. GOAL Steps to change Oracle Management Server (OMS) and Agent server default certificate expired for an EM 13c installation. Steps applicable only for Oracle Enterprise Manager (EM) Cloud Control default certificate expires For Custom certificate expired follow the below Note Note: 2202569.1 EM 13c, 12c: How to Configure the Enterprise Manager Management Service (OMS) with Secure Socket Layer (SSL) Certificates SOLUTION Following steps can be executed to renew Oracle Enterprise Manager (EM) Cloud Control default certificate: 1. Take a backup of EM (OMS and Repository DB) before executing steps below. 1a. Start Admin Server cd <OMS_HOME>/bin emctl stop oms -all -force emctl start om