Oracle EBS System Multi-Level Password Change

The EBS system password is divided into four types. The change of password must comply with the regulations and specifications, especially backup.
1. Operating System users, such as root, ora, appl, and grid users.[Modification method] use the OS command passwd to change the user password. For example, passwd rootpasswd orapasswd appspasswd grid [production Password] pass1234 [note] none. If you forget the root password, you can log on to the OS in single-user mode to change the root password.
2. database users, such as SYS and SYSTEMDatabase users can log on with sqlplus or other clients, and cannot log on from the ERP homepage. Use the database command alter user to make changes ., [Modification method] alter user sys identified by pass1234; alter user system identified by pass1234; Note: Back up before change, [sys user] create table sys. user $ _ 20140506 as select * from sys. user $;
3. DB users associated with ERP application systems, such as APPS, APPLSYS, AP, INV, and GL.Backup before modification: create table apps. fnd_user_20140506 as select * from apps. fnd_user; create table apps. fnd_oracle_userid_20140506 as select * from apps. fnd_oracle_userid;
These users are DB users and ERP users. It is reflected in USER $ and apps. fnd_oracle_userid. There are three types of users.
3.1 APPS and APPLSYS users[Dba_users] [fnd_oracle_userid] The FNDCPASS tool automatically sets the passwords of APPS and APPLSYS users to the same. [Appl @ erp ~] $ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYSpass1234
Note: a. Stop the entire application layer, especially the concurrency manager, before changing the password. B. after modification, check the log to see if any error is reported. Do not manually run the Auoconfig command, c. after modification, the ERP system becomes abnormal. Use the following method to roll back insert into apps. fnd_user select * from apps. fnd_user_yyyymmdd; insert into apps. fnd_oracle_userid select * from apps. fnd_oracle_userid_yyyymmdd; commit;
3.2 Basic module usersFNDCPASS apps/pass12340 Y system/pass1234 ORACLE GLpass1234 one-time modification of all module users: FNDCPASS apps/pass1234 0 Y system/pass1234 ALLORACLEpass1234

3.3 This type is a non-basic Module User managed by EBS.You must modify the password separately. SQL> select ORACLE_USERNAME from APPLSYS. FND_ORACLE_USERID where READ_ONLY_FLAG = 'X' and ORACLE_USERNAME in (select USERNAME from SYS. DBA_USERS );
ORACLE_USERNAME ------------------------------ ODM -- CTXSYS, a user who uses data mining, and interMedia Text
FNDCPASS apps/pass12340 Y system/pass1234 ORACLE "ODM" pass1234FNDCPASS apps/pass1234 0 Y system/pass1234 ORACLE "CTXSYS" pass1234

4. ERP application system usersUsed when users log on to the ERP system from the Web. These users can log on to and modify the settings on their own through the web page, or have the SYSADMIN administrator help with the modification, or the administrator can use the OS tool FNDCPASS to modify the settings. Among them, SYSADMIN is the most typical, is also a very large EBS administrator user, other users such as O-TINA.WANG. These users are not DB users and are not reflected in DB dba_users tables. From apps. fnd_user. Sysadmin user fndcpass apps/apps 0 Y system/manager USER SYSADMINpass1234