Re: Changing APPS Password

Why do APPS and APPLSYS need to be the same?

No idea.  That's just the way it is.

-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA
morrow.james <at> gmail <dot> com




On Wed, Dec 10, 2008 at 4:23 AM, k srinivas <k.sridba@xxxxxxxxx> wrote:
> Hi Samuel .. Thanks a ton .. One more question, If I am not troubling you.
>
> Why apps and applsys passwd need to be same always,Can we not have different
> passwd for apps and applsys.
>
> Thanks in advance.
>
> On Wed, Dec 10, 2008 at 3:47 PM, Samuel Ma <malufeng@xxxxxxxxx> wrote:
>>
>> Hi Srinivas
>> For adadmin,as I know,account apps and applsys always shouled be have same
>> password,and when we use adadmin,I GUESS Oracle actually have two actions,
>> 1.connect using apps
>> 2.connect using applsys.
>> and FNDCPASS change them sometimes, you can have a test after u alter apps
>> and applsys.
>> Best Regards
>> Samuel
>>
>> On Wed, Dec 10, 2008 at 6:08 PM, k srinivas <k.sridba@xxxxxxxxx> wrote:
>>>
>>> Hi Samuel..
>>>
>>> Thanks a lot !!!   I have one more question which I had drafted earlier
>>> too .
>>>
>>>  * 1) when I change apps passwd by alter user statement..and do not
>>> change the apps passwd in the two files.When I connect through sqlplus and
>>> try connecting as apps with new passwd,it connects but
>>> When I run adadmin and when it prompts for apps passwd,it fails
>>> connecting with the new apps passwd.
>>>
>>>  * 2) When apps passwd is changed through FNDCPASS..and do not change the
>>> apps passed in the two files.When I connect through sqlplus and try
>>> connecting as apps with new passwd,it connects but
>>> When I run adadmin and when it prompts for apps passwd,it connects
>>> without any error.
>>>
>>> Can you pls explain why the difference in the above cases..
>>>
>>> Thanks in advance ...
>>>
>>> On Wed, Dec 10, 2008 at 2:48 PM, Samuel Ma <malufeng@xxxxxxxxx> wrote:
>>>>
>>>> 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: