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
Querying CDB_* Views Generates Audit Records Mustafa, 2023-10-04 Hi, I would like to share a small problem I had on one of my databases. I had a common user on my CDBs to manage the databases (version is 19.20). On my databases, I use unified auditing and traditional audit is off. ORA_LOGON_FAILURES and ORA_SECURECONFIG policies are only enabled… Continue Reading
Sessions with details Mustafa, 2023-09-212023-09-21 Hi, Today I just want to share a small select statement that I used (my original one is a little bit longer). I use this to get as much as “important” data from sessions in the database. By saying “important”, I mean the data that I use to identify the… Continue Reading