Apparently, quite a few people ran into this situation before, so I got a few correct answers (some on Twitter, some on LinkedIn, and some as comments to the original post).
I posted my first challenge almost 2 years ago and there was a lot of interest in it. Today I post another one.
Many years ago I saw this strange thing and it took me some time to realize what’s going on. Since then I ran into this scenario a few times, solving it instantly (and make a good impression at the same time).
I had a talk with a customer/colleague that got me thinking about a strange case of multitenant configuration. The chat was about an environment with two data centers and data guard.
During the discussion, I realized that there might be an issue with listener services, so I checked it and this post is the result
Next month RMOUG (Rocky Mountain Oracle User Group) will have their annual Training Days conference in Denver. In the past, being in Israel, I wasn’t exposed to most of these “local” OUG conference in North America (I mainly went to European ones) and even if I was, it was difficult for me to attend (money-wise and time-wise).
I’ve installed quite a few PSUs in my professional life, but this time, it was something else. I’m talking about a RAC environment with 2 nodes and a database containing JVM, so this was a complex patch to begin with. The problem is the the readme is incomplete and on top of that I ran into a few issues (some I could find on MOS but some I couldn’t). I’m writing this to assist anyone who needs to install this patch by providing the steps that worked for me. Please note that I patched 184.108.40.206 home, for other versions the steps might be a bit different.
I did some testing with impdp for a client. They asked me to write a procedure to import a set of tables from a production environment to a testing database. The import will include only a few tables, but not all, and will be performed to an already existing test environment that contains a full schema. And this process should be performed on a regular basis, so I looked for the best and easiest solution.