Month: February 2021

Driver has suspect GRO implementation, TCP performance may be compromised

If you scan your redhat linux system log or use "dmesg" to check, you may running into the following message like me checking a performance issue when restoring a database over the network: [436018.459356] TCP: ens192: Driver has suspect GRO implementation, TCP performance may be compromised. That sounds scarier than it is. According to RedHa's … Continue reading Driver has suspect GRO implementation, TCP performance may be compromised

ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination

In my last post about ORA-16792, I said I didn't find anything wrong and the issue was gone after I disabled/enabled the configuration. Actually there was a problem and I ran into it after I opened the standby database and did some queries. I shutdown the database and could not start it: 14:50:08 SQL> startup … Continue reading ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination

ORA-16714: the value of property is inconsistent with the database setting

If you see this ORA-16714 error when checking ODG configuration, check the primary & standby database in DGMGRL and it will show you which property is having the issue. DGMGRL> show configuration; Configuration - DG_PROD Protection Mode: MaxPerformance Members: PROD1 - Primary database Warning: ORA-16792: configurable property value is inconsistent with database setting PROD2 - … Continue reading ORA-16714: the value of property is inconsistent with the database setting

Strange issue PL/SQL: SQL Statement ignored & ORA-00942

I have a database just upgraded from 12c to 19c. Today I noticed there were some objects (packages & triggers) in invalid status. When I tried to compile one of simple trigger and I got the following errors: SQL> alter trigger RELEASE_LOCK compile; Warning: Trigger altered with compilation errors. SQL> show error Errors for TRIGGER … Continue reading Strange issue PL/SQL: SQL Statement ignored & ORA-00942

Interesting fact — having space within data file name

Today I noticed an interesting fact about Oracle data file by accident -- a data file name can cantain white space! I added a few temp data files and then I thought that's more than enough. So I tried to drop and got the following error: SQL> alter database tempfile '/dbase/system/PROD/temp15.dbf' drop INCLUDING DATAFILES; alter … Continue reading Interesting fact — having space within data file name