AFPASSWD – New password utility in EBS 12.1.2

AFPASSWD:


In R12.1.1 and before oracle EBS Versions
EBS passwords are changed using FNDCPASS.

AFPASSWD Usage and Syntax:
 -h – Displays help.
From R12.1.2 Oracle has come up with
another Utility AFPASSWD for
the same purpose.
Advantage is that you can run AFPASSWD
utility from DB tier or from Midtier
where as FNDCPASS can only be run from midtier side.

AFPASSWD is an enhanced version of FNDCPASS, and includes the
following features:
     AFPASSWD
only prompts for passwords required for the current operation,
allowing
separation of duties between applications administrators and database administrators.
This also
improves interoperability with Oracle Database Vault. In contrast, the FNDCPASS
utility currently requires specification of the APPS and the SYSTEM usernames
and corresponding passwords, preventing separation of duties between
applications administrators and database administrators.
   
     When
changing a password with AFPASSWD, the user is prompted to enter the
New
password twice to confirm.
  
     AFPASSWD
can be run from the database tier as well as the application tier. In
contrast, FNDCPASS can only be run
from the application tier.

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-f <FNDUSER>]

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-o <DBUSER>]

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-a]

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-l <ORACLEUSER> [<TRUE>]
|[<FALSE>]]

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-L [<TRUE>] | [<FALSE>]]

AFPASSWD
[-c <APPSUSER>[@<TWO_TASK>]] [-s] <APPLSYS>

These options have the following functions:

-c
{APPSUSER}[@{TWO_TASK}]
– Specifies the connection string to use, the
Applications
user, and/or the value of TWO_TASK. This option can be use in
combination
with others. If it is not specified, default values from the environment
will be
used.
Note: The
password will be prompted for, and is not to be
provided
in the connection string.
-f
{FNDUSER}
– Changes the password for an Applications user. A username that
contains
spaces must be enclosed in double quotation marks; for example, “JOHN
SMITH”.

-o
{DBUSER}
– Changes the password for an Oracle E-Business Suite database
user.
Note: This
only applies to users listed in the FND_ORACLE_USERID
table, not database users in general.

 -a – Changes all Oracle (ALLORACLE)
passwords (except the passwords of APPS,APPLSYS,
APPLSYSPUB) to the same password, in the same way as the ALLORACLE
mode does in FNDCPASS.

 -l – Locks individual {ORACLE_USER}
users (except required schemas). {TRUE} =LOCK,
{FALSE} = UNLOCK.

 -L – Locks all Oracle (ALLORACLE) users
(except required schemas). {TRUE} =LOCK,
{FALSE} = UNLOCK.

 -s {APPLSYS} – Changes the password for
the APPLSYS user and the APPS user. This
requires the execution of autoconfig (in ALL-TIERS) to distribute the changes
on your instance
Ie:
DB-TIER and ADMIN-TIER.

Run autoconfig on db tier and application
tier after changing apps password:

  • October 8, 2012 | 55 views