After applying the binaries for RU 19.28 (Jul 25), we had datapatch failing with this error: There was nothing very clear on PDB_PLUG_IN_VIOLATIONS, but checking DB alert log, we could see this error on PDB$SEED: After we added a temp file, datapatch ran without issues.
This exact scenario is on a Solaris sparc server without GI/HAS where we upgraded from 19.27 to 19.28. and a DB with CDB/PDB’s. Binary patching all went ok as expected: But at the time of running datapatch, it fails with this error: Nothing really clear on PDB_PLUG_IN_VIOLATIONS: Issue looks very similar to “19.28 OJVMRU Datapatch... » read more
Recently we had some issues running opatchauto analyze failing with this error: We even had error running any opatch command: Since we wanted to automate the process of patching doing it hands off, we wanted to rely on opatchauto so created an SR, on which after suggesting not great options (like copy the inventory from... » 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:
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
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