ADSM-L

Re: [ADSM-L] Ang: TSM for DB password expiration

2011-03-25 12:55:38
Subject: Re: [ADSM-L] Ang: TSM for DB password expiration
From: Rainer Holzinger <RainerHolzinger AT GMX DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 25 Mar 2011 17:54:19 +0100
Hi,

since TDP for Oracle version 5.5.1 on Unix systems
'passsordaccess=generate' may be used. The TSM API is then taking care
about password issues.

best regards,
Rainer

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Howard Coles
> Sent: Friday, March 25, 2011 5:11 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Ang: TSM for DB password expiration
> 
> No, it's not different, Oracle TDP works the same on Linux and AIX.
> The only TDP I'm not sure of is the Windows version, but if I remember
> correctly it doesn't reset the password either.
> 
> 
> See Ya'
> Howard Coles Jr., RHCE, CNE, CDE
> John 3:16!
> 
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of David E Ehresman
> Sent: Friday, March 25, 2011 10:34 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Ang: TSM for DB password expiration
> 
> And is Oracle TDP on Linux different than on AIX?  Does password
> generate on linux?
> 
> David
> 
> >>> Howard Coles <Howard.Coles AT ARDENTHEALTH DOT COM> 3/25/2011 11:21 AM
> >>>
> For the Oracle TDP on AIX you have to set the passwordaccess option to
> prompt, as the TDP will NOT update the password.  The best option here
> is to set the password expiration to 0 on both the node, and the admin
> owner (if you have it) of the node.
> 
> However, what Daniel said is correct unless you run "update node
> server-oracle passexp=0" AND "update admin server-oracle passexp=0",
> then it will just keep on using the same password.
> 
> 
> See Ya'
> Howard Coles Jr., RHCE, CNE, CDE
> John 3:16!
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Daniel Sparrman
> Sent: Friday, March 25, 2011 8:52 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Ang: TSM for DB password expiration
> 
> Hi David
> 
> Correct me if I'm wrong, but when the nodes password has expired,
> passwordaccess generate will not set a new password for the client.
> You'll have to set a new password for the node, and then use tdpoconf
> to update the stored password on the client machine.
> 
> Best Regards
> 
> Daniel Sparrman
> -----"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> skrev: -----
> 
> Till: ADSM-L AT VM.MARIST DOT EDU
> Från: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
> Sänt av: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> Datum: 03/25/2011 15:41
> Ärende: TSM for DB password expiration
> 
> Has anyone had problems with TSM for DB (Oracle), aka TDPO, and
> password
> expiration?
> 
> We are running TSM for DB v5.5.1.0 with TSM api 6.2.2.0 on AIX 5.3 to
> a
> TSM server at 6.2.2.0 also on AIX 5.3. We are running with password
> generate.  Last night we got two ANR0425W password has expired
> messages
> for node DBFINTEST. I assume I got two messages because the rman
> command
> is using two channels, thus two concurrent TSM sessions.  At that
> point
> the password should have been set to something new and life should go
> on.  Instead, subsequent sessions for that node got the "ANS0282E
> Password file is not available.", ie password is incorrect, message.
> 
> Any thoughts on what might be going wrong?
> 
> David Ehresman