Blog – Keyword: Oracle


  • Using Enterprise Manager to gather extra DB information using Monitoring Extensions

    My customer wants to get some specific information from each database on regular basis. I was sure to be able doing that with Enterprise Manager, so the information would be stored in the repository. Here how it is done: On OEM (version 13.5 here), as a high privileged user go to Enterprise Menu – Monitoring…

  • New mandatory unified audit policy on 19.26

    This feature was just backported from Oracle 23ai. The new ORA$MANDATORY audit policy was added with the Oracle 19.26 RU. This policy is not visible at UNIFIED_AUDIT_POLICIES or AUDIT_UNIFIED_ENABLED_POLICIES. After patching the database to 19.26, then you see entries on UNIFIED_AUDIT_TRAIL: The actions that are audited by ORA$MANDATORY policy are described on Oracle 23ai documentation. What…

  • How to change Goldengate Adminclient default editor permanently

    Goldengate Microservices architecture replaced the “ggsci” tool with “adminclient”. This new client has few limitations and does not work well with “rlwrap” – my favorite tool to have history between sessions. The Adminclient provides some options you can easily change after starting the tool: However to keep the settings across sessions it is not very…

  • 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. 🙂