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
Month: February 2021
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
A side feature from 7zip — deleting file with long file path
7zip is a decent tool when dealing with zip files, small but powerful and green! I use it almost everyday when working on Windows system. Today I learned it can used to delete files with long file path if you can not delete such files from Windows File Explorer. Windows has a maximum file path … Continue reading A side feature from 7zip — deleting file with long file path
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
Oracle patch apply order matters
Sometimes we need to apply a few patches at a time, then the order of the patches being applied matters. A few days ago I was trying to apply the database patch 31771877 to my 19C database. When checking conflicts, it failed because there is another patch 31743771 (JDK bundle patch) installed which overlays with … Continue reading Oracle patch apply order matters
Adding a column with default taking a long time?
As an application is updated to a new version, it's quite often that schema could change with additional columns on existing tables. From Oracle 11g, there is a new feature when adding a new column to a table: "When you add a column, the initial value of each row for the new column is null. … Continue reading Adding a column with default taking a long time?
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
JoeLi's TechLife 