OraFAQ Forum: Server Administration » Oracle 11g r2 ( Amazon RDS instance )

Home » RDBMS Server » Server Administration » Oracle 11g r2 ( Amazon RDS instance ) (linux 6.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 11g r2 ( Amazon RDS instance ) [message #614246]

Mon, 19 May 2014 20:18

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

Report message to a moderator

Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614247 is a reply to message #614246]

Mon, 19 May 2014 20:34

BlackSwan
Messages: 26763
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

Report message to a moderator

Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614248 is a reply to message #614247]

Mon, 19 May 2014 21:11

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

Report message to a moderator