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…

apple-touch-icon-57x57