We had someone complaining saying why v$flash_recovery_area_usage is empty when DB is in archive log mode? Should not list everything there? This has been replicated on 26ai, but it is valid on previous releases. Answer is simple, log_archive_dest_1 is not set properly, lets replicate on a test db…. Initially ok, right? well….. Since this is... » read more
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
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
List of all the articles I created for Oracle 23ai/26ai.
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
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
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
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
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