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
This is an easy one, but really helpful when you are on a server with a few DB’s and you want the visual piece of mind you are not doing something on the wrong database. Add the following line on file $ORACLE_HOME/sqlplus/admin/glogin.sql That’s it, now try to access DB: Post Views: 482
After a session got stuck/failed or process got killed somehow, we are getting an error trying to re-run datapatch. Checking if we have a rogue process, we can see the old PID still there: We killed, but still the same,no progress. This case we had to kill the sqlpatch pid, and after this, datapatch completed... » 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
True Cache is an in-memory, read-only replica database, similar to Oracle Active Data Guard but without disk storage. On this activity we are going to create a True Cache DB but I’m limited to the memory of my lab and I can not create a huge DB to test, so DB needs to be small.We... » read more
Today I went to start a db on my Oracle Linux 8 server and had this error: Checking the database filesystem, I see the contents are from /boot: What is happening?? This behavior matches “Oracle Linux: Kernel Block Device Names changing, Order Became Non-deterministic (Doc ID 2899803.1)” so I did: done! Post Views: 970
This is a simple example of using the AI Vector Search feature in Oracle database 23ai.We are going to use one provided by Oracle called all-MiniLM-L12-v2. This model is explained here. We are going to use it to generate vectors from plain text following this guide from here. Load the Model: download and unzip: Connect... » 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