Logo Background

How To Change Oracle Application Password

  • By on February 1, 2009 | 1 Comment

    Based on Oracle Metalink 398942.1. Upon installation of Oracle Applications, a number of schema (sometimes called ORACLE schema) are present in the database. You do not need to create these schema; however, you should change the default passwords.
    These schema come from different sources and can be described as being of the following types:

    1. Schema that exist in every Oracle database (whether used by Oracle Applications or not) [ex: SYS,SYSTEM].

    2. A small set of schema used by shared components of Oracle Applications [for example, APPLSYSPUB,APPLSYS,APPS].

    3. A large set of schema provided by the individual products of Oracle Applications [for example, ABM,AHL,…,ZSA,ZX].

    4. A set of schema that belong to optional database features or third party products these fall into three subtypes:

    1. Used by and patched with Oracle Applications [for example, CTXSYS, PORTAL30].
    2. Used by Oracle Applications but patched only with the RDBMS [for example, MDSYS,ORDSYS]
    3. Not used by Oracle Applications [for example, SCOTT]

    At no time do any of the schema provided with Oracle Applications relate to a particular Oracle Applications user.

    All types of schema are used during run time operations of Oracle Applications and the schema of type 2, 3 & 4.1 are accessed during initial installation and patching.

    For schema passwords, Oracle Applications concerns itself with mainly three passwords for its schema:
    1. A password for APPLSYSPUB (also known as the GATEWAY user). The default password is ‘PUB’.
    2. A password shared between APPLSYS and APPS (also known as FNDNAM). The default password is ‘APPS’.
    3. A password for all of the product-specific base schema (type 3). The default password for these schema is same as the schema name.

    Important: You should change these passwords upon installation.

    To change all ORACLE (type 3) schema passwords:

    Use this command to change the passwords of all schemas provided by Oracle Application products.

    FNDCPASS 0 Y ALLORACLE 

    Use the above command with the following arguments. When specifying the ALLORACLE token, FNDCPASS expects the next argument to be the new password.

    logon : The Oracle username/password.

    system/password : The username and password for the SYSTEM DBA account.

    new_password : The new password.

    For example, the following command changes all ORACLE schema passwords to “WELCOME”:

    FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

    Patch 4926128 contains a SQL script that will list all open accounts with default password in your database.

    Previous
    Next
    » FNDCPASS Oracle Password Change Utility
  1. #1 zenux
    February 2, 2009 2:11 am

    Use the SQL script below to check on your active Oracle Schema: –

    select fav.application_short_name Short
    from fnd_application_vl fav, fnd_product_installations fpi
    where fav.application_id = fpi.application_id
    and fav.application_short_name NOT like ‘SYSADMIN’
    and fpi.status != ‘N’
    order by 1;

    Post ReplyPost Reply
Leave a Comment