Milliseconds are lost after date to tz conversion on 19c Mustafa, 2025-07-15 Hi, yesterday, I found (maybe) a small bug in 19c. Whenever I deal with timestamp with time zones, I always learn something new. so, the request is as this: there is a DATE column which should be converted into a timestamp with tz but if it is null then result… Continue Reading
DDL Generation Failed with ORA-65047: Object SYS.KUPUTIL is invalid Mustafa, 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
How to call HTTPS Url Without SSL Wallet in 19c Mustafa, 2025-04-06 Hi, as you know for over the years, if you want to call a secure url (https) you must add the certificates to your ssl wallet first. this operation, most probably, requires also DBA action. Finally with 23ai changed this and now you can call a https url without wallet…. Continue Reading
Is Table Unnecessary for Pipelined Function Mustafa, 2025-04-05 Hello everyone, What a busy year. I couldn’t find time to write something and so much is happening, AI models, Quantum etc. So I want to write more now. I know that many people think that blogging is dead but I don’t share this thought because AI is still not… Continue Reading
Password Rollover Time in Seconds Mustafa, 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 Mustafa, 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 Mustafa, 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 Mustafa, 2024-04-252024-05-14 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
29th of February and interval Mustafa, 2024-02-29 Hi, it has been a long time since I post something. I just relocated to a different country, the Netherlands, and I was dealing with so much paperwork and stuff. So far so good. Dutch people are so kind and warm, they help about everything. My first impression is amazing… Continue Reading