Oracle RMAN for Beginners – Part 2

At the end of Oracle RMAN for Beginners – Part 1 I was ready to begin a backup of the ant12 database. Read on … Continue reading

Posted in Oracle | 1 Comment

Oracle RMAN for Beginners – Part 1

Introduction

One of the things a DBA needs to be aware of, is RMAN. This has been around since Oracle 8 (or was it 8i?) and has been improving since then. It’s almost pretty good at 11.2!

One of the things that I, as a DBA, need to get to grips with is RMAN. Most of the work I’ve been doing for the last few years have not involved very much in the way of RMAN usage. It’s time I put an end to my almost complete ignorance.

I have set myself up a small test system where I can do my own RMAN training. I’ll be writing up my results and findings as I go along. Feel free to correct me where I get things wrong – which I no doubt will! Continue reading

Posted in Oracle | 2 Comments

Docbook – Creating Indexes

PDF Creator    Send article as PDF   

I’ve been doing a bit of Docbook work recently – converting a paper based manual into a Docbook one that can then be used to generate all kinds of different output from the same input file. Very useful.

I needed to create an index that correctly reflected the contents of the new format rather than simply copying the old one – where the pages would no longer have matched up.

I found a couple of good articles, namely:

http://www.xml.com/pub/a/2004/07/14/dbndx.html

and, of course, this one:

http://www.sagehill.net/docbookxsl/GenerateIndex.html

UPDATE: Of all the people you would expect to get it right, Bob Stayton is the one. Except he got it wrong. In the link above to www.sagehill.net, there is an example thus:

<indexterm class="startofrange" id="makestuff">
 <primary>Makefiles</primary>
</indexterm>
 ... 
<indexterm class="endofrange" startref="makestuff">
 <primary>Makefiles</primary>
</indexterm>

It should be as follows without the on the end of page range indexterm. If you do it with a primary, you get the page range as expected, but with the final page duplicated, as in:

Subject matter 123-127, 127

Remove the primary and it just works.

Posted in Docbook | Leave a comment

Raspberry Pi Goes Into Manufacturing – Yippee!

PDF Creator    Send article as PDF   

It’s finally coming! Raspberry Pi has now officially started manufacture of the first production boards. See http://www.raspberrypi.org/archives/509 for details.

Sadly, you can also see there why the tax situation in the UK (or possibly because of the EU) is preventing the charity from manufacturing these boards in the UK.

And, equally sadly, it may also be true that certain UK manufacturers don’t seem to want the extra work either.

How sad are we in the UK?

Cheers.

Posted in Gadgets & Gizmos | Leave a comment

Why Do I Have To Suffer Your Children?

I’m trapped on a plane for four and a bit hours and your bloody child has been screaming it’s head off for most of the way. Continue reading

Posted in Rants & Raves | Leave a comment

Everything? You Ever Wanted To Know About Christmas

PDF    Send article as PDF   

From The Thinking Atheist on YouTube via RDFRS:

Guess what, all those Christmas Carols and so on, are not quite what they seem.

Happy “Christmas”

Cheers.

Posted in Rants & Raves, Religion | Leave a comment

Slightly Weird Oracle Stuff

I knew you could do this: Continue reading

Posted in Oracle | 4 Comments

The Green Thing

This is doing the rounds on email at the moment, but it made me laugh. Grumpy old sod that I am! ;-)

Checking out at the store, the young cashier suggested to the older woman that she should bring her own grocery bags because plastic bags weren’t good for the environment. The woman apologised and explained, “We didn’t have this green thing back in my earlier days.” Continue reading

Posted in Rants & Raves | Leave a comment

Adobe Air Applications Can’t Find Passwords etc?

TweetDeck for Linux, for example. Refused to start on me recently because it couldn’t find or access the location where I had saved my encrypted details. The problem is caused by Adobe Air not being able to find a running daemon for Gnome Keyring or KWallet, or a corrupted wallet database. Continue reading

Posted in Linux, Twitter | Leave a comment

Deprecated Parameter Warning on Database Startup

You know the feeling, your 10g or 11g database displays a warning message about your use of deprecated parameters at startup, but it doesn’t say which parameters are deprecated? Continue reading

Posted in Oracle | Leave a comment

Does Your Volume Control Freeze on KDE?

I’ve been using KDE4 on OpenSuse (11.4 currently) for some time and never had any problems. After a recent patch fix to the system, the volume control buttons on my Dell Vostro stopped responding. Normally pressing volume up or volume down worked instantaneously. Stop and go still worked fine, but not volume. Continue reading

Posted in Linux | Leave a comment

Indoor Beekeeping? It Won’t Catch on!

Create PDF    Send article as PDF   

Check this link for details. I’m saying nothing!

Except, maybe, I really can’t see it taking off.

Well, ok then. How do you stop the queen laying in the honey comb? There doesn’t appear to be a queen excluder – so your honey will have all sorts of stuff in it! Larvae, eggs, etc. It really won’t work!

Cheers.

Posted in Bees, Creatures | Leave a comment

NetBeans Complains That it Can’t Find Java.Lang in your Android Project.

Using NetBeans (version 7.0.1) to develop Android applications and for no apparent reason, a project that worked yesterday won’t run any more. It compiles without error but refuses to run – whether or not the emulator is running – and doesn’t produce an error. Hmmm.  Continue reading

Posted in Android, Linux, NetBeans | Leave a comment

Can We Have 10g and 11g on the Same Server?

PDF Printer    Send article as PDF   

If you install 10g and 11g on the same server, which one do you wish to supply the executables for “oraenv”?

If you install 10g first and allow 11g to overwrite the files in /usr/local/bin when you run “root.sh” then when you eventually call oraenv to set a 10g environment, you get a warning that “$ORACLE_HOME/bin/orabase” cannot be found.

If you allow the 10g files to overwrite the 11g ones, you don’t set ORACLE_BASE. I wonder what problems that might cause?

Cheers.

Posted in Oracle, Rants & Raves | Leave a comment

Removing “Rogue” Expensive Oracle Options After Upgrading to 10.2.0.x.

Install 10.2.0.1 – the base release – of Oracle and deselect the various Enterprise Edition Options – these cost money and we don’t like that, especially if we don’t use them.

Patching to 10.2.0.5 (in my installation – it could be different with previous versions) silently adds OLAP, Data Mining etc back into the mix. Not good – especially if/when Oracle decide to audit your licenses. You pay for what you install whether used or not. Continue reading

Posted in Oracle, Rants & Raves | 4 Comments