When host credentials attack…

 

I was using Grid Control to do a DB recovery test yesterday and something rather unusual happened which I can not remember seeing before.

I turned the DB off and moved all the files (spfile, controlfiles, datafiles, FRA contents etc) to a new location for safe keeping. One of the system administrators restored the most recent backups from tape to the disk-based backup location. I then started the recovery…

One of the first steps in the recovery process (using GC) is to enter the host credentials for the DB server where you are doing the recovery. Every time I tried I was told they weren’t correct, even though I could use the same credentials to log in to the server using SSH… Strange…

To make a long story short, if I was logged into the GC as the SYSMAN user, the credentials were recognized. If I was logged in as my own user (a super administrator) credentials for the “oracle” user on the DB server were reported as incorrect.

I did a similar test on another database server a couple of weeks ago and I don’t remember any problems there…

If I get time I’ll go back and see if I can figure it out, but for now, if in doubt, try the SYSMAN user first… šŸ™‚

Cheers

Tim…

Author: Tim...

DBA, Developer, Author, Trainer.

7 thoughts on “When host credentials attack…”

  1. In order to avoid similar problems, personally I would never rely on GUI when it comes to recovery. Command Line rules especially here.

  2. Hi.

    I’m happy with the RMAN command line. Can’t be sure others having to do this task will be, so I was using GC to make sure the process is workable. It works fine…

    Under pressure in a real situation I would probably revert to command line, because it is my warm safe place…

    Cheers

    Tim…

Comments are closed.