Posts

Breaking the Read-Only Barrier: How to Run DML on Oracle Active Data Guard

Image
                                                    ADG_REDIRECT_DML Introduction Historically, Active Data Guard (ADG) was strictly read-only. If an application needed to perform even a tiny "Insert into Audit_Log," it had to connect to the Primary. The  DML Redirection  feature marks a significant shift in ADG capabilities.  ADG_REDIRECT_DML allows the standby to accept DML, transparently redirect it to the Primary, and wait for the apply service to bring the change back. This functionality effectively eliminates the 'look-but-don't-touch' limitation, providing a seamless experience for read-mostly applications that require occasional data persistence. Prerequisites & Environment Oracle Database Version: 19c or higher. License: Active Data Guard option. Mode: Standby must be in READ ONLY WITH APPLY (Active Data Guard). Primary Databa...
Post a Comment
Read more

Unable to connect to PDB in Oracle 12.2

Image
Unable to connect to PDB  as a system in Oracle 12.2 Issue :  When we are trying to connect as system user it is hanging forever and not allowing new connections. (No issues observed with existing application connections) Error: Errors in alert log file Errors in file /u01/app/oracle/diag/rdbms/XXXXX/XXXXX/trace/xxxxx_ora_127384.trc: ORA-04088: error during execution of trigger 'SYS.BLOCK_TOOLS_FROM_PROD' ORA-00604: error occurred at recursive SQL level 1 ORA-20000: Development tools are not allowed here. ORA-06512: at line 13 2020-06-10 12:31:44.388000 +00:00 WARNING: CLMN has failed to cleanup a dead process for 2400 attempts 2020-06-10 08:38:11.555000 +00:00 WARNING: CLMN has failed to cleanup a dead process for 1000 attempts Errors in file /u01/app/oracle/diag/rdbms/xxxxx/xxxxx/trace/xxxxx_clmn_114254.trc  (incident=8918402) (PDBNAME=CDB$ROOT): ORA-00700: soft internal error, arguments: [ksuxdl: cleanup failures], [0x351C23FC0...
Post a Comment
Read more