Blog – Keyword: Oracle


  • Slow starting impdp from NFS Share

    Unfortunately I lost the logs for this issue, but I try to document for information. My customer has ExaCC with various 2-node clusters. He did an export from cluster1 to the ACFS mount point. All was working fine until mid December, when impdp reading a dumpfile from the NFS mount point seems hanging when was…

  • ORA-64307 when creating compressed table and /home

    My customer running on ExaCC (Exadata Cloud@Customer) was getting “ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type” on one of his test databases. I did test connecting to SYS and no problem. Then I try to do using his tablespace and indeed, I get the error: Quite going around,…

  • JumpHost Matryoshka

    My client just added an extra jumphost before arriving to the server. So now I’ve to connect, to connect, to connect and then open the connection. 🙂

  • Warning: OPatchauto ignores disabled components – possible licensing issues

    Since many years at my customer I’m using “opatchauto” to perform a out-of-place patching of Oracle Restart (GI+RDBMS). My customer is concerned about database users using not licensed options, like partitioning. To avoid it, at the installation time the partitioning option is disabled using chopt, like described at Doc ID 948061.1. Today during a check…

  • Solve “OGG-08224 Error: CONTAINER option was specified though the database does not support containers” error

    Quick post to add info about the following Goldengate error: This means that you are connected directly to the PDB, and not to CDB$ROOT. To register Goldengate 21 extracts you need to connect to the Root container with a common user. Well, in the future this is not anymore true, as new version from Goldengate…

  • Using AI to confirm a wrongly cabled Exadata switch – or how to fix verify_roce_cables.py script for Python3.

    One of the preparation steps when installing an Exadata X10M is to verify that the cabling of the RoCE switches is correctly done. The next step is to upgrade the Cisco switches with the latest firmware. During my intervention for Tradeware at the customer, the first didn’t work as the provided script is not compatible…