Re: Changing APPS Password

Hi Srinivas
>* What happens if we donot change the apps passwd in the two files after
changing through FNDCPASS.
Apache Services may not be work correctly.

>* Why we cannot change through alter user statement and change the apps
passwd in those two files.
Because Oracle Application use APPS PASSWORD to encrypt end user's password
in fnd_user and oracle user's password in fnd_oracle_userid,
you can have a test when you use FNDCPASS to change password of APPS,the
column encrypted_oracle_password in two tables changed too.
but alter don't do this actions.

>* Why does forms donot open after changing apps passwd through FNDCPASS and
not changing the same in the two files.
the apps password in $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app is
incorrect,so Oracle use this password to decrypt password in
two tables or connect to database could occur errors.

in R12,none plain password storage in files,so we must run autoconfig after
changing password of apps.

Best Regards
Samuel


On Wed, Dec 10, 2008 at 4:16 PM, k srinivas <k.sridba@xxxxxxxxx> wrote:

> Folks,
>
> Thanks for the quick update.I know the procedure for changing apps passwd
> but my concern is
>
> * What happens if we donot change the apps passwd in the two files after
> changing through FNDCPASS.
> * Why we cannot change through alter user statement and change the apps
> passwd in those two files.
> * Why does forms donot open after changing apps passwd through FNDCPASS and
> not changing the same in the two files.
>
> Thanks in advance..
>
> On Wed, Dec 10, 2008 at 10:50 AM, NEELI-SC, Mamta <
> Mamta.NEELI@xxxxxxxxxxxxxx> wrote:
>
>>  Hi Srinivas,
>>
>>
>>
>> Below are the steps to reset the apps password.
>>
>>
>>
>> 1.Change the apps password using FNDPASS.
>>
>>
>>
>> 2.Update the new password in below files:
>>
>>
>>
>> $806_ORACLE_HOME/reports60/server/CGIcmd.dat
>>
>> $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
>>
>>
>>
>> 3.Run autoconfig.
>>
>>
>>
>> Regards
>>
>> Mamta
>>
>>
>>  ------------------------------
>>
>> *From:* ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:
>> ora-apps-dba-bounce@xxxxxxxxxxxxx] *On Behalf Of *Shankar .
>> *Sent:* Wednesday, 10 December 2008 12:02
>> *To:* ora-apps-dba@xxxxxxxxxxxxx
>> *Subject:* Re: Changing APPS Password
>>
>>
>>
>> Hi,
>>
>>
>>
>> If you are on 11i then the apps password will be hardcorded in this file.
>> Change it to the new password and run autoconfig and restart mid tier.
>>
>>
>>
>> $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
>>
>> Regards
>>
>> shankar
>>
>> On Wed, Dec 10, 2008 at 9:24 AM, k srinivas <k.sridba@xxxxxxxxx> wrote:
>>
>> DBAS,
>>
>>
>>
>> I have few questions related to changing apps password.
>>
>> 1) when I change apps passwd by alter user statement..When I connect
>> through sqlplus and try connecting
>> as apps with new passwd,it connects.
>> When I run adadmin and when it prompts for apps passwd,it fails connecting
>> with the new apps passwd.
>> When I open frontend,the login page opens but the forms session fails to
>> open..
>>
>> 2)When apps passwd is changed through FNDCPASS..When I connect through
>> sqlplus and try connecting
>> as apps with new passwd,it connects.
>> When I run adadmin and when it prompts for apps passwd,it connects without
>> any error.
>> When I open frontend,the login page opens but the forms session fails to
>> open..
>>
>> In both cases forms session fails to open..Can anybody explain the reason
>> behind this
>>
>> and why when I run adadmin in the former case it fails connecting with new
>> apps passwd but in the later case
>> when I change through FNDCPASS new apps passwd comes into effect.
>>
>>
>>
>> Thanks in advance ..
>>
>>
>>
>
>

Other related posts: