Recently I came across the following error during the startup of Oracle Adaptive Access Manager Server which prevented the server from starting up:
You can easily figure out from the above exception that the server is not starting because password of some database user is expired. However, there is no mention of which users’ password we should check. I will walk you through the steps to find out the database user whose password is expired.
In the above stacktrace, you can see the name of the data source name is ‘opss-DBDS’ (derived from the line – <Jun 12, 2014 4:26:48 PM IST> <Error> <Deployer> <BEA-149205> <Failed to initialize the application ‘opss-DBDS’ due to error weblogic.application.ModuleException: .weblogic.application.ModuleException). All the datasource related information in WebLogic server can be found in Data Sources link in the Administration Console or in <DOMAIN_HOME>/config/jdbc/ and <DOMAIN_HOME>/config/config.xml. Since the server is not starting up, there is no question of checking the data source information through the Administration console. So we will use the domain directory files to solve this problem.
The target will vary depending on the servers which you are using. descriptor-file-name tag gives the relative location of the file in which the data source information is stored.
alter user DEV_OPSS identified by <PASSWORD>;
Now once the password of the user is restored, you will be able to start the server. I hope this post will be helpful to many as the password for the database user account expires automatically in 180 days if the default password policy is in place.
Ganesh Kamble works as Oracle Fusion Middleware Consultant and is an Oracle Certified Specialist in Access Management. Having started his career in product development at Oracle, Ganesh got excellent exposure to the middleware technologies during his work in integration of Tier-1 banking product Oracle Banking Platform with Oracle Fusion Middleware products. He was honored with Outstanding Contribution award by Oracle.
His key areas of interest are Oracle Identity and Access Management, Oracle Service Oriented Architecture and Java with passion for blogging on various encounters with Oracle products. He publishes blogs regularly on http://k21technologies.com/blog/. He can be reached at email@example.com and http://twitter.com/ganeshk_8