Hey
DBA-Mates,Hope you
all are doing great.
Recently,
one of my junior team mates learned How to change APPS
Password in R12.1.3. He is a junior and newly joined.
We asked
him to change
the APPS and SYSADMIN password after
the clone.
But he
was not done earlier and asked me some basics questions and its good. Even he
google and checked but he was having some doubts.
He asked
me some basics questions as:
1. Will
we run FNDCPASS from SQL> prompt or $
prompt?
2. Apps Services should be UP or Down?
He knows
the FNDCPASS uses to change the APPS
user password but he have not done yet, so he got confused.
Then I
thought it may be basics and easy lets share with you all guys.
Please
find the below Steps:
1. FNDCPASS should
be run from $ prompt.
2. Apps Services
should be Down.
3. After changing
Apps password through FNDCPASS, we
should run autoconfig.
4. APPS
and APPLSYS password will be same.
Steps to
change the Apps password through FNDCPASS:
1. Run
the env file.
$ .
./ora-data.blogspot.env
2. Cross
check for correct server/host.
$ echo
$TWO_TASK
ORA-DATA
3. Changing the
APPS password through FNDCPASS:
$ FNDCPASS apps/<apps_oldpassword> 0 Y
system/<system_pass> SYSTEM APPLSYS <apps_newpassword>
Log
filename : L2331757.log
Report
filename : O2331757.out
$
4. Always check the log because sometimes it will through
error which you cannot know without checking log file.
$ cat L2331757.log
+---------------------------------------------------------------------------+
Application
Object Library: Version : 12.1
Copyright
(c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+---------------------------------------------------------------------------+
Current
system time is 15-JUL-2018 10:15:50
+---------------------------------------------------------------------------+
Working...
FNDCPASS completed successfully.
+---------------------------------------------------------------------------+
Concurrent
request completed successfully
Current
system time is 15-JUL-2018 10:15:58
+---------------------------------------------------------------------------+
$
5. Changing the
SYSADMIN password :
$ FNDCPASS apps/<apps_newpassword> 0 Y system/dev0dba USER SYSADMIN <password
for sysadmin>
Log
filename : L2471757.log
Report
filename : O2471757.out
6. Now check the logfile.
$ cat L2471757.log
+---------------------------------------------------------------------------+
Application
Object Library: Version : 12.1
Copyright
(c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+---------------------------------------------------------------------------+
Current
system time is 15-JUL-2018 10:16:42
+---------------------------------------------------------------------------+
Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.
+---------------------------------------------------------------------------+
Concurrent
request completed successfully
Current
system time is 15-JUL-2018 10:16:46
+---------------------------------------------------------------------------+
$
Note: Once completed , please check and connect with APPS user with new password then start the services.
Regards,
ora-data
Team
I am waiting for next article sir.Visit us:
ReplyDeleteOracle Fusion HCM Training in Hyderabad
Thanks for sharing nice information for more do visit us at
ReplyDeleteOracle Apps DBA Training in Texas
Rattling informative and wonderful structure of articles, now that's user friendly (:
ReplyDelete.
WOW just what I was searching for. Came here by searching for losing weight
ReplyDelete