Unable to Start the Admin Server in Forms 12c, due to ORA-28001

September 8, 2017 admin Weblogic12c, Forms12c, 6

Unable to Start the Admin Server in Forms 12c, due to ORA-28001

In the previous post, we have seen how to fix the issue :
Unable to Start the Admin Server in Forms 12c, due to ORA-28000 in case of DEV_OPSS schema is locked.
We will now look at ORA-28001 error caused by password expired.
For the purpose of the current post, i will set the DEV_OPSS password expired in our pluggable database.

---

Reset the password to expired
ALTER USER DEV_OPSS PASSWORD EXPIRE;
Let’s display the user :
SELECT username, account_status, authentication_type
FROM dba_users
WHERE username LIKE ‘DEV_%’;

DEV_WLS_RUNTIME             OPEN     PASSWORD
DEV_IAU_APPEND              OPEN     PASSWORD
DEVPLG                      OPEN     PASSWORD
DEV_OPSS                                         EXPIRED   PASSWORD
DEV_IAU                     OPEN     PASSWORD
DEV_STB                     OPEN     PASSWORD
DEV_IAU_VIEWER              OPEN     PASSWORD
DEV_WLS                     OPEN     PASSWORD

After starting the weblogic server, using the startWeblogic.cmd command on windows, we will get the following error:

Error Code: 28001
…………………………………………….
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable

(JpsDBDataManager.java:1669)
… 84 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

---

♦ Solution:

• We have to reset the expired password for the DEV_OPSS user.
• alter user DEV_OPSS identified by xxx_n_pass;
• We need to start weblogic server, however, before that, we have to do the following:
• Run the wlst.cmd in $ORACLE_HOME/oracle_common/common/bin

• Search for jps-config.xml – file in : ORACLE_HOME>\user_projects\domains\base_domain\config\fmwconfig
• Run the following command in wlst-window

modifyBootStrapCredential(jpsConfigFile='<Oracle_Home>/user_projects/domains/base_domain/config/fmwconfig/jps-config.xml’,username=’DEV_OPSS’,password=’xxx_n_pass’)

• In WLST, run the following (you must use forward slashes ‘/’ even for Windows): 

• Exit WLST: exit() — Exit the wlst scripting window.
• Restart the Admin Server. The Admin Server will start up even if there are some errors about the data source

weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException:
Could not create connection for datasource ‘opss-data-source’.

• The returned message is: ORA-01017: invalid username/password; logon denied
• Log into the Admin Console.

• In the Admin Console, click “Lock & Edit“.
• Go to the Configuration Pool, change and confirm the new password

• Click on Activate changes

• If all is done correctly, you will see Setting updated successfully.

• Click on view changes and restart.

• Finally, restart your weblogic server. Source: Oracle Support Document ID 1682942.1

Unable to Start the Admin Server in Forms 12c, due to ORA-28000 Client-Idle System Event in Forms12c