Tag: Oracle 18c

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 18.6.0.0. 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 12.2.0.1.17: 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 >

How to fix the status of of the Oracle GI CRS after a failed upgrade

A couple of weeks ago I was working on a two-node Oracle Grid Infrastructure upgrade from 12.1 to 18.5. Everything was going great as both rootupgrade.sh scripts ran correctly, so the only thing pending to run was the gridSetup.sh -executeConfigTools …

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: [sourcecode lang=”sql”…

Read More >