Posts

EM 13c, 12c: How to Configure the Enterprise Manager Management Service (OMS) with Secure Socket Layer (SSL) Certificates

Image
  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?

Image
  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

Performance of concurrent request

 Performance of concurrent request can be tracked in many ways. Please perform the below steps and provide the output to the cases 1. Check the SID of the concurrent request using query: SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id FROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_processes b,v$process c,v$session d WHERE a.controlling_manager = b.concurrent_process_id AND c.pid = .oracle_process_id AND b.session_id=d.audsid AND a.request_id =&req_id AND a.phase_code = 'R'; 2. Get the row fetched using the SID from step 1. column name format a30 word_wrapped column vlu format 999,999,999,999 select b.name, a.value vlu from v$sesstat a, v$statname b where a.statistic# = b.statistic# and sid =&sid and a.value != 0 and b.name like '%row%' 3. Check Database session status and what it is running set echo off set linesize 132 set verify off set feedback off set serveroutput on; declare SID number := 0 ; SERIAL number := 0 ; usern