Yesterday I was upgrading a DB on our production environment and I was facing this error while running the deploy: We downloaded the latest autoupgrade version as recommended and used this simple config file: Prechecks/Analyse did not have any issues: Still, when we tried to run the deploy, we were getting this error: If we... » read more
I faced this error a few times so I though to write a quick note for an easy fix. While you try to start DB, it gets this error. I know… this is 10g, but sometimes Clients do not want to upgrade and you have to deal with it… If you check alert log, you... » read more
This post will go though the all the steps needed to upgrade a 12.1.0.2 database to a 19c using AUTOUPGRADE. Source DB: 1:- Create 19c directory and copy software: 2:- Create response file for a silent 19c Instalation: 3:- Execute 19c pre-requisites: 4:- Install 19c software in silent mode: 5:- Execute root.sh (as root): 6:-... » read more
This post will go though the steps needed to upgrade an Oracle Grid High Availability Services (HAS) from version 12c (12.1.0.2) to 19c (19.13.0) on a Linux environment. 1:- As per document Doc ID 2539751.1, Patch 28553832 is a prerequisite for both GI and DB Upgrade. Here the steps to apply Oct 2021 PSU which... » read more
This activity is part of a GI upgrade from 12.1.0.2 to 19c, in which we need to apply latest PSU first, so here are the steps: 1:- Patches available here: 2:- (as ROOT) Update OPACH version to latest available. (p6880880_122010_Linux-x86-64.zip) 3:- (as ROOT) Run prepatch script. (RDBMS instances should be stopped first) 4:- GI patching:... » read more
Setting up Network Encryption in our Oracle environment is very easy, we just need to add these lines to the sqlnet.ora on server side: Ideally, on the client side we should add these too: But since ENCRYPTION_CLIENT by default is ACCEPTED, if we see this chart, connection would be encrypted (ACCEPTED – REQUESTED case) Lets... » read more
We had this error while trying to open a DB: Digging a bit on the enviroment, we noticed server had a power cut and DB did not stop gracefully. This is how we fixed: 1:- Start DB in mount and list log files: 2:- Recover Database: (we need to input the failed log file): 3:-... » read more
The reason to trace the CBO is to understand why the Optimizer made some decisions. In this example we are going to see why same query sometimes uses an index and others it doesn’t, same example was explained HERE It is always useful to have a “GOOD” and “BAD” execution, this way it is easier... » read more
You might face this question if you are going though job interviews. and these are some cases where the Optimizer thinks going for a full table scan is better than index scan. 1:- The selectivity of the records is very high: We have this table and range of contents: We have an index and it... » read more
On this activity we are going to generate snapshots on an active standby so we can be able to create AWR reports. This is our setup: We need to perform the following steps to enable AWR reporting from a physical standby database. 1:- Unlock SYS$UMF user and reset the password. SYS$UMF account is used to... » read more