Multi-level password change for Oracle EBS system

Source: Internet
Author: User

EBS system passwords are divided into four categories, and changing passwords requires compliance with regulations, specifications, and, in particular, backups.
1. operating system users, such as Root,ora,appl,grid. "Modify Method"use passwd this OS command to change the user password. such as:passwd Rootpasswd orapasswd Appspasswd Grid"Production password"pass1234"Precautions"None. If you forget the root password, you can log in to the OS in single-user mode to change the root password.
2. Database users, such as Sys,systemdatabase users, can be logged in with Sqlplus or other clients, and cannot log on from the ERP home page, with the database command alter user to make changes. ,"Modify Method"alter user SYS identified by pass1234;alter user system identified by pass1234;Caveats: Pre-change backup,"SYS user" CREATE TABLE sys.user$_20140506 as SELECT * from sys.user$;
3. With The ERP application system has linked DB users, such as Apps,applsys, AP, INV, GL and so on. to back up before modifying: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;
This type of user is a DB user and also an ERP system user. will be reflected in the user$, but also reflected in the Apps.fnd_oracle_userid. This type of user is divided into three categories, as follows.
3.1 Apps and Applsys users[Dba_users][Fnd_oracle_userid]The Fndcpass tool automatically sets apps to the same password as the Applsys user. [[email protected] ~]$ fndcpass Apps/apps 0 Y system/manager system applsyspass1234
Precautions :A. Stop the entire application layer, especially the concurrency manager, before changing the password. B. After the revision to look at the log, see if there are errors, not clear the error before, and after the revision of the ERP system can not normally log on, do not manually run the Auoconfig command,c. After the revision of the ERP is not normal, use the following methods to roll backINSERT 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 The method of modifying all module users at once is as follows:fndcpass apps/pass1234 0 Y system/pass1234 alloraclepass1234

3.3 This class is an EBS-managed non-basic module userA separate password modification is required. 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--user Ctxsys for data mining--used as Intermedia Text
fndcpass apps/pass12340 Y system/pass1234ORACLE "ODM"pass1234Fndcpass apps/pass12340 Y system/pass1234ORACLE "Ctxsys"pass1234

4.ERP Application System userswhen users log in to the ERP system from the Web. This type of user can log on to the Web site to modify, or let the sysadmin administrator help to modify, or let the administrator through the OS tools Fndcpass tools to modify. among them, the sysadmin is the most typical and the most privileged EBS administrator user, other users have such as O-tina. Wang these. This type of user is not a DB user and is not reflected in the DB dba_users table. can be from the apps.fnd_user. SysAdmin usersfndcpass Apps/apps 0 Y system/manager USER SYSADMINpass1234




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.