Recently, one developer came to me complaining about error ORA-17410. They are using JDBC thin to connect to Oracle databaes. The error was interesting because the application was executing a MERGE statement, which was used to compute quarterly commission fee. Those data would already have been computed on a daily basis and the task would… Continue reading JDBC driver and JDK compatibility issue caused MERGE to fail
NOTE:35217.1 – When do Snapshot Logs get Purged Materialized View Refresh : Log Population and Purge (Doc ID 236233.1) What to do When Materialized View Log is not Cleared Automatically After a Fast Refresh? (Doc ID 727632.1) https://docs.oracle.com/cd/B28359_01/server.111/b28326/repmview.htm#i34980
We encountered the well-known ORA-1555 error recently : Fri Jun 23 21:07:02 2017 ORA-01555 caused by SQL statement below (SQL ID: a520vskru5tmy, Query Duration=3304 sec, SCN: 0x010a.b517cc1a): SELECT BOND_REPO_DEAL_F.BOND_REPO_DEAL_ID … Query Duration is 3304 seconds, wow! But when I checked the AWR report, it states the Elapsed time for the SQL is only 19.29 seconds.… Continue reading ORA-01555 encountered with huge elapsed time discrepancies in alert and awr
FAQ: 12c Grid Infrastructure Management Repository (GIMR) (Doc ID 1568402.1) How to Move/Recreate GI Management Repository to Different Shared Storage (Diskgroup, CFS or NFS etc) (Doc ID 1589394.1) How to relocate CHM repository and increase retention time (Doc ID 2062234.1)
9. Configure database 9.1 Configure redo log files By default, dbca will only create 2 redo log groups for each thread and the size of each redo log file is only 50M. We need to increase redo log file size to 1G and redo log group to 5 for each thread. — add 3 additional… Continue reading Step-by-step guide on installing Oracle RAC 184.108.40.206 on RHEL7.3 (part VI)
7. Create ASM Disk Group # as grid on the 1st node asmca & 8. Create RAC database # as user oracle on the 1st node dbca & Since we’re creating CDB, the default modules could not be deselected. You can set SGA and PGA according to your physical memory.
6. Upgrade GI and Database software It is recommended to install the latest bundle patch for GI and database. According to Quick Reference to Patch Numbers for Database/GI PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1) I chose 220.127.116.11.170117, patch No. 24968615. 6.1 Upgrade opatch (as grid and oracle on each node) unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME… Continue reading Step-by-step guide on installing Oracle RAC 18.104.22.168 on RHEL7.3 (part IV)