Saturday 2 November 2019

How to change sysadmin password FNDCPASS in R12.1.3

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,

4 comments:

  1. Fabulous, what a blog it is! This blog provides helpful information to us, keep it up.

    ReplyDelete
  2. Way to use proprietary policy language without Oracle Legal approval.

    ReplyDelete
    Replies

    1. Hi User,

      Sorry didn't get you.

      Regards,
      ora-data Team

      Delete
  3. well written https://thedbadmin.com/how-to-change-apps-and-sysadmin-password-in-ebs-r12-1-x/

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.