Tag: Oracle 18c

Big Savings on Oracle REDO Via Temp UNDO

oracle redo

Reduce the REDO generation in your Oracle database by setting one parameter.

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 >

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 While I realize most clients are no... Read More >

How to install 18c Grid Infrastructure in Silent Mode on Linux 7

This blog post will show you how to install 18c Grid and upgrade to 1. Download the 18c binairy and Apr, 2019 PSU: 18c Grid: https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_grid_home.zip Apr 2019 PSU: https://updates.oracle.com/Orion/Services/download/p29251992_180000_Linux-x86-64.zip?aru=22869122&patch_file=p29251992_180000_Linux-x86-64.zip OPatch https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=22870225&patch_file=p6880880_180000_Linux-x86-64.zip 2. Prepare OS for Oracle installation,…

Read More >

Troubleshooting a failure when upgrading to Oracle 18c

WhenI was upgrading Grid to 18c, the final step was to run gridSetup.sh -executeConfigTools, which failed. Unfortunately, the error provided was not very descriptive or useful. In this post, I will demonstrate how I went about troubleshooting the failure. To…

Read More >

Shutdown while upgrading to 18c

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

Read More >

How to fix the skip scan bug in 18c

A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip scan over range scan. I’ve checked what’s going on, and it happens to be a known bug. Here’s a slightly simplified test case: We have…

Read More >