Oracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****AhAhpassword-changed*** -d /export/home/oracle/scripts -l /export/home/oracle/scripts/logs -b give-write_ps give-write_ps.sql -u username/password…
Read MoreHere is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_modifications where table_owner<>’SYS’ and EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, ‘DD-MON-RR’)) > 2010 order by 6;…
Read MoreCREATE 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 More