Tag: oracle 19c

Enable Oracle Flash Cache on Red Hat Linux

The Oracle Smart Flash Cache feature was originally introduced in the 11gR2 version of Oracle Database. It works as an extension of the buffer cache in System Global Area (SGA). With this feature, instead of removing least recently used (LRU)…

Read More >

How to Make Oracle Use the Correct Index

Learn a simple method to make Oracle use the index required for a SQL Query.

Read More >

Oracle E-Business Suite Database Upgrade to 19c

Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We’ve been seeing an uptick in customer requests to upgrade their E-Business Suite (EBS) database to 19c. Multiple factors seem to be driving this increase,…

Read More >

How to Fix the Status of the Oracle GI CRS After a Failed Upgrade

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on April 29, 2019. Blogger’s Note: The information in this…

Read More >

Silent Rollback From an Out-of-Place Patching For Oracle 19c GI

My last post dealt with how to do an out-of-place patching for Oracle GI (Grid Infrastructure). The next thing I wanted to try was the rollback procedure for this methodology. I searched in MOS (My Oracle Support) and the Oracle... Read More >

Silent Out-of-Place Patching For Oracle 19c GI

I am going through a process of patching an Oracle Grid Infrastructure (GI) from 19.6 to 19.8 (Patch 31305339) and I wanted to try out-of-place patching (OOP). Since I didn't have access to the GUI (graphical user interface) environment, I... Read More >

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing some testing in that version, then patching to 19.6. The installation and the tests went fine. Next, I proceeded to... Read More >

Resolving Error ORA-28353: Failed to Open Wallet

Full disclosure: this is a post I've had in draft mode for almost one and a half years. I noticed the original error after applying the October 2018 bundle patch (BP) for 11.2.0.4. While I realize most clients are no... Read More >

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it’s useful to understand the Data Guard command-line interface (DGMGRL) which enables you to control and monitor a Data Guard configuration from the DGMGRL prompt…

Read More >

While Upgrading from GI 12c to 19c, +asm1(19c) Cannot Detect +asm2(12c)

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running the upgrade on Node 1, an issue occurred where +asm1(19c) could not detect +asm2(12c). The information below describes the actions I performed to... Read More >
Page 1 of 212