How to change the password of ORACLE ERP

This article will explain in detail how to change the password in ORACLE ERP. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

First of all, ERP users are divided into two categories, application users and database users, and database users are divided into two categories, ERP-related and ERP-independent

Application users: login users of the WEB page, such as sysadmin, asadmin

ERP related database users: such as APPS, AK, IBC, etc.

ERP-independent database users: such as system or those who simply use sqlplus > create user username

Query database users that have nothing to do with ERP

Select * from dba_users where username not in (select APPLICATION_SHORT_NAME from APPS.FND_APPLICATION_VL) and account_status='OPEN' order by user_id desc

Or

Select * from dba_users where username not in (select ORACLE_USERNAME from APPS.fnd_oracle_userid) and account_status='OPEN' order by user_id desc

However, it seems that the following is true, because the found ABM is not affected by FNDCPASS ALLORACLE changing the password.

Su-oracle

Sqlplus / as sysdba

Alter user system identified by manager01

Su-applmgr

FNDCPASS apps/123456 0 Y system/manager01 user 101004871 PwD20180207

-- change the password of user 101004871 of ERP WEB login interface to PwD20180207

-- the password for apps is 123456 and the password for the system is manager01.

FNDCPASS apps/123456 0 Y system/manager01 SYSTEM APPLSYS apps

Change the password of apps and applsys to apps,apps. The original password is 123456.

FNDCPASS apps/apps 0 Y system/manager01 ALLORACLE apps

-- change the password of all ERP related database users to apps

FNDCPASS apps/apps 0 Y system/manager01 oracle hwms 666666

-- individually modify the password of the ERP-related database user hwms to 666666

If the database user is not related to ERP, an error will be reported, such as APP-FND-02702: XX is not a valid oracle user.

To change an Oracle E-Business Suite user's password:

You can use this command to change an individual Oracle E-Business Suite user's password.

FNDCPASS 0 Y USER

For example, if you were changing the password for the user VISION to 'WELCOME', you would use the following command:

FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME

Logon The Oracle username/password.

System/password The username and password for the System DBA account.

Username The Oracle E-Business Suite username. For example, 'VISION'.

New_password The new password

To change the APPS and APPLSYS (type 2) schema password:

Use this command to change passwords for schemas that are used by shared components of Oracle E-Business Suite.

FNDCPASS 0 Y SYSTEM

For example, the following command changes the APPLSYS password to 'WELCOME'.

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

LogonThe Oracle username/password.

System/passwordThe username and password for the SYSTEM DBA account.

UsernameThe APPLSYS username. For example, 'applsys'.

New_passwordThe new password.

The above command appears to modify applsys, but in fact, both apps and applsys have been modified.

This is the end of this article on "how to change your password in ORACLE ERP". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.