CREATE TABLE AUDIT_DDL ( DDL_DATE date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), IP_ADDRESS VARCHAR2(100), module varchar2(100), owner varchar2(30), type varchar2(30), name varchar2(30), sysevent varchar2(30), sql_txt varchar2(4000) ) tablespace…
Read MoreAPPLIES TO: Oracle Applications Manager – Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2] Information in this document applies to any platform. GOAL: How to clean up a failed 12.2…
Read MoreAPPLIES TO: Oracle Database Cloud Service – Version N/A to N/A [Release 1.0] Linux x86-64 SYMPTOMS: Customer tried to apply the patch from console and it was failing in two…
Read MoreIf you have already migrated to Java JRE with Oracle EBS 11i you may want to update EBS to the latest update from time to time. For example, if your…
Read MoreOptions ABANDON and RESTART adop phase=apply patches=12121212 abandon=yes Used to specify whether to restart the previous run of adop. May be useful if the previous action had an error. Note:If…
Read Moregetent passwd | grep oracle getent passwd | grep dba
Read Moreprompt ====================================== prompt ANALYZE – DATE – REGULAR TABLES prompt ====================================== col owner format a20 prompt select owner,’Tables’,trunc(LAST_ANALYZED),count(*) from dba_tables where owner not in (‘SYS’,’SYSTEM’) group by owner,’Tables’,trunc(LAST_ANALYZED) / prompt…
Read MoreScript for check all the enabled auditing on Database –Check the parameter is enabled or disable for Audit select name || ‘=’ || value PARAMETER from sys.v_$parameter where name like…
Read MoreSELECT b.request_id, a.user_concurrent_program_name, b.phase_code AS completed, b.status_code AS error, u.user_name requestor, TO_CHAR (b.actual_start_date, ‘MM/DD/YY HH24:MI:SS’) starttime, ROUND ((b.actual_completion_date – b.actual_start_date) * (60 * 24), 2 ) runtime, b.completion_text FROM fnd_concurrent_programs_tl…
Read More