Home » RDBMS Server » Server Administration » Oracle 11g r2 ( Amazon RDS instance ) (linux 6.4)
Oracle 11g r2 ( Amazon RDS instance ) [message #614246] Mon, 19 May 2014 20:18 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Hi Team,

I am working with Amazon RDS Oracle instance. version. 11.2.0.2.
we have DEFAULT profile with below default values. But since we handle both password life time and grace time using Python code, we don't want to configure these 2 values in this profile. What value I can configure ? I just want to disable these 2 parameters.


DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD 7
thank you
Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614247 is a reply to message #614246] Mon, 19 May 2014 20:34 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
create a new PROFILE and do not include them.

BTW I do not think that V11.2.0.2 is certified on Linux 6
Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614248 is a reply to message #614247] Mon, 19 May 2014 21:11 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Hi,

Yes, we don't have access to thier linux server. We are provisioning the instances through their UI console. Yes, I am not sure exactly what version it is and i was hoping they would have kept the datbases in 6.x versions...

We need to use DEFAULT profile as per our company policies. In our physical environment, we maintain below values:

DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 90
DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD 3
Through Phyton code, we are rotating user's password after 90 days and we notify alert message before 3 days of password expiry.
Hence, we just need to disable these 2 values.

Can i set PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME to UNLIMITED ?
or PASSWORD_LIFE_TIME = UNLIMITED; PASSWORD_GRACE_TIME = 0 ?

Please guide me.

Thank you
Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614249 is a reply to message #614248] Mon, 19 May 2014 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 25856
Registered: January 2009
Location: SoCal
Senior Member
so do what others have done in the past to comply with policy.
Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614253 is a reply to message #614248] Tue, 20 May 2014 00:12 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Can i set PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME to UNLIMITED ?
or PASSWORD_LIFE_TIME = UNLIMITED; PASSWORD_GRACE_TIME = 0 ?


Use ALTER PROFILE.

Previous Topic: Getting data for loading into a UTF8 Oracle instance
Next Topic: Planning and Creating an Oracle 11g Database
Goto Forum:
  


Current Time: Thu Feb 22 07:29:22 CST 2018

Total time taken to generate the page: 0.02665 seconds