HELIOS BLOG

Helios Database Journey

How To Change The Password For The APPS and APPLSYS users

In this article i will define steps of “how we can change apps&applsys users password”.

For to can change apps&applsys users password, please follow below steps:

1. Shut down application services wiht adstpall.sh script

2. Change password wiht FNDPASS utulity as:

FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>

Example:

FNDCPASS apps/current_password 0 Y system/password SYSTEM APPLSYS newpassword

3. Dont forget to run autoconfig on dbtier than run it on  appstier wiht new password

4. Start up all application services with  adstrtal.sh

PS: Passwords for APPLSYS and the APPS schemas — including the MRC schema — must be the same. If you change the password for one, FNDCPASS automatically changes the others.

References:

How to Change Applications R12 Passwords using Applications Schema Password Change Utility (FNDCPASS)? [ID 437260.1]

How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in Unix [ID 159244.1]

Reklam
, , ,

Posted by:

Gunes Erol

http://apex.oracle.com/pls/otn/f?p=19297:4:1668120596920607::NO:4:P4_ID:4160

“How To Change The Password For The APPS and APPLSYS users” için 10 cevap

  1. jen Avatar
    jen

    Hi helios,

    I found it very useful, Although I am still busy to apply this in our PROD, and sometimes I am afraid I might mess it up by doing this.

    Maybe I will do this if I have enough courage.

    Thanks a lot,

    Jenny

    Cevapla
    1. guneserol Avatar
      guneserol

      I belive you can follow metalink notes which i mention here or this blog. This topic discussed before many time on and OTN Discussion forum, you can also check steps&advice from this forum site

      Cevapla
  2. jen Avatar
    jen

    Hi helios,

    Can you make an index page to all the contents of your blog please. I find it hard to find all topics you have written. Maybe you can put it all in the home page?
    or something like a INDEX LINK? to all topics.

    I hope it is not hard to do so. Because I want this blog
    as my master reference to all my topics of interests.

    Thanks a lot

    Jenny

    Cevapla
    1. guneserol Avatar
      guneserol

      Hi jenny,
      Thanks for your kind words. I will put index link on blog soon,also i will update this index list it when i will add new posts on blog.

      Cevapla
  3. brijesh Avatar
    brijesh

    Hi Helios,

    Is there any way to change apps password in release12 and not to run autoconfig ,I mean can we bypass autoconfig run after change apps password with FNDCPASS in release12.

    Thanks
    Brijesh

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      Hi Brijesh;

      Exact question is why you dont want to run Autoconfig? Is there any special reason?
      Steps are so clear in documentation. My answer for your question is No. Please check below doc:
      How to Change Applications R12 Passwords using Applications Schema Password Change Utility (FNDCPASS)? [ID 437260.1]

      Cevapla
  4. arvis Avatar
    arvis

    Hi Helios,
    before I would make changes to the user password APPS is by using a script

    FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS

    when the script is run display a notification message “killed”. whether to locate the error / errors in the script can use the method / Additional checks?

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      You can not find details if system doesn’t create trc file.

      Cevapla
  5. Norma Avatar
    Norma

    I need to change my password, since I got hacked

    Cevapla
    1. Gunes Erol Avatar
      Gunes Erol

      So follow post Norma

      Cevapla

Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

Gravatar
WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. ( Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. ( Çıkış  Yap /  Değiştir )

Vazgeç

Connecting to %s

%d blogcu bunu beğendi: