Home » RDBMS Server » Backup & Recovery » Editing RMAN Job DB Control (10g)
Editing RMAN Job DB Control [message #399820] Fri, 24 April 2009 04:05 Go to next message
firefly
Messages: 53
Registered: March 2009
Location: Europe
Member
Hi,

We have a DB Control RMAN job which uses an OS account. Each time the OS account expires and its pwd changed the RMAN job failed. I can't seem to find where this can be edited so end up creating a new job.

Does anyone know where in DB Control the pwd for the OS a/c can be changed? I can see the forthcoming scheduled jobs but can only view their definition.

Thanks in advance.
Re: Editing RMAN Job DB Control [message #399852 is a reply to message #399820] Fri, 24 April 2009 04:56 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Then Remove password expire option from your OS level.

Please avoid for duplicate post.

Babu
Re: Editing RMAN Job DB Control [message #399856 is a reply to message #399820] Fri, 24 April 2009 04:59 Go to previous messageGo to next message
firefly
Messages: 53
Registered: March 2009
Location: Europe
Member
Apologies for the duplicate post - had a timeout error. We can't change the policy at the OS level due to security policies. Can the RMAN job be changed via DB Control?

Thanks

Re: Editing RMAN Job DB Control [message #399868 is a reply to message #399856] Fri, 24 April 2009 05:50 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>Each time the OS account expires and its pwd changed the RMAN job failed

I think it's windows environment.

>> We can't change the policy at the OS level due to security policies.

Then try to create another user (like oracle) in your OS level. For backup purpose don't set password expire option.

Babu
Re: Editing RMAN Job DB Control [message #399869 is a reply to message #399868] Fri, 24 April 2009 05:55 Go to previous message
firefly
Messages: 53
Registered: March 2009
Location: Europe
Member
It's UNIX (worked on Windows too long hence Win referencs!).

I'll see what I can re: the OS password but you would think that the RMAN connection credentials should be able to be changed via Db Control as the job was created there...If anyone can enlighten me then super. Otherwise I'll re-create the job again..
Previous Topic: Editing RMAN Job DB Control
Next Topic: Failover 10 g Standard Edition
Goto Forum:
  


Current Time: Thu Apr 25 14:21:43 CDT 2024