Maison >base de données >tutoriel mysql >Oracle ERP10.7-Change apps password issue
最近DBA 乙在更新Oracle ERP10.7 TEST DB时,在更改apps这一步骤出现问题,导致无法登陆ERP10.7 Form。按照更改ERP10.7 apps sch
最近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;