Using Database 11g As Metadata Returns "ORA-28001 The Password Has Expired" Attempting To Connect with Discoverer 11g

(Doc ID 1145984.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.2.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 20-Nov-2014***

Symptoms

In a new installation of Fusion Middleware Discoverer 11g, where an 11g database has been used to store the Metadata Infrastructure, the following exception is returned attempting to connect to Discoverer Plus or Viewer:

- oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired

Changes

In the previous version of Oracle Application Server, the database used by default was 10g, where the default values for profiles where set to :


SQL> select resource_name,limit from dba_profiles where profile='DEFAULT';

RESOURCE_NAME LIMIT
------------------------------ ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED

16 rows selected.



In 11g, the default for some of these profiles has been changed:


SQL> select resource_name,limit from dba_profiles where profile='DEFAULT';

RESOURCE_NAME LIMIT
------------------------------ ----------------------------------------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CPU_PER_SESSION UNLIMITED
SESSIONS_PER_USER UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PASSWORD_GRACE_TIME 7
PASSWORD_LIFE_TIME 180
PASSWORD_LOCK_TIME 1

16 rows selected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms