Dear DBA-Mates, Hope
you all are doing Great Job!!!
We know this is very simple and easy to change the
sysadmin password in R12.1.3 but some people will may have confusion in it.
Because whenever I asked to change sysadmin password for
my junior team they will hesitate and afraid. So thought to lets share which
may useful here all.
Confusion:
Question: Do
we need to run Autoconfig?
Answer:
No.
Question: Do
we need to bounce the Application Services?
Answer:
No.
Note:
If found any issue then only need to restart
the Apache, Forms, Reports, 8.0.6 listener and concurrent manager services.
Question: Do
we need to change any others user’s password for this?
Answer:
No.
Simply, we can change the password from FNDCPASS utility
as shown below:
1. Run the env file.
$ . ./ora-data.blogspot.env
2. Cross check for correct server/host.
$ echo $TWO_TASK
ORA-DATA
$ FNDCPASS apps/<apps_password> 0 Y
system/<system_password> USER
SYSADMIN <new_sysadmin_password>
Log filename : L1234567.log
Report filename : O1234567.out
bash-3.2$ cat L1234567.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates.
All rights reserved.
FNDCPASS:
+---------------------------------------------------------------------------+
Current system time is 19-OCT-2019 06:52:00
+---------------------------------------------------------------------------+
Arguments
FNDCPASS
system/***** USER SYSADMIN *****
+----------------------------------------------------------------------------+
Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 19-OCT-2019 06:52:01
+---------------------------------------------------------------------------+
$ exit
exit
You have new mail in /var/spool/mail/ora-data
$ exit
logout
How to set password in pbrun
command in linux:
$pbrun ohsdba password-manager <Database_name>
-set sysadmin
What is the current 'sysadmin'
password?:<current_sysadmin_password>
Once more:<current_sysadmin_password>
$
Some more useful links:
What is PDB and CDB in oracle 12c
[Fixed] Weblogic Error: BEA-141281 unable to get file lock, will retry ...
Regards,
Fabulous, what a blog it is! This blog provides helpful information to us, keep it up.
ReplyDeleteWay to use proprietary policy language without Oracle Legal approval.
ReplyDelete
DeleteHi User,
Sorry didn't get you.
Regards,
ora-data Team
well written https://thedbadmin.com/how-to-change-apps-and-sysadmin-password-in-ebs-r12-1-x/
ReplyDelete