In a little less than a week I start the OTN APAC Tour. This is where I’m going to be…
- Perth, Australia : November 6-7
- Shanghai, China : November 9
- Tokyo, Japan : November 11-13
- Beijing, China : November 14-15
- Bangkok, Thailand : November 17
- Auckland, New Zealand : November 19-21
Just looking at that list is scary. When I look at the flight schedule I feel positively nauseous. I think I’m in Bangkok for about 24 hours. It’s sleep, conference, fly.
This year's SANGAM is scheduled on Nov 7,8,9 in Bangalore city. Don't let the opportunity go vain, avail/grab the opportunity if you are in India. I am (more...)
Kim Berg Hansen from Denmark wins the SQL mini-challenge for his UNION ALL materialized view with fast refresh on commit. An analysis of his solution has been published in the NoCOUG Journal. Judge’s statement: “Kim won on participation, efficiency, and accuracy. He kept submitting refinements, lowering the bar until he reached the theoretical lower limit of 1. His solutions survived the test cases written by the judging committee.”
The Manage Cloud Control | Agents page was always useful but for quickly identifying EM agent status. Prior to Release 4 this page had static icons indicating problems with specific agents. The page contained no hints about why the agents were in trouble, I’d highlight the broken agent’s row and then push the Unblock icon. There was 50-50 chance that the agent was actually blocked but, as often as not, Resecuring the agent would fix the issue. Haphazard? (more...)
Every once in awhile I do something in my test environments to test something else, then I go back to test core functions of the product; in this case I was testing a feature of Oracle GoldenGate 12c. Earlier in the day, I had set the $ORACLE_HOME enviornment variable to reference the Oracle GoldenGate home. Instead of closing my session and restarting, I just started GGSCI and the associated manager. To my surprise, the extracts (more...)
Just a quick heads-up for those that use it, phpBB 3.1 Ascraeus as been released. It’s a feature release, so the upgrade is a bit messy. I did the “automatic” upgrade. There was so much manual work involved, I would recommend you take the approach of deleting the old files, replacing with the new ones, then running the database upgrade from there. I’ve not tried that approach, but the docs say it is OK to (more...)
Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could be retrieved using opatch.
Initially I thought that identifing the Oracle GoldenGate version could only be done by logging into GGSCI and reviewing the header information. To (more...)
I’m a great fan of community events, as I hope my blog, tweets, presentations and support of the UKOUG, chairing many SIGs over the last few years, will attest. It’s the second best way to learn anything, talking with your peers who have already worked it out, and those who have the same problem to (more...)
The East Cost Oracle Users Group Conference 2014 is next week. To me, ECO is quite special. I am speaking there for my 3rd time!
The ECO group is kind of new (about 4 years old), and it is the clustering of several regional user groups including the Virginia Oracle Users Group, the Eastern States Oracle Applications Users Group, the Hampton Roads Oracle Users Group, and the Southeastern Oracle Users Group.
What I like about (more...)
Following on from the short note I published about the first_rows optimizer mode yesterday here’s a note that I wrote on the topic more than 2 years ago but somehow forgot to publish.
I can get quite gloomy when I read some of the material that gets published about Oracle; not so much because it’s misleading or wrong, but because it’s clearly been written without any real effort being made to check whether it’s true. (more...)
How To Change The Priority Of Oracle Background Processes
priority through an instance parameter! I'm not saying it's a good idea, but it can be done.
I’ve just returned from my honeymoon in Venice with the wonderful Tim Gorman, but before we enjoyed our week in this picturesque city, we spent a week doing joint keynotes and two sessions each on our own tech topics at these two incredible conferences in neighboring countries.
ORA-01511, ORA-01141, ORA-01110, ORA-17503, ORA-17515 and ORA-06512 when executing dbms_dnfs.clonedb_renamefile
This post is for those who google the errors and maybe it will help to save some time. I've been playing around with clonedb for some time now and every time I hit these errors it takes me some time to figure out what actually the problem is :) The error messages are not really helpful at all. Maybe I'll remember it now.
When creating a new clone database using clonedb then after creating the (more...)
We recently received this inquiry from a client:
“Can an Oracle database account support two passwords at once so we can roll out updated credentials to application servers gradually rather than having to change them all at the same time? Then once all of the application servers have been configured to use the new/second password we can change or remove the first one?”
The short answer is no. Like most computer technologies, an (more...)
What is Oracle Data Redaction ? Oracle Data Redaction is meant to mask (redact) sensitive data returned from application queries. Oracle Data Redaction doesn’t make change to data on disk, the sensitive data is redacted on the fly before it is returned to the application. You can redact column data by using one of the following methods: Full [...]
I attended to PostgreSQL Conference Europe 2014. It was held October 21-24 at Madrid. I do not know the exact number of attendees but there were some sessions that you can not find seat and have to listen while standing up on a corner. As an Oracle DBA, PostgreSQL is a different world to me. I tried to follow the DBA track and gather as much information as I can. Unfortunately the level of DBA (more...)