I'll certainly install it in the next few days, there are a few features I want to experiment with and I know our developers want to check out the new JSON features. Production use? I'm not sure. It being an "innovation" release only with no extended support makes me a bit dubious.
Database release 19.7 (ie, 19c with the April 2020 RU) is at last certified for OL8, but there may be some hacking needed to get it installed.
This certification is long overdue: our security admin has been pushing for the 5.x kernel for some time, and OL7 still only supports kernel 4.x. I'm starting to move some production systems over now using the July RUR, which takes the release to 19.7.1.
Begin by installing the Oracle Validated rpm from the ol8_UEKR6 repository:
Going through the New Features guide, there is a shed load of wonderful enhancements. Then you look at the Licensing guide, and most of them require Exadata or Oracle Cloud or both.
When using RMAN to restore and recover the database, it seems to work OK - no obvious errors during the restore / recovery, as far as I can see. The issue seems to be when I try to 'alter database open resetlogs'... after this the database shuts down. At this point, I don't really care about losing some of our data, this is just a test system, my main concern is how to get the database working again.
DISKSPACE MONITORING
Written JP Vijaykumar
Date Jan 4th 2020
Modified Jan 5th 2020
**************************************************************
This article/script is provided for educational purpose ONLY.
The readers are advised to make necessary changes to the script as may be required for their use in their respective environments.
Pls test these scripts thoroughly in a lower environment, ONLY if you are satisfied with the tests' results, then ONLY use in any
Many times I've seen the question on forums "How can I move a table from one schema to another?" and the answer is always that you can't. You have to copy it. Or export/import it. Well, here's a way. It assumes that you are on release 12.x and have the partitioning option.
