Leave a Comment:
18 comments
In my openion FNDCPASS is better and supported method.
It also takes care of changing APPS and APPLSYS password at single shot. Only thing is we need to change the password of apps in CGIcmd.dat and wdbsvr.app.
Regards
Naresh
Naresh,
For FNDCPASS you need to supply existing apps password to change it.
Steps mentioned above are, if you fon’t know current apps password and can’t view or wrong entry in wdbsvr.app (I know forms launcher won’t work if apps password is wrong in wdbsvr.app but you can bypass it using dev60cgi/f60cgi)
ReplyGuys I am extremely sorry ,While writting i made a mistake . If you really confused .. with the password of Apps and it is not working after checking the password in wbsvr.app then we need to follow those steps.
ReplyBefore 11.5.10.2 changing the password of apps and applsys with “alter user …” not there were problems.
In 11.5.10.2 if we lose the password of apps and applsys, and the change is made by “alter user …” rather than FNDCPASS, it invalidates the user password for all users of the application. You will receive many complaints from users.
Regards.
Leonardo ,
I recent past i have tried the same and it was sucessfull , But after changing i have executed ..autoconfig.
ReplyWe also had similar kind of experience,in our case password of apps and applsys were not in sync. Then we changed the password to apps by updating encrypted_oracle_password in fnd_oracle_userid and dba_users table.
The update query with default encrypted password is given in 149196.1. Then used FNDCPASS to change password to the client standard passwords.
Regards
Naresh
Even we can do it in this way also the step which i have mentioned .. I have already done it.
ReplyHi,
“please back up the FND_ORACLE_ID and FND_USER tables before beginning”
Say for Eg: If APPS schema password is corrupted after running FNDCPASS and then if we restore only FND_ORACLE_ID and FND_USER tables is application will allow to connect? No.
I guess it will not becuase when we create a user it will update WF tables like wf_local_user_roles and wf_user_role_assignments .Please advice.
Regards
Durga
Hi Durga ,
guess it will not becuase when we create a user it will update WF tables like wf_local_user_roles and wf_user_role_assignments .Please advice.
————–
Which user you are talking about .. The application User …
ReplyHi Durga ,
Firstly i will start explaining about FNCPASS …
When we use FNDCPASS utility to change password Wht it Does :-
$ FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS
In the above command when we use SYSTEM token the next command it expects is Applsys username and password.
How does it work .
1.It validates the applsys password.
2. Re-encrypts all password in the FND_USER
3. Re-encrypts all password in the FND_ORACLE_USERID
4.Update applsys password in the FND_ORACLE_USERID
5.alter user command executed for oracle database changes as well
Now When we commit any mistake/corrupted in FNDCPASS and it stops working.
Application does not startup then you will need to rollback the changes and bring the Application system at the stage before you started the password reset procedure. That means you need to set the password back to its original value.
One quick method is to follow the same steps of resetting password using FNDCPASS utility while passing the original value of password.
The other dirty method (in case FNDCPASS does not work) is to restore the backup of the “FND_ORACLE_USERID” ,fnd_user table, i.e. rename the existing ‘’ FND_ORACLE_USERID” and rename the backup copy as the “FND_ORACLE_USERID”and fnd_user.
From the Database connected as SYSTEM DBA user alter all the Oracle Applications Product schema including APPS and APPLSYS to its original value.
Check login to the Oracle Database with the original set password to APPS and APPLSYS schema.
Stop the Application tier. Wait for all the process to terminate and then run autoconfig and Start it again.
Check login to the Oracle Application 11i System.
ReplyHi Autl,
My Production in intergrated with SSO and working fine now I need change apps password.
Iam having one Query, i.e after changing apps pwd in E-buzz, wheather I needs to change any thing in SSO server
Regards
Jaya Prakash
If i forgot apps password in R12.
How can i get it.
In 11i we have $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app file.
But in R12 i dont if we can get apps password from some file.
Please reply.
Thanks
ReplyVivek,
In R12 there is no way to retrieve apps password . If you forgot apps password reset it to new value using steps mentioned in metalink note # 419475.1 Removing Credentials from a Cloned EBS Production Database
hi Rajat,
i have commit one mistake by changeing apps password by useing this syntax:
SQL> alter user apps identified by ;
Please guide me the method is to follow for resetting password .
regards
sanjeev
@ Sanjeev,
If you know original apps password use again
SQL> alter user apps identified by old_passowrd;
and try fndcpass then to change password .
Replyyou can also use metalink note 744820.1 and 189367.1 on how to best secure your password.
ReplyIs it possible to change password of APPS by using alter statement?
Reply