Oracle Error 1403 In Changepassword
Contents |
change password of Product Schema we got the below error in the FNDCPASS log. bash $> FNDCPASS error in password verification for apps apps/LPG 0 Y system/CNG ORACLE XXC K3r Log filename : L7339701.log
Error In Password Verification For Apps Fndcpass
Report filename : O7339701.out bash $> cat L7339701.log +---------------------------------------------------------------------------+ Application Object Library: Version : 12.0.0 Copyright oracle error 28003: has been detected in alterpassword2. (c) 1979, 1999, Oracle Corporation. All rights reserved. module: +---------------------------------------------------------------------------+ Current system time is 09-JUL-2011 04:58:10 +---------------------------------------------------------------------------+ APP-FND-02704: Unable to alter user XXC to change password. APP-FND-01564: this password is not managed by oracle applications so it can not be changed here ORACLE error 1403 in changepassword Cause: changepassword failed due to ORA-01403: no data found. The SQL statement being executed at the time of the error was: and was executed from the file &ERRFILE. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 09-JUL-2011 04:58:10 +---------------------------------------------------------------------------+ Troubleshooting and Solution Initially looking at the error, we concentrated our
Fndcpass Was Not Able To Decrypt Password For User During Applsys Password Change.
efforts in the error ‘ORA-01403: no data found' but could not find any significant lead. Then we checked if the schema XXC was a oracle product schema or a database user only. The below query confirmed that it was a product schema and user had not expired nor was it disabled. Select oracle_id,oracle_username,creation_date,last_update_date from apps.fnd_oracle_userid ='XXC'; Select user_id,username, account_status,profile,created, ,password,expiry_date from dba_users where username = 'XXC'; As the user was present in the apps.fnd_oracle_userid table it was confirmed that we must use the FNDCPASS to change password and not alter user command, so we had a issue with FNDCPASS. We then concentrated on the error ‘APP-FND-02704: Unable to alter user XXC to change password'. We found the profile of the user XXC from the dba_users was DEFAULT. When we checked the PASSWORD_VERIFY_FUNCTION of the value for profile the DEFAULT it was set to PASSWORD_DO_NOT_CHANGE. We temporarily changed the PASSWORD_VERIFY_FUNCTION of the value for profile the DEFAULT to NULL and ran the FNDCPASS a
Blog Oracle MySQL News & Events Oracle Applications Amazon Web Services Jeremiah Wilton's Oradeblog OurSQL Community Podcast Remote working... unable to change the password for fnd_user sysadmin DBA Team viewer Whitepapers About Us Philosophy The Blue Gecko Teams Employment app-fnd-01564: oracle error 1017 in afpcoa Opportunities Partners News Press Contact Us April 21, 2009 by cedwards FNDCPASS doesn't always use the SYSTEM password
Fndcpass Command Not Found
FNDCPASS does not check the system password when used to change an applications user account. We can check this with a simple test. First, we’ll change the SYSTEM password http://appsdbatechstuff.blogspot.com/2011/07/fndcpass-erroring-out-with-app-fnd.html to the default value “manager”: [code language="plain"][applmgr@appsrv01 ~]$ sqlplus system SQL*Plus: Release 8.0.6.0.0 - Production on Thu Apr 23 13:10:17 2009 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining Scoring Engine options SQL> alter user system identified by manager; User http://www.bluegecko.com/fndcpass-doesnt-always-use-the-system-password/ altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining Scoring Engine options [applmgr@appsrv01 ~]$ [/code] Next, we’ll use FNDCPASS to change the SYSADMIN application password using an incorrect value for the SYSTEM password: [code language="plain"][applmgr@appsrv01 ~]$ FNDCPASS apps/apps 0 Y system/badpassword USER SYSADMIN sysadmin Log filename : L4203491.log Report filename : O4203491.out[/code] If we cat the log file, we can see the password change was successful: [code language="plain"][applmgr@appsrv01 ~]$ cat L4203491.log +--------------------------------------------------+ Application Object Library: Version : 11.5.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. module: +--------------------------------------------------+ Current system time is 23-APR-2009 13:11:39 +--------------------------------------------------+ +--------------------------------------------------+ Concurrent request completed successfully Current system time is 23-APR-2009 13:11:39 +--------------------------------------------------+ [/code] Next, we’ll try to change the GL schema password using the same incorrect SYSTEM password: [code language="plain"][applmgr@appsrv01 ~]$ FNDCPASS apps/apps 0 Y system/badpassword ORACLE GL gl Log filename : L4203493.log Report filename : O4203493.out[/code] This time, the log shows failure because of an inability to connect as SYSTEM: [code language="plain"][applmgr@appsrv01 ~]$ cat L4203493.log +--------------------------------------------------+ Appl
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a https://community.oracle.com/thread/2528938?start=15&tstart=0 title. You can not post a blank message. Please type your message http://troubleshootingappsdba.blogspot.com/2008/02/app-fnd-02704-unable-to-alter-user-apps.html and try again. More discussions in LCM: 11i Install/Upgrade All PlacesOracle ApplicationsE-Business SuiteE-Business Suite TechnologyLCM: 11i Install/Upgrade This discussion is archived 1 2 Previous Next 25 Replies Latest reply on May 20, 2013 5:37 PM by Hussein Sawwan-Oracle Go to original post This content has been marked as final. oracle error Show 25 replies 15. Re: EBS password - 500 Internal Server Error - FNDCPASS was not able to decrypt Hussein Sawwan-Oracle May 15, 2013 2:43 AM (in response to user558643) I edited the $CONTEXT_NAME.xml file adding the passwords as follows:
to change password You might encounter this error while changing apps or other product password using FNDCPASS.+---------------------------------------------------------------------------+ Working... APP-FND-02704: Unable to alter user APPS to change password. +---------------------------------------------------------------------------+ Concurrent request completed Look at two things:1. Never start your password other than Alphabatic value.Even if it doesn't work.2. change your profile back to default and run FNDCPASS again.It worked for me...Happy Troubleshooting !!! Posted by Sundeep Dubey at 8:36 AM 3 comments: Mahesh said... Hi Sandeep,How do we change the profile back to the default?.. August 12, 2008 at 10:08 PM Sundeep Dubey said... Hi Mahesh, I was talking about default profile at database level, if by any chance you made any changes in profile for user. Check in DBA_PROFILES.Thanks August 12, 2008 at 10:22 PM sean poulter said... thanks, it resolved my issue by not having special character in the password!! August 26, 2009 at 6:11 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Sundeep Dubey Delhi, India Hi, its me Sundeep Dubey, working as Oracle Apps DBA from last 15 years. I treat myself as strong troubleshooter for any Oracle Apps DBA issue. Had experience in FMW as well. View my complete profile Ask Question Here Google Group - Troubleshooting AppsDBA Blog Archive ► 2011 (3) ► March (1) ► February (2) ► 2010 (5) ► October (2) ► June (1) ► March (1) ► February (1) ► 2009 (28) ► December (3) ► November (2) ► October (5) ► September (1) ► August (1) ► July (1) ► June (2) ► May (2) ► April (3) ► March (1) ► February (4) ► January (3) ▼ 2008 (62) ► December (3) ► November (2) ► October (3) ► September (3) ► August (8) ► July (5) ► June (7) ► May (5) ► April (9) ► March (2) ▼ February (15) Orphan processes in Oracle databases Password expiring Alert Having issues with JVM APP-FND-02704: Unable to alter user Apps to change... Good tool for troubleshooting - HTTPheaders ORA -