It seems like there are not many Oracle Restart environments (or there are but Oracle doesn’t pay too much attention to them). Otherwise, I can’t explain why I couldn’t find too much information about it in the documentation when it comes to upgrades.
So, to help all of you out there that do use it, here are some notes about the upgrade process.
Continue reading “Upgrade Oracle Restart to 18c”
One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version is to create silent installation scripts. These scripts are for Windows and used for demo and testing environments. I did that for 11.2 and for 12.1 and now it’s 12.2’s turn.
Continue reading “Using DBCA in Silent Mode”
Lately I started patching a client’s database (22.214.171.124) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time we hit quite a lot of different bugs. When we planned this PSU (we installed the bundle patch version), we added about 7 one-off patches (some are recommended by Oracle and some we had to add because the bugs affected us quite badly).
Continue reading “One-off Patch Frustration”
A few months ago we hit an Oracle bug related to streams replication crash after creating an index (bug 21320182). There is a patch so we installed the patch in test and it seemed to solve the problem, but we never patched the production.
Today we hit this issue in production after creating an index we needed. It’s important to say that we wanted to patch the prod a while ago, but we didn’t get approval for maintenance window.
Continue reading “Researching a Bug”
This week I worked on a messy patch. I have a RAC environment with 126.96.36.199 and an old PSU and all kind of one-off patches and I wanted to install the latest PSU (180417). It sounds simple, but it’s not so simple. The thing is that I have 4 database running from the same ORACLE_HOME, all of them are RAC, while some of them are stand-alone, some are primary for standby located on a different RAC and some are standby for a primary located on a different RAC. And the problem with that is that you cannot install a PSU on the primary first, either together or patch the standby first.
Continue reading “Datapach issues”
I wrote in the past about my frustration with Oracle support. I also hear from customers and colleagues about their frustration with Oracle support, from different reasons. People like to complain when something doesn’t work well, however, I’m writing this post to tell about excellent experience I had with the support lately.
Continue reading “Oracle Support Rocks (Sometimes)”
Oracle is using the same numbering scheme since I’ve started working with it (7.2). The 5 number scheme with the release number, patchset and PSU is quite confusing and the post I wrote about that (here) is still very popular.
Continue reading “Oracle New Version Numbering”