IBM Support

Image Services: Oracle user password expires on Oracle version 11g

Troubleshooting


Problem

Oracle 11g creates a more secure configuration than in previous releases of Oracle Database, in which it automatically assigns a default profile called DEFAULT to all users that do not already have a profile assigned explicitly. This default profile requires passwords to be changed every 180 days or the passwords will expire and the user will be locked out of Oracle. The Oracle 11g default security configuration may be turned on in the following two situations: Create a database using Oracle Database Configuration Assistance (dbca): choose “Keep the enhanced 11g default security setting” which is the default during creation of a new database; It invokes the new password expiration policy. Upgrade a database using Database Upgrade Assistant (dbua) or other tools: choose to upgrade a database from a previous release in which the existing users do not have a profile assigned. The Oracle 11g default security configuration can be reverted to pre-11g security configuration with either one of the followings: dbca: During creation of a new database, choose “Revert to pre-11g default security settings” option. dbca: If the database is already created or upgraded to 11g, run dbca -> Configure Database Options -> Revert to pre-11g default security settings.

Symptom

When a user password is about to expire, IS returns logon error 121,1,28002.

$oerr ora 28002


28002, 00000, "the password will expire within %s days"
// *Cause: The user's account is about to about to expire and the password
// needs to be changed
// *Action: change the password or contact the DBA
//
[{"Product":{"code":"SSNVUD","label":"FileNet Image Services"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Oracle","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"4.2;4.1.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
FileNet Image Services

Software version:
4.2, 4.1.2

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
133525

Modified date:
29 April 2025

UID

swg21413892

Manage My Notification Subscriptions