Tuesday 21 March 2017

Oracle R12/11i EBS Password change

Log on to Server

Log in to applmgr or owner of apps

Run apps environment variable

[oracle@oracle12 appl]$. ./APPSPROD_oracle12.env

Stop the application

Change Oracle APPS user password

Ex:-

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

New apps  password will be set to WELCOME

Note:- before change the apps password you should know the system password,
You can check system password whether is correct using adadmin tool

Note:-
if you don’t know the system password please
use the below mention step to reset the system user password


Change all ORACLE R12 Schema passwords: (Ex :- AP,AR,GL,)

Ex:-

$FNDCPASS apps/apps 0 Y system/system ALLORACLE WELCOME

New  AllOracle password will be set to WELCOME   (EX:- AP,AR.GL,CE )

Note:- After change any password please run the autoconfig for application Tier

To change an Oracle Applications user's password


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


Change Oracle system user password

Ex:-
su oracle
sqlplus / as sysdba

SQL>alter user system identified by manager

New password will be set to manager

Change root user password on Linux

Ex:-
[root@oracle12 ~]# passwd
Changing password for user root.
New UNIX password:

Change Oracle user password on Linux

Ex:-
[root@oracle12 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Source: Internet/Internal Research 

No comments:

Post a Comment