V$DIAG_ALERT_EXT and equality conditions Mustafa, 2021-08-302021-11-18 Hello, I don’t know if this is a bug but something small took my attention. Codes below are run on 19.8 and 19.12 versions. Lately, I was working on alert log messages and to do that I use V$DIAG_ALERT_EXT view which is a row by row representation of alert log… Continue Reading
Blockchain vs Immutable tables Mustafa, 2021-08-202021-10-26 Hi, as you know 21c is here for linux and some new features are (as always) pretty exciting. two of them are Blockchain and Immutable tables. Let’s explain and test. first of all, those are new features for 21c but they are backported to 19c. at 19.10 you are able… Continue Reading
ORA-00600 [kzan_open_osfile:ksfdread] while querying/purging unified audit Mustafa, 2021-08-08 Hi everyone, Lately, I hit and ORA-600 while querying unified_audit_trail on 19.8 Oracle database and same thing happens if you want to purge audit data too. the exact error message is: ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], [] Normally, I… Continue Reading
X Forwarding for an Oracle DBA Mustafa, 2021-08-022021-08-02 Hi, It’s been a long time. I want to write something about X Forwarding. you might feel more comfortable to use a GUI instead of silent installations sometimes. if you are connecting to a linux server remotely then you must enable X Forwarding to enable GUI for Oracle product like… Continue Reading
Create a Clone DB from Backup on the Same Server (or remote) Mustafa, 2021-04-262021-04-27 Hi, I wanted to create a post series about cloning/duplicating database on the same or remote servers. There are so many options and combinations about this like rman duplicate database with/without target/source db connection, rman restore using backups, ASM to OS or OS to ASM, same server or remote server,… Continue Reading
Pragma UDF & Deterministic Mustafa, 2021-04-09 Hello everyone, I wanted to write about something simple and can improve the performance of your sql statements. Unfortunately, many database developers use too much plsql function in their SQL statements. I say too much because if you learn more about the SQL, you will use less plsql. SQL is… Continue Reading
PLSQL and Flashback Data Archive Problems. Mustafa, 2021-01-302021-01-30 Hi, I have written about flashback data archive before. if you didn’t read please check these post first. https://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ https://mustafakalayci.me/2020/09/10/flashback-data-archive-problems/ I’ve already mentioned about some problems on my second post but these are not kind of problems which will stop your work. The problem I am about talk is that… Continue Reading
ORA-24244: invalid host or port for access control list (ACL) assignment Mustafa, 2020-12-24 Hello everyone, So you wanted to migrate your ACLs to another database or you are trying to add a new acl entity but you got ORA-24244. There are many reasons for that error unfortunately. I wish Oracle provides us more detail about what is the error but I wanted to… Continue Reading
export import ACL & ORA-24244 error during import Mustafa, 2020-12-16 Hello everyone, it’s been a while since my last post. So, I wanted to write about export and import ACL privileges. They always become a pain (at least for me). after 12c, Oracle introduce us a new and easy way of ACL copying from db to db. export&import. so here… Continue Reading