Oracle ERP10.7-Change apps password issue

最近DBA 乙在更新Oracle ERP10.7 TEST DB時，在更改apps這一步驟出現問題，導致無法登陸ERP10.7 Form。

按照更改ERP10.7 apps schema密碼的方法中troubleshooting部分仍然無法解決問題：

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'A8569A03E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'

WHERE oracle_username = 'APPLSYSPUB'

 

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'B9538850E83205FA537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'

WHERE oracle_username IN ('APPS', 'APPLSYS');

 

UPDATE apps.fnd_user

SET encrypted_foundation_password

='46604573E6E9225944D883F2D19C35D104EF7640DADB90EBEB2A8CBBA5E6F143',

encrypted_user_password='B54AE935D06644B9537028E51FF45607EF1B69A699E085DF5D72D88AAB5E2DBA'

WHERE user_name ='SYSADMIN'

 

ALTER USER apps IDENTIFIED BY apps;

ALTER USER applsys IDENTIFIED BY apps;

 

登入時，總是提示密碼錯誤或者未串連資料庫。

 

 

後來按照正式庫的加密密碼去更新以上SQL的密碼，仍然無法解決問題：

 

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'C9FF96863EDA984423B654224282B846B6D1C23918CC6795083D6E68BF6D41F4'

WHERE oracle_username = 'APPLSYSPUB'

 

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'D2FFF7B50789B20623B654224282B846B6D1C23918CC6795083D6E68BF6D41F4'

WHERE oracle_username IN ('APPS', 'APPLSYS');

 

UPDATE apps.fnd_user

SET encrypted_foundation_password='4C653613DFBA081B44D883F2D19C35D104EF7640DADB90EBEB2A8CBBA5E6F143',

encrypted_user_password='D4E3E5B0068ED90723B654224282B846B6D1C23918CC6795083D6E68BF6D41F4'

WHERE user_name ='SYSADMIN'

 

ALTER USER apps IDENTIFIED BY "xxxxxxxx";

ALTER USER applsys IDENTIFIED BY "xxxxxxxxxx";

 

登入時，也總是提示密碼錯誤或者未串連資料庫。

 

在DBA乙解決這個問題的過程中，我發現當將DB中apps更改成測試庫的apps密碼時，登入時可以登入但是選擇Responsibility時出現無法串連資料庫。自己也測試了一下，發現果然如此。由此，可以判斷DBA乙修改時部分更改正確。如果才能得到apps密碼是testapps的加密密碼呢？

 

後來想到還有一個ERP10.7的 DEV DB，apps密碼也是testapps，於是嘗試將testapps對應的相關加密密碼去更新以上SQL，執行後，ERP10.7可以登入。

一切正常：

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'39FADD8F85E2AE444AF3EADE5BC3A6DD81078F3FD374CB9F83D0072B3A879B5E'

WHERE oracle_username = 'APPLSYSPUB'

 

UPDATE apps.fnd_oracle_userid

SET encrypted_oracle_password=

'3DEACCDBC4B2FE174AF3EADE5BC3A6DD81078F3FD374CB9F83D0072B3A879B5E'

WHERE oracle_username IN ('APPS', 'APPLSYS');

 

UPDATE apps.fnd_user

SET encrypted_foundation_password

='53754674A7B9720A44D883F2D19C35D104EF7640DADB90EBEB2A8CBBA5E6F143',

encrypted_user_password='24E6AEB9BDB6EF074AF3EADE5BC3A6DD81078F3FD374CB9F83D0072B3A879B5E'

WHERE user_name ='SYSADMIN'

 

ALTER USER apps IDENTIFIED BY testapps;

ALTER USER applsys IDENTIFIED BY testapps;