How to update the dba profile to set the DBA password life to unlimited from default 180 days in Oracle 11G

book

Article ID: 48616

calendar_today

Updated On:

Products

EHEALTH CA eHealth

Issue/Introduction

Description:

In Oracle 11G the dba password life is set to default value of 180 days unlike previous release of Oracle 10G where it was set to unlimited. This will inadvertently stop eHealth from running after 180 days of Oracle install. Issue is fixed in 6.2.3.01 Oracle 11g database password expired.

Solution:

Run the following query to verify the change. It should return the new value 'UNLIMITED':
$NH_HOME/bin/sys/nhisql -sysdba "select LIMIT from dba_profiles where RESOURCE_NAME = 'PASSWORD_LIFE_TIME'"

To fix this issue run following command logged in as the eHealth administrator account from a command prompt:

For Solaris and Linux:

$NH_HOME/bin/sys/nhisql -sysdba "ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED"

For Windows:

%NH_HOME%/bin/sys/nhisql -sysdba "ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED"

To Verify:

Run the following query to verify the change. It should return the new value 'UNLIMITED':

For Solaris and Linux:

$NH_HOME/bin/sys/nhisql -sysdba "select LIMIT from dba_profiles where RESOURCE_NAME = 'PASSWORD_LIFE_TIME'"

For Windows:

%NH_HOME%/bin/sys/nhisql -sysdba "select LIMIT from dba_profiles where RESOURCE_NAME = 'PASSWORD_LIFE_TIME'"

Environment

Release:
Component: EHORA