On this activity we are going to create a DB in silent mode.We don’t have GI on this environment and since software has been only released for Engineered Systems, we need to create with “_exadata_feature_on=true” DB created: Note that on 23ai, you are forced to have PDB’s. There might be some trick to be a... » read more
On this activity we are going to setup Dataguard at PDB level.Here both DB’s are running on the same host but on different ORACLE_HOME.This was first introduced on 21c and we are going to follow the Oracle documentation from here. First DB (as SOURCE DB): Second DB (as TARGET DB): 1:- Both DB’s need to... » read more
On this activity we are going to install and create a new 23ai DB on a standalone server (Virtualbox). We are going to download the software for Exadata from Software Clod Delivery. There is the option for Grid Infrastructure, but so far not able to overcome the fact I’m trying to install on a non-engineered... » read more
This is an easy one: I have been requested to show how Application could make use of Oracle Wallets instead of hard copying user password on the code, so here is it: 1:- Create a user on target DB: 2:- Create WALLET on App server, this case we will use directory /u01/admin/orcl/wallet: 3:- Update tnsnames.ora... » read more
These are the steps to install Oracle 19c Software. We are going to create ORACLE_HOME=C:\app\ORACLE\product\19c\dbhome_1 STEPS: 1:- Download software from here 2:- Unzip downloaded file on path C:\app\ORACLE\product\19c\dbhome_1 3:- Execute setup.exe from C:\oracle\app\product\19c\dbhome_1 4:- Follow GUI: That’s it, Oracle 19c Software installed
We are going to create an environment to have an Oracle database in Failover Cluster Manager. To have this, we need 3 Windows Servers ( 1 Working as controller) Server Name Public IP: Private IP: ORACLE_HOME win-rac1 192.168.56.151 192.168.10.151 C:\oracle\app\product\12.1.0\dbhome_1 win-rac2 192.168.56.152 192.168.10.152 C:\oracle\app\product\12.1.0\dbhome_1 win-rac-control 192.168.56.153 192.168.10.153 For how to install Windows VM’s here (in... » 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
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
This is an easy one that will save you going through alert logs.