OGG-02544 Unhandled Error (ORA-00904: : Invalid Identifier) WARNING OGG-02544 Unhandled error (ORA-00904: : invalid identifier) while processing the record at SEQNO 219, RBA 83837638 in Integrated mode. REPLICAT will retry…
Read MoreOGG-06601 Mismatch Between The Length Of Seqno From Checkpoint (9) And Recovery (6) For Ext Trying to read trail file which uses 6 digit checkpoint with version 12.2. Version 12.2…
Read MorePlease find the below query to check. SQL>set pages 1000 SQL>set linesize 100 SQL>column APPLIED_PATCH_ID format 9999999999 SQL>column PATCH_NAME format a16 SQL>column CREATION_DATE format a16 SQL>column BUG_ID format 9999999999 SQL>column…
Read MoreI am doing an audit and I need to be able to track all failed login (logon) attempts. Because the user never gets logged-on to Oracle The Oracle auditing utility…
Read MoreOracle Goldengate supports the replication of data across various heterogeneous platforms. The Goldengate replication topology includes the capture and transfer of the extracted data from the source database, across to…
Read MoreSELECT Substr(df.tablespace_name,1,20) “Tablespace Name”, Substr(df.file_name,1,40) “File Name”, Round(df.bytes/1024/1024,2) “Size (M)”, Round(e.used_bytes/1024/1024,2) “Used (M)”, Round(f.free_bytes/1024/1024,2) “Free (M)”, Rpad(‘ ‘|| Rpad (‘X’,Round(e.used_bytes*10/df.bytes,0), ‘X’),11,’-‘) “% Used” FROM DBA_DATA_FILES DF, (SELECT file_id, Sum(Decode(bytes,NULL,0,bytes)) used_bytes…
Read MoreFind top pids of oracle user $top -u oracle Enter the os pid and find the sql id select sid, sql_id from v$session s, v$process p where s.paddr = p.addr…
Read More