Unable to alter user APPS_NE to change password while changing APPS password using FNDCPASS
Issue:
Changing apps password using FNDCPASS fails with below error
APP-FND-02704: Unable to alter user APPS_NE to change password.
Oracle error 28003: has been detected in alterpassword2.
Command to change APPS Password.[Ensure to shut down Application services before changing apps password]
FNDCPASS apps/<apps_pwd> 0 Y system/<password> SYSTEM APPLSYS <new_apps_password>
Error Message from Log File:
+—————————————————————————+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+—————————————————————————+
Current system time is 10-APR-2024 18:43:36
+—————————————————————————+
Arguments
FNDCPASS system/***** SYSTEM APPLSYS *****
+—————————————————————————-+
Working…
APP-FND-02704: Unable to alter user APPS_NE to change password.
Oracle error 28003: has been detected in alterpassword2.
+—————————————————————————+
Concurrent request completed
Current system time is 10-APR-2024 18:43:39
+—————————————————————————+
Cause:
Issue is due to Password_verify_function enables in dba_profiles for APPS,APPLSYS,APPS_NE users
Solution:
Disable the password verify function for APPS,APPLSYS,APPS_NE users in database profiles.
- Identify the database profile for APPS,APPLSYS,APPS_NE users using the below query.
SELECT USERNAME,PROFILE FROM DBA_USERS where USERNAME in (‘APPS’,’APPLSYS’,’APPS_NE’);
SELECT PROFILE,VALUE FROM DBA_PROFILES WHERE PROFILE=’&profile for user’;
- Disable password verify function
alter profile <profile_name> limit PASSWORD_VERIFY_FUNCTION null;
- Run the FNDCPASS command to change password.
FNDCPASS apps/<apps_pwd> 0 Y system/<password> SYSTEM APPLSYS <new_apps_password>
- After changing apps password, run autoconfig on Middle tier and update EBS datasource for R12.2.x
You can follow the below steps to update apps password in EBS Datasource:
From EBS 12.2.x versions, whenever we change apps password we need to update the new apps password in EBS Datasource. Otherwise managed servers wont come up.
Steps to update apps password in Weblogic datasource for EBS 12.2x, post AD-TXK 7:
- Start Only Admin server,Do not start any other services
$. ./EBSapps.env RUN
$ cd $ADMIN_SCRIPTS_HOME
$adadminsrvctl.sh start
- Update apps password in Datasource from backend:
$perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl
When prompted, select the “updateDSPassword” option.
Sample screen output:
perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl
Please select from list of valid options
updateDSPassword – Update WebLogic Datasource Password
updateDSJdbcUrl – Update WebLogic Datasource Connection String
Enter Your Choice : updateDSPassword
Enter the full path of Applications Context File [DEFAULT -]:
Enter weblogic admin server password:
Enter the APPS user password:
Follow below steps to update the apps password in EBS Datasource from Weblogic console
In Oracle WebLogic Server, Enterprise Manager Fusion Middleware Control Console is used to manage and configure data sources, including updating passwords for datasources in Oracle E-Business Suite (EBS). Here are general steps to update the password for an EBS datasource in WebLogic Console:
- Access WebLogic Console:
Open a web browser and navigate to the WebLogic Console. The URL format typically looks like: http://<hostname>:<port>/console
- Login:
Log in with your credentials.
3.Navigate to JDBC Data Sources:
In the left navigation pane, go to “Domain Structure” and then select “Services” -> “Data Sources.”
4.Select the EBS Datasource:
Locate and click on the EBS datasource for which you want to update the password.
5.Change Password:
Go to the “Configuration” tab and find the section related to database connection properties.
Update the password field with the new password.
6.Test the Connection:
After updating the password, it’s a good practice to test the connection to ensure that the new password is working.
7.Save Changes:
Save your changes.
8.Activate Changes:
In the left navigation pane, click on “Deployments” and then select “Change Center.”
Click “Lock & Edit” to make changes.
After making changes, click “Activate Changes” to apply the new configuration.
9.Restart the Server (if necessary):
Depending on your configuration, you might need to restart the server for the changes to take effect.
It’s important to note that these steps may vary slightly based on the version of Oracle WebLogic Server and EBS you are using. Always refer to the official documentation for your specific versions for accurate and detailed instructions.
Additionally, before making any changes, it’s recommended to take proper backups and consult with your system administrator or Oracle support if you have any concerns.
