Number of Days till Patrol User Password expired (PasswordExpirationDays)

The PasswordExpirationDays parameter describes the remaining days till the password of the PATROL Database User expires. To know the expiration days of password we run the following query:

"select 'DATAPOINT', expiry_date-sysdate, expiry_date from user_users where username='".current_user."';

To know the current user you run:

"/AgentSetup/ORACLE_AVAILABILITY.<SID>.defaultAccount"

If no entry exists in pconfig for default account then, will check :

"/OracleConfig.<SID>.osusername"

In case we have errors or no result  while running the query then the paramater will have the value -1 and an annotation will be added to param.

If the “expiry_date” from the query is empty so “Never” will be annotated to the param.

If the “days” is empty from the result then “99999” will be set as value.

BMC PATROL properties

ORACLE_AVAILABILITY

BMC ProactiveNet Performance Management properties

Oracle Database Availability