Options To Resolve The Expired OIM Schema Password In Oracle Database 11g (Doc ID 1326142.1)

Last updated on AUGUST 08, 2017

Applies to:

Identity Manager - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.
**Checked for Relevance on 25-Jul-2014**

Symptoms

OIM environment which was earlier working is now down and inoperable due to Oracle Database 11g's Schema password expiry.

The following errors are probably seen in the OIM Application Server logs /Application Server console.

a) Sample of the exception stack trace on the OIM Application's Weblogic Console when the Database Schema Password has expired.

01:39:10 INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] - Clustering is OFF.
01:39:10 INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] - Servlet Engine: WebLogic Server 10.3.5.0 Fri Apr 1 20:20:06 PDT 2011 1398638 Oracle WebLogic Server Module Dependencies 10.3 Thu Mar 3 14:37:52 PST 2011 Oracle WebLogic Server on JRockit Virtual Edition Module Dependencies 10.3 Thu Feb 3 16:30:47 EST 2011
01:39:10 INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] - Servlet API Version: 2.5
01:39:10 INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] - Nexaweb Server Info = Nexaweb Server 3.3.1072
01:39:10 INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] - Nexaweb Server initialized successfully.
<May 24, 2011 1:39:16 AM PDT> <Error> <OIM Authenticator> <BEA-000000> <Error setting SQL Hint java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-28001: the password has expired
<May 24, 2011 1:39:16 AM PDT> <Error> <oracle.iam.platform.auth.client> <IAM-0020011> <Login Exception encountered when trying to login as admin {0}
javax.security.auth.login.LoginException: javax.security.auth.login.LoginException: java.lang.SecurityException: [Security:090304]Authentication Failed: User oiminternal javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User oiminternal denied


b) Sample of the exception stack trace on the OIM Application's Weblogic Console when the Database Schema Password has expired and user account is locked.

<May 24, 2011 2:47:57 AM PDT> <Warning> <JMX> <BEA-149515> <An error was encountered getting the attribute DatabaseProductVersion on the MBean com.bea:ServerRuntime=oim_server1,Name=oimJMSStoreDS,Type=JDBCDataSourceRuntime during a call to getAttributes> <May 24, 2011 2:48:32 AM PDT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "oimOperationsDB": ORA-28000: the account is locked


Both of the above are due to the designed behaviour of the 11g Database's Password settings.

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