What Should Change After Base DB System Clone mustafakalayci, 2025-11-12 Hi, if you are working on Oracle Cloud (which you should), you might copy your database to create a new environment. For example you can copy your DEV database as TEST. to achieve that there are many options but I will focus specific one. “Clone DB System”. In Oracle Cloud … Continue Reading
Using MFA While Logging into the Oracle Database mustafakalayci, 2025-08-14 Hello Everyone, There is another great development on security side of Oracle database users. With latest release updates (I think 19.28 and 23.9) we can now enable Multi Factor Authentication (MFA) while a user is logging into the database. That is a fantastic security feature especially for production environments. Your… Continue Reading
2 of Most Practical New Features on 23.9 mustafakalayci, 2025-08-09 Hi, with 23.9 I saw 2 beautiful enhancement in SQL. These are not “exceptional” things but their practical usage is a lot to me as a both developer and dba. 23.9 is already available on cloud base database systems. First, INSERT SET is here! one of my biggest complains in… Continue Reading
DDL Generation Failed with ORA-65047: Object SYS.KUPUTIL is invalid mustafakalayci, 2025-06-19 Hello everyone, recently I copied a PDB into another CDB and after all the actions are done, developers got error during ddl generation: ORA-65047: Object SYS.KUPUTIL is invalid or compiled with errors in root. ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPUTIL" ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 1730 ORA-06512: at "SYS.DBMS_METADATA", line 1216 ORA-06512: at "SYS.DBMS_METADATA", line 8546 ORA-06512: at line 1 123456 ORA-65047: Object SYS.KUPUTIL is invalid or compiled with errors in root.ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPUTIL"ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 1730ORA-06512: at "SYS.DBMS_METADATA", line 1216ORA-06512: at "SYS.DBMS_METADATA", line 8546ORA-06512: at line 1 This is basically because and invalid synonym “KUPUTIL”. to overcome the issue, I recreate the synonym and compile invalid objects one by one. it must be… Continue Reading
Password Rollover Time in Seconds mustafakalayci, 2024-11-26 Hello, Today, I was working on a new client database security issues. one of the first thing I checked is profile of DBA or highly privilged users. While setting PASSWORD_ROLLOVER_TIME limit in profile, I realized that even if I set it to 1 day, in DBA_PROFILES view it is listed… Continue Reading
PDB Syncronization Issue mustafakalayci, 2024-11-19 Hello, 2024 was hell of a year for me (still is) I couldn’t even check my blog. I just want to add a post, something small. From time to time I got pdb_plug_in_violations records about sync pdb comments like grants/revokes. I use a common user to manage my pdbs. Lets… Continue Reading
How to limit DB Link Connection Timeout mustafakalayci, 2024-07-03 Hi, I just want to share something small that I dug to learn. I didn’t work with db links for years and now all of a sudden I have tens of them. This comes with new challenges of course. When you tried to run a query or function/procedures over a… Continue Reading
Cloud Base Database Service mustafakalayci, 2024-04-25 Hi, Since I relocated to the Netherlands, I cannot find much time to write but finally I have some spare time. Recently, we migrated a client database environment to the cloud and to achieve that I started to learn cloud at the end of 2023 (I know I am “a… Continue Reading
Guid vs Sequences mustafakalayci, 2023-12-29 Hi Everyone, I haven’t written any posts lately because there is so much going on in my life and biggest change is I am moving to the Netherlands. it is a big change for me and my family but I hope everything will be fine (if we can find a… Continue Reading
How to Compare Two Tables mustafakalayci, 2023-10-26 Hi, Few days ago, I joined Chris Saxon’s webinar about “how to compare two tables”. Chris is one of the amazing guy in Oracle community and he shared different methods about how to compare two tables and also, strengths and weakness of the methods. before reading my post, I strongly… Continue Reading