PDB Lockdown Profiles In Oracle 12.2
ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create a…
Read MoreSGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…
Read MoreThe security certificate presented by this website was not issued by a trusted certificate authority
Issue : E-Business Suite 12.2 Applications Technology Stack, Secure Socket Layer Configuration issues . Users report receiving the below message when accessing the SSL URL for E-Business Suite via a…
Read MoreConcurrent program assigned responsibilities
SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ,fnd_concurrent_programs fcp ,fnd_concurrent_programs_tl fcpt ,fnd_responsibility_tl frt ,fnd_responsibility frs WHERE frgu.unit_application_id = fcp.application_id AND frgu.request_unit_id = fcp.concurrent_program_id AND frg.request_group_id = frgu.request_group_id AND…
Read MoreCould not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing
Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Manager was found…
Read MoreSQL Profiles & Baselines
To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2cqkk80_3455548535′,’STATUS’,’DISABLED’); exec dbms_sqltune.drop_sql_profile(‘coe_5273fz2cqkk80_3455548535’); SQL Profiles for a sql_id set lines 1000 pages 9999 col name for a30 col…
Read MoreScripts to identify performance related issues.
one script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename select to_char(sysdate, ‘yyyymmdd-hh-mi-ss’ ) filename from…
Read MoreUndo related queries
Undo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To show ACTIVE/EXPIRED/UNEXPIRED Extents of Undo Tablespace select tablespace_name, status, count(extent_id) “Extent…
Read MoreLong running requests
Long running Concurrent Requests:- 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID =…
Read MoreOracle R12 Customer TaxPayer ID Update API
/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status VARCHAR2(1), message VARCHAR2(1000)); / set serveroutput on;…
Read More