Oracle GoldenGate 12c (188.8.131.52.0) has changed the information that is stored in the trail files. All the standard information is still there. What Oracle changed has to do with the meta data that is used to define a table.
Note: If you want a understand how to use log dump and general trail information, look here.
Prior to 184.108.40.206.0 release of Oracle GoldenGate, if the column order (more...)
It’s gettting to that time of year, so here are some of the sessions I’ve pencilled in for UKOUG Tech 15:
9:00 – 9:50: Tom Dale – Fivium : An insight into Oracle Standard Edition, what’s included, what’s not, and how to plug some of those holes!
11:20 – 12:10: Me (et. al.) : Cost Based Optimizer – Panel Session
12:20 – 13:10: Franck Pachot – DBi Services : All About Table (more...)
It’s nearly early December, so it must be time for the UK Oracle User Group Conferences – JDE15, Apps15 and Tech15
There’s some absolutely wonderful presentations, and there’s the 2 I’m giving as well:
An Introduction to RAC (12c) at 9am on Monday 6th, and Troubleshooting Goldengate at 12:20 on Tuesday 7th.
I’m also helping our with a new style database Keynote this year. We are inviting questions from the audience and having them answered (more...)
Technical people tend not to enjoy Keynotes at conferences. We are allergic to content-light “there has never been a better time to invest in our products” fluffy, frou-frou, big picture talks. We want how-it-works meat on the bones of what is served up to us.
OK, it’s a very poor photo but the best I have of Dom presenting. Sorry Dom.
Well, at the UKOUG Tech15 conference this year (Birmingham ICC 7th-9th December) we have (more...)
Another annual DOAG conference has passed, and I can only say the very best about it: Perfectly organized, large and modern location, impressive list of well known speakers and over 2100 attendees – wow!
My presentation Best of RMAN was scheduled at the first slot on the first day, so I was a bit concerned whether many people would attend that early. It turned out that the room got so full that I was asked (more...)
You need to be careful when coding and using triggers when it comes to Datapump (or anything that transposes triggers between schemas). A lot of people make assumptions about what will happen with their triggers, and often get a nasty shock when they see the reality. Lets explore with an example
I’m going to add three triggers to the standard EMP table in the SCOTT schema
SQL> connect scott/tiger
SQL> create or (more...)
With the announcement of Oracle GoldenGate 12c (220.127.116.11.0) at Oracle Open World this year, I was interested in hearing that Oracle has finally integrated the heartbeat process into the core functionality of GoldenGate. Setting up the heartbeat is always a fun thing to do with GoldenGate and I had hoped that this move to integrated it would bring benefits with it. To my dismay, I’m a little underwhelmed with the heartbeat (more...)
2 3 4
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 19
ORA-06512: at “SYS.UTL_TCP”, line 280
ORA-06512: at “SYS.UTL_SMTP”, line 163
ORA-06512: at “SYS.UTL_SMTP”, line 199
ORA-06512: at “SCOTT.SEND_MAIL”, line 8
ORA-06512: at line 2
This error message means that no access control list has been assigned to the host you (more...)
Latches are low level serialization mechanism which protects memory areas inside SGA. They are light wait and less sophesticated than enqueues and can be acquired and released very quickly.
Latch acquisition does not involve any complex algorithm and is based on test-and-set atomic instruction of a computer processor.
Latch can be classified in multiple ways:-
Shared latch and exclusive latch:
Shared latch is the one which can be shared by multiple processes/sessions.
A proper management of ASM Disks can be a complicated task.
I discussed with Martin Bach
about the concept in my current company, where we implemented a setting which is consistent, robust and enables Storage, Linux and DB admins to work together easily.
As we started to think about ASM when 10.1 was out we tried to evaluate our possibility. asmlib
was discarded quite early as it only increased complexity without additional (more...)
Another topic of conversation that came out of Bryn‘s session at Oracle Midlands related to PL/SQL code formatting. I’m not sure I agree 100% with his opinion, but it’s certainly making me think about my current stance.
When I said I was going to blog about a couple of the points he raised, Bryn emailed me some stuff, which I’m going to use here. So this is Bryn’s content, with some of my opinions thrown in. I (more...)
The autumn BGOUG conference is now over. I planned to write a post immediately after the end of the conference when the enthusiasm and spirit is still fresh bee-zing but anyway it stays for quite a while :)
This year it was the whole family attending the conference and my daughter Alex had an early Oracle start listening to Jonathan Lewis talking about execution plans.
This time we had about 370 people attending BGOUG. My presentation on (more...)
Monday 7th Dec: 11:20 – 12:05
I’ve arranged a panel session on the Cost Based Optimizer for UKOUG Tech 2015, with Maria Colgan, Nigel Bayliss, and Chris Antognini joining me to answer (and maybe argue about) questions from the audience.
To keep things moving along, we aim to have a few questions available before the day and collect a few questions at the door as well as accepting questions from the floor. Martin Widlake (more...)
I mentioned in yesterday’s Oracle Midlands post, Bryn had an example of some syntax I had not seen in 20+ years of PL/SQL development.
You tend to name PL/SQL parameters and variables in such a way as to prevent name clashes with table columns. Let’s cause an obvious name clash…
The table DUAL has a column called DUMMY with a single row with the value ‘X’.
SQL> select * from dual;
1 row (more...)