-
Continue reading →: UKOUG Presentations for Tech13
I’m giving 2 presentation this year at the UK Oracle User Group Tech13 Conference The first is a discussion about the reason why you do or do not need to do low level detail traces and block dumps, and argument with Martin Widlake (and the audience hopefully). This is at…
-
Continue reading →: RACCheck
Running RAC? (Why? No, really, WHY? Never heard of DataGuard? With a broker?) Running RAC? Not sure if you’ve configured it correctly? Not sure if you have all of the recommended initialisation parameters set? All recommended RPM’s installed? All daemons running? etc, etc, etc, Well, as of Oracle 11.2.0.4 where’s…
-
Continue reading →: Goldengate OGG-01223 (Version) Problem
Just implementing Goldengate between a platform I don’t understand, a Tandem/HP non-stop, and Oracle 11G R2 RAC. So, I spend the day trying to get it working, have all of the configuration seemingly correct and when the Tandem guy an I try to for a connection to send data over,…
-
Continue reading →: UKOUG Tech13 launch last night
UKOUG Tech13 agenda launch last night. Feeling energised today if a little delicate. Looks like I’m giving 2 presentations this year.
-
Continue reading →: SQL Developer insight
When using SQL Developer, there is a feature called Completion Insight which help you write SQL and PL/SQL in the SQL Worksheets. It will auto-pop helpful things, like object name when typing a SELECT statement, column names if it is aware of the object which you are accessing and things…
-
Continue reading →: SYSMAN password change
Some days you just forget the dot all of the i’s. I had just installed a new RAC cluster, got it all up and running and was using DBCONSOLE to check the system out – no access to the Production Grid Control for this cluster yet. I then made a…
-
Continue reading →: The Dunning-Kruger Effect – I don’t know
Interviewing people is always a rich source of anecdotes, or should that be anec-dont’s? Whatever. When interviewing for a technical specialist, such as a senior Oracle DBA, it seems important to ask a number of technical questions to ascertain the competency the individual has in relation to Oracle and the…
-
Continue reading →: Killing a session. Dead!
… or what ALTER SYSTEM KILL SESSION doesn’t do. So, you have a runaway session and you want it to stop now, please. You enter “ALTER SYSTEM KILL SESSION (sid,serial#) IMMEDIATE” – supplying the parameters from GV$SESSION (adding @instance_id if it’s running in a different node) and you wait a…
-
Continue reading →: Oracle Default Password Checker
It’s amazing how much stuff you come across years after it was released by Oracle, like the view DBA_USERS_WITH_DEFPWD. It lists many standard or common database accounts where you still have a default password set. If you combine this with the DBA_USERS view, you can see instantly where you may…
-
Continue reading →: Oracle Join Syntax for ANSI people
I was talking with a non-Oracle DBA the other day about Oracle SQL syntax for joins, as I had written some SQL which he didn’t understand, using the old form of Oracle notation to signify outer joins – the (+) operator. It got me thinking; I have been using Oracle…
-
Continue reading →: UKOUG Combined AIM and Database Server SIG Agenda
On 18th July, the UKOUG has a combined technical Oracle SIG in London. I am (a) deputy chairman of the Availability, Infrastructure and Management (AIM) SIG, which concentrates on subjects like RAC, Exadata and Grid Control, and we are combining forces with the Database Server SIG to produce a 2-stream…
-
Continue reading →: RMAN Incarnations revisited (11G)
Time for an update to a older post. I have previously talked about the annoyance of connecting to RMAN with a duplicated database where the DBID has not been changed. RMAN happily breaks the catalog by assuming the “new” database is a new incarnation, and prevents the previous owner of…
-
Continue reading →: Oracle Data Files
I was looking at the contents of a tablespace recently – just the extents, not a block dump – with the intention of shrinking a couple of the associated datafiles (don’t ask why – the reason is both stupid and irrelevant). I needed to know just how much I could…
-
Continue reading →: UKOUG Conference 2012 Agenda Online
Today the UK’s big Oracle User event has just lifted its skirts to show off its new frilly agenda, which can be found here. I have been a member of the UKOUG for well over a decade, and a Special Interest Group (SIG) Deputy Chairman for the last 5 or…
-
Continue reading →: Outside Interests – not work!
So, what do you do that isn’t work. Sure, you work hard in the office. You might even do work when you get home at night on your own “lab” setup – VM’s make that so easy these days. Even an old desktop can spin up a couple of VM’s…
Neil Chandler's DB Blog 