FNDCPASS is a utility to change/reset oracle application user product(GL,AP and etc) schema passwords,Application(sysadmin,vision,dbateam and etc) user passwords and apps/applsys password.
FNDCPASS utility we use on Concurrent Manager Node.
We always change applsys password not apps.
APPS and APPLSYS passwords are always same.Changing applsys password will automatically change the apps password.
FNDCPASS logs are generated in the current directory.
FNDCPASS executable located in the below location.
[applmgr@apps bin]$ ls -tlrh $FND_TOP/bin/FNDCPASS
-rwxr-xr-x 1 applmgr dba 1.3M Mar 30 2009 /u02/apps/apps_st/appl/fnd/12.0.0/bin/FNDCPASS
[applmgr@apps bin]$
Changing APPLSYS password in Oracle Application 11i
=========================================
Process
=====
1. Shutdown web/forms services..
2. Shutdown the concurrent node.
3.To check syntax
use FNDCPASS and press enter it will give you the syntax.
[applmgr@apps bin]$ FNDCPASS
Usage: FNDCPASS logon 0 Y system/password mode username new_password
where logon is username/password[@connect]
system/password is password of the system account of that database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
[applmgr@apps bin]$
4.Change applsys password
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS welcome123
Note :* Changing the APPLSYS password automatically changes the APPS password.
Once you changed the applsys password in Oracle application 11i you to run autoconfig which in turn update the apps password in the below files if exists.If you don't want to run autoconfig just go and update below files if exists.
1. $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
2. $FND_TOP/resource/wfmail.cfg
3.$ORACLE_HOME/reports60/server/CGIcmd.dat
5.Connect to database as apps schema.
6.Start the concurrrent manager script.
7.Start web/forms services.
8.Submit a concurrent request and check that request completes successfully.
****************
Following activities will take place when we changed applsys password.
(1) applsys validation. (make sure APPLSYS name is correct)
(2) re-encrypt all password in FND_USER
(3) re-encrypt all password in FND_ORACLE_USERID
(4) update applsys’s password in FND_ORACLE_USERID table.
(5) Update apps password in FND_ORACLE_USERID table.
Changing APPLSYS password in Oracle Application R12
=====================================================
Process
======
1. Shutdown all the application nodes.
2. Shutdown the concurrent node.
3.To check syntax
use FNDCPASS and press enter it will give you the syntax.
[applmgr@apps bin]$ FNDCPASS
Usage: FNDCPASS logon 0 Y system/password mode username new_password
where logon is username/password[@connect]
system/password is password of the system account of that database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
[applmgr@apps bin]$
4.Change applsys password
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS welcome123
Note :* Changing the APPLSYS password automatically changes the APPS password.
5.Connect to database as apps schema.
6.Start the concurrrent manager script.
7.Shutdown all the application nodes.
8.Submit a concurrent request and check that request completes successfully.
Note: After changing the apps password autoconfig is not require in R12 as it doesn't store apps password in the flat files.
Lets do it practically.
=======================
1)Bring down application web/forms services.
[applmgr@apps ~]$ ps -fu applmgr|grep -i http
[applmgr@apps ~]$
[applmgr@apps ~]$
2)Make sure no concurrent manager process is running.
[applmgr@apps ~]$ ps -fu applmgr|grep -i fnd
applmgr 1002 27309 0 15:14 pts/3 00:00:00 grep -i fnd
[applmgr@apps ~]$
3.To check syntax
use FNDCPASS and press enter it will give you the syntax.
[applmgr@apps bin]$ FNDCPASS
Usage: FNDCPASS logon 0 Y system/password mode username new_password
where logon is username/password[@connect]
system/password is password of the system account of that database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
[applmgr@apps bin]$
4.Change applsys password
[applmgr@apps ~]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS abdul123
Log filename : L393344.log
Report filename : O393344.out
[applmgr@apps ~]$ ls -tlrh L393344.log
-rw-r--r-- 1 applmgr dba 661 Apr 28 14:55 L393344.log
[applmgr@apps ~]$ cat L393344.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
module:
+---------------------------------------------------------------------------+
Current system time is 28-APR-2013 14:55:51
+---------------------------------------------------------------------------+
Working...
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 28-APR-2013 14:55:51
+---------------------------------------------------------------------------+
[applmgr@apps ~]$
Note:FNDCPASS log is generated in the current directory.
5.Connect to database as apps schema.
[applmgr@apps ~]$ sqlplus apps/abdul123
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Apr 28 15:18:30 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "APPS"
SQL> select sysdate from dual;
SYSDATE
---------------
28-APR-13
SQL>
6.Start the concurrrent manager script.
[applmgr@apps scripts]$ ps -fu applmgr|grep -i fnd|wc -l
12
[applmgr@apps scripts]$
7.Shutdown all the application nodes.
[applmgr@apps scripts]$ ps -fu applmgr|grep -i http|wc -l
11
[applmgr@apps scripts]$
8.Submit a concurrent request and check that request completes successfully.
i submited the request,its working fine.
****************
Following activities will take place when we changed applsys password.
(1) applsys validation. (make sure APPLSYS name is correct)
(2) re-encrypt all password in FND_USER
(3) re-encrypt all password in FND_ORACLE_USERID
(4) update applsys’s password in FND_ORACLE_USERID table.
(5) Update apps password in FND_ORACLE_USERID table.
Thanks for watching !!!!
No comments:
Post a Comment