How to Change Apps and SYSADMIN Password in EBS R12.1.x

Table of Contents

How to Change APPS and SYSADMIN Password in EBS R12.1.x

In this post, I am going to give you simple steps to change Oracle E-Business suite apps and sysadmin user passwords. Steps are very clear and you can easily do it. However please test them in any non-prod environment first before running into a live production Oracle ERP system.

[su_box title=”Note” box_color=” #0074be” title_color=”#0174be”]#Stop E-Business suite/ Oracle EBS / Oracle ERP Application[/su_box]

Log in to Application box as ERP Linux user (applmgr) not on database box. If your App and DB tier is on the same Linux server than a log as an application Linux user.

Source the application profile or environment file.

erp_enviroment_file.env. or sh erp_enviroment_file.env

Stop the application services. In addition, if you are on a multi-tier ERP system stop all the applications expect database services.

cd $ADMIN_SCRIPT_HOME
sh adstpall.sh apps/<apps_password>

In case if you are not clear how many applications or database nodes you have in your ERP system. you can query the FND_NODES view.

Wait for some time and get all the application process stops. You can check the application
process/service status by the below commands. Make sure no other application services and processes are running

ps -eaf| grep '<epr linux user_name> or <applmgr>' | grep -v grep

If you want to kill all the process of from ‘applmgr /Linux ERP user‘ you can also use below commands but be Extra super dam careful. it will stop each and every process running from your user. If you have tested in non-prod than run it on prod or ignore it and wait for the process to clear on its own.

kill -9 -1

If you want to change SYSADMIN Password

FNDCPASS apps/<Apps schema password> 0 Y system/<System DB user Password> USER SYSADMIN <New_sysadmin_password>

Log filename : L9526340.log
Report filename : O9526340.out

It will create a log and out file. Make sure you read it properly in case if you see any error fix it and run the above command again.

Logfile output should look like this

$ view L9526340.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 14-OCT-2020 03:39:11

+---------------------------------------------------------------------------+

Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 14-OCT-2020 03:41:12

If you want to change Apps Password

FNDCPASS apps/<apps_old_password> 0 Y system/<DB_SYSTEM_Password> SYSTEM APPLSYS

Log filename : L19058975.log
Report filename : 12392395.out

It will create a log and out file. Make sure you read it properly in case if you see any error fix it and run the above command again.

Logfile output should look like this

$ view L19058975.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 14-OCT-2020 09:18:40

+---------------------------------------------------------------------------+

Working...

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 14-OCT-2020 09:18:49

+---------------------------------------------------------------------------+

[su_note note_color=”#0174be” text_color=”#ffffff” radius=”4″] IMP Note: Once apps password has changed make sure you modify apps password on all places where it has used like database link, third party applications which are connecting to EBS system as apps user.[/su_note]

[su_box title=”Note” box_color=” #0074be” title_color=”#0174be”]#Start E-Business Suite/ Oracle EBS / Oracle ERP Application[/su_box]

Start application services [1]. In addition, if you are on a multi-tier ERP system start all the applications services on each node.

Make sure the concurrent manager process is started. You can validate it by following commands [2].

[1]
cd $ADMIN_SCRIPT_HOME sh adstrtal.sh apps/<apps_password>

[2]
ps -ef| grep FNDLIBR

If your Oracle E-Business suite main page is opening and forms are opening properly you are done.

How to Become Oracle apps DBA ?
What does DBA mean?
150 Oracle DBA Interview Questions
Top 5 Future Technologies for Database Administrators (DBA) to learn in 2020
Top 5 Software Technology Trends in 2020 List