Help - Search - Members - Calendar
Full Version: How reset the user APPS in Oracle BS
Oracle DBA Forums > Oracle > Oracle Forum
Francisco Riccio
Hi everyone, i wish to reset the user APPS in the Oracle Business Suite but i have looking for in the metalink of Oracle but between the steaps i got it:

sql> select oracle_username, encrypted_oracle_password
from fnd_oracle_userid
where oracle_id in (0,1,900)

3. Compare the results to the following encrypted passwords for Oracle
Applications Release 10.7 where APPS password = APPS, APPLSYS password = APPS
and APPLSYSPUB password = PUB :

ORACLE_USERNAME ENCRYPTED_ORACLE_PASSWORD

APPS
B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA

APPLSYS
B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA

APPLSYSPUB
A8569A03E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA

4. If these encrypted values are not the same then backup FND_ORACLE_USERID and
FND_USER tables as follows:

sql> create table FND_ORACLE_USERID_BAK as
(select * from FND_ORACLE_USERID);
sql> create table FND_USER_BAK as (select * from FND_USER);

5. Reset the encrypted passwords using UPDATE in sqlplus:

sql> update FND_ORACLE_USERID set ENCRYPTED_ORACLE_PASSWORD =
'B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'
where ORACLE_USERNAME = 'APPS'

...

My question is: this value B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA' is a value that i must put, a constante, or what value i must put.

Thank you very much if someone can answer me it.
burleson
Hi,

I'm not an apps guru, but it notes:

QUOTE
If these encrypted values are not the same then backup FND_ORACLE_USERID and
FND_USER tables as follows, . . . Reset the encrypted passwords using UPDATE in sqlplus:


>> My question is: this value B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA' is a value that i must put, a constant?

Yes, that's the encrypted value of the default password!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.