Oracle 26ai: How to create DB in silent mode
On this activity we are going to create a DB in silent mode on a single server with ASM (GRID). That’s it! For a list of 26ai articles, go to HERE
Oracle 26ai: How to install sample schemas
On this activity we are going to install the sample schemas on a 26ai DBFirst we need to download file from here: https://docs.oracle.com/en/database/oracle/oracle-database/26/comsc/installing-sample-schemas.html unzip and go to directory you want to install: Connect to the PDB and run the install (it will ask for HR password): That’s it! For a list of 26ai articles, go... » read more
Oracle 26ai: how to guides
List of all the articles I created for Oracle 23ai/26ai.
Oracle 26ai: How to install Oracle 26ai GI (HAS) using Native ASM
After a very, very long wait, finally onpremises has been released.As a starting point, we are on a Oracle Linux 8.10 (x86_64) server on kernel 5.15.0-316.196*, with at least 16G of swap. Lets install few bits and reboot: Make sure oinstall has assigned oracle in /etc/group file. This might not give you any issues on... » read more
DGMGRL: Warning: ORA-16792: configurable property value is inconsistent with database setting
You will be this error when you change a parameter inside the DB and not on dataguard broker (if exists) or the other way around. To know which parameter is having issues, run this: You can change or on the DB, of on the broker,. In this case we are changing on broker side: And... » read more
Oracle GI 19c: How to remove/drop disk in EXTERNAL redundancy
I was never 100% clear to me you could remove a disk from a diskgroup wtih EXTERNAL redundancy without having data loss, so let’s to a test. We are going to do it on Oracle GI 19c, but I don’t see why it should not work on older versions. But please always try to replicate... » read more
How to install Oracle 19c GI (HAS) using Oracle ASM filter driver on Apple Silicon ARM / AARCH64
I have been trying to install Oracle 19c GI on a Oracle Linux 8 via VMware on a M4 chip (aarch64 architecture) using THIS guide, but I keep getting these errors: So decided to create a new guide for Apple Silicon. As a starting point, we are on a Oracle Linux 8.10 (AARCH64) server, with... » read more
Oracle 23ai: How to create DB in silent mode
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
Oracle 23ai: How to configure Dataguard PDB
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
Oracle 23ai: How to install RDBMS software (GUI)
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