Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Announcement Support for this product will end on December 22, 2025. To monitor Oracle databases, we recommend that you use PATROL for Oracle Enterprise Database.

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

Attribute

Default value

Application class

ORACLE_AVAILABILITY

Command type

PSL

Platform

All

Icon style

Graph

Unit

#

Border range

N/a

Alarm1 range

N/a

Alarm2 range

N/a

Scheduling(poll time)

Collector time

Active at installation

Yes

Parameter type

Consumer

Value set by

CollAvailability

BMC ProactiveNet Performance Management properties

Property

Default value

Monitor type

Oracle Database Availability

Key Performance Indicator

No

Monitor for abnormalities

Yes

Graph by default

No

Availability

No

Response time

No

Normal distribution

Yes

Statistical

No

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*