Oracle 26ai: how to guides
List of all the articles I created for Oracle 23ai/26ai. Post Views: 35
Oracle 26ai: How to install Oracle 26ai GI (HAS) using Native ASM
After a very, very long wait, finally onpremisses 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
Oracle 19c: Steps for modifying SCAN NAME in oracle RAC
On this activity we are going to rename the scan name on a Oracle 19c RAC environment.We don’t want to change the IP’s, just the name. ORIGINAL NAME: CLUSTER-ORA-SCAN2 TARGET NAME: CLUSTER-ORA2-SCAN First, you need to make sure new SCAN NAME is pingable from all RAC servers (to avoid name resolution issues) 1:- Check current... » read more
TLS for Oracle Real Application Cluster (RAC)
Since there is not much out there in terms and easy guide to follow, on this activity we are going to configure an Oracle RAC cluster to allow TLS encrypted connections.Because SCAN listeners redirect you to the local listeners on each server, we also need to setup the local listeners. Here we are going to... » read more
Oracle 19c: Datapatch Fails with ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
Today after patching our databases, datapatch was failing with these errors: I found few suggestions of deinstall/reinstall OLAP, run few scripts, etc etc, all very destructive. At the end, issue was just a missing grant: So the fix was just: After this, datapatch runs ok: Post Views: 734
Oracle 19c: Datapatch fails with Unsupported named object type for bind parameter at….
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. Post Views: 1,921
Oracle 19c: Datapatch Fails with ORA-29532 after applying 19.28 RU
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
Oracle 19c: opatchauto apply -analyze fails with OPATCHAUTO-68061
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
Fedora 42: Kernel Panic After Upgrade
Recently I upgraded my fedora server from version 40 to 42 and upgrade: sudo dnf upgrade --refreshsudo dnf system-upgrade download --releaserver=42sudo dnf system-upgrade reboot But on the last reboot post upgrade, error and kernel panic: initramfs-6.15.7-200.fc42.x86_64.img not found error! Apparently, upgrading to Fedora 42, and for every kernel update afterwards, initramfs is not created and... » 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