Distributed Computing

This morning someone passed me a link to "The Eight Fallacies of Distributed Computing". Looks pretty accurate. I'd say that many of them are doubly true of RAC.

Comments

Post a Comment

Popular posts from this blog

Preventing record deletion

This entry is partly an aide memoire for me, partly to try to get something that has been keeping me awake for the past hour or so out of my brain so I can sleep and partly in the hope that someone can suggest a way forward. A quick bit of background. Until April 06 most of our major systems were looked after by an external Faccilities Management company. In April 06 IT was kind of outsourced to a joint venture company, support of the systems transferred to that company and a couple of the DBAs transferred in as well under TUPE. A reccurring problem on one of the systems is that the users keep deleting records which, by law, they must not delete so we (actually one of the DBAs who transferred in who is responsible for that system) has to restore from backup to another machine and copy the deleted records over (she's tried using LogMiner but finds it too unwieldy). The core problem is that the application is faulty and lets the users delete the records when it shouldn't. The...
Read more

Changing Oracle Database ID and Name (nid)

 Getting back into Oracle as a DBA I've been reading up and watching tutorials to try to get the old skills back and update to the new tools, last time I DBAed in anger we were still on Oracle 7 and 8i, 9i had been out a while and 10g was in early versions, but because much of our software was so old we weren't using it much.  I came across a tutorial on how to update the name and ID of a database.  This is useful if you have copied a database and want to rename the copy to stop it being confused with the old, or if you want to have it on the same machine as the old.  The database ID is an internal number used by Oracle to identify the database, it looks like the main reason you'd want to change the ID is if you use RMAN and want to have both in the same repository. PLEASE NOTE: The below is based on a tutorial I watched and has not been tested, errors and omissions are expected.  Before using in production do a few practice runs on sandbox databases.  Proc...
Read more

Does Oracle cache the SYSDBA password?

I was just having a play around on one of my test/sandpit databases ("small database on a low power machine that I use for testing out scripts &c, no live data and if the database gets destroyed I just have to wipe out the files and create a new one" type of thing). I'd forgotten the SYSDBA password (for sandpit systems I use the SID as the SYSDBA password so don't bother to write it down, for some reason this time I didn't) but needed it (I'm installing HTMLDB to try it out on that machine) so wanted to change it. I had been getting 1 : SQL> conn sys/sbtest@sbtest as sysdba ERROR: ORA-01017: invalid username/password; logon denied as you might expect. I used orapwd to change the password $ cp orapwsbtest orapwsbtest.20060629.bak $ orapwd file=orapwsbtest password=sbtest entries=16 OPW-00005: File with same name exists - please delete or rename $ rm orapwsbtest $ orapwd file=orapwsbtest password=sbtest entries=16 and thought I would be good to go....
Read more