Oracle ERP10.7-Change apps password issue

Recently, when dba B updated Oracle ERP10.7 TEST DB, an error occurred while changing the apps step, resulting in the inability to log on to ERP10.7 Form.

The troubleshooting section in the change ERP10.7 apps schema password method still cannot solve the problem:

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username = 'applsyspub'

 

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username IN ('apps ', 'applsys ');

 

UPDATE apps. fnd_user

SET encrypted_foundation_password

= 'Hangzhou ',

Encrypted_user_password = 'authorization'

WHERE user_name = 'sysadmin'

 

Alter user apps identified by apps;

Alter user applsys identified by apps;

 

During login, the system always prompts that the password is incorrect or the database is not connected.

 

 

Later, the above SQL password was updated according to the encrypted password of the official database, and the problem still could not be solved:

 

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username = 'applsyspub'

 

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username IN ('apps ', 'applsys ');

 

UPDATE apps. fnd_user

SET encrypted_foundation_password = 'authorization ',

Encrypted_user_password = 'authorization'

WHERE user_name = 'sysadmin'

 

Alter user apps identified by "xxxxxxxx ";

Alter user applsys identified by "xxxxxxxxxx ";

 

During login, the system always prompts that the password is incorrect or the database is not connected.

 

When dba B solves this problem, I found that when I change the apps password in the database to the apps password in the test database, I can log on to the database but cannot connect to the database when I select Responsibility. I tested it myself and found that it was true. Therefore, it can be judged that some changes were correct when dba B modified. What if I can get that the password for apps is testapps's encrypted password?

 

Later I thought of another dev db of ERP10.7, and the app password is also testapps. So I tried to update the above SQL statement with the encrypted password corresponding to testapps. After execution, I can log on to ERP10.7.

Everything is normal:

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username = 'applsyspub'

 

UPDATE apps. fnd_oracle_userid

SET encrypted_oracle_password =

'Authorization'

WHERE oracle_username IN ('apps ', 'applsys ');

 

UPDATE apps. fnd_user

SET encrypted_foundation_password

= 'Hangzhou ',

Encrypted_user_password = 'authorization'

WHERE user_name = 'sysadmin'

 

Alter user apps identified by testapps;

Alter user applsys identified by testapps;