As I always forget this (and have to look for it) I will put it into my blog - maybe I will memorize it now ;-)
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';
Wednesday, May 28, 2008
Sunday, May 18, 2008
Oracle Data Guard screw up
Setting up Data Guard with Maximum Protection requires the Data Guard Broker.
Having setup Data Guard a couple of times without the broker I thought "how difficult can it be?" and started.
After some preparations I started the dgmgrl in order to configure the various sites.
To my astonishment no command at all was recognized. I have to admit that I even went back to the manuals to see if it was my fault. And then - shame on me - I tried to use the help function inside the dgmgrl.
See what happens then:
WHAHAHAHA!
Ok, so either I was seriously stupid or there was an error - probably a relink issue.
A good friend of mine at Oracle PTS - Robert Pastijn - offered the needed help and pointed out that a bug was introduced on AIX in the upgrade from 10.2.0.1.0 to 10.2.0.2.0 . The patch fixed this problem.
So after all Oracle did not (yet) follow the classic Microsoft error: Error - No Error.
Having setup Data Guard a couple of times without the broker I thought "how difficult can it be?" and started.
After some preparations I started the dgmgrl in order to configure the various sites.
To my astonishment no command at all was recognized. I have to admit that I even went back to the manuals to see if it was my fault. And then - shame on me - I tried to use the help function inside the dgmgrl.
See what happens then:
WHAHAHAHA!
Ok, so either I was seriously stupid or there was an error - probably a relink issue.
A good friend of mine at Oracle PTS - Robert Pastijn - offered the needed help and pointed out that a bug was introduced on AIX in the upgrade from 10.2.0.1.0 to 10.2.0.2.0 . The patch fixed this problem.
So after all Oracle did not (yet) follow the classic Microsoft error: Error - No Error.
Subscribe to:
Posts (Atom)