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
How to Copy Local Files to Oracle Object Storage Mustafa, 2024-01-112024-01-11 Hi, This is my first Oracle Cloud blog post. Due to some recent event, I am working on Oracle Cloud quite a bit and that “scary” cloud is not so scary anymore! I do plan to create a blog post series about how to migrate basic application/database structure to the… Continue Reading
Guid vs Sequences Mustafa, 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
Refreshable PDB and ORA-17627: ORA-12578: TNS:wallet open failed Mustafa, 2023-11-14 Hi, Here is a quick note about refreshable pdbs. I have 19c (19.20) refreshable pdb. Source PDB and refreshable PDB are on different servers and this system is working for quite some time. Today, suddenly I started to get errors on pdb refresh: Oracle PL/SQL Error report - ORA-17627: ORA-12578: TNS:wallet open failed ORA-17629: Cannot connect to the remote database server 17627. 00000 - "%s" *Cause: An error returned by OCI while sending/receiving message from remote instance *Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance 12345678 Error report -ORA-17627: ORA-12578: TNS:wallet open failedORA-17629: Cannot connect to the remote database server17627. 00000 - "%s"*Cause: An error returned by OCI while sending/receiving message from remote instance*Action: Look at error message and take appropriate action or contact Oracle Support Services for further assistance it is interesting because there is… Continue Reading
How to Compare Two Tables Mustafa, 2023-10-262023-10-27 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