Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to 11.5.10.2
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
    IdM
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management


  • We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Change Oracle APPS Password : FNDCPASS
    Tuesday, January 23, 2007
    Register for R12 upgrade
    With Product Family ATG version H Roll Up 3 , Oracle Introduced New Option in FNDCPASS which is ALLORACLE to Change password of all Schema provided by Oracle Application products. These are basically below three category password
    --These are mainly schema password for products like AP, GL, AR (These are also termed as of mode ORACLE )
    --Password for APPLSYS and APPS (Same password for both schema) . This is also called as Apps Password (used during CM startup)
    --Password for account APPLSYSPUB

    How to change Oracle Applications Products/Schema Password including APPS ?
    As most of you might already be aware that you use FNDCPASS utility on Concurrent Manager Node.
    FNDCPASS logon 0 Y system/password mode username new_password
    Where MODE is SYSTEM/USER/ORACLE/ALLORACLE (Introduced with patch 4745998)


    Will ALLORACLE mode change other schema passwords like CTXSYS, MDSYS, PORTAL..,SYS, SYSTEM, SCOTT, Application User like AtulKumar .... ??

    No ALLORACLE mode will change only schemas mentioned in paragraph 1 and will not change passwords for schemas like CTXSYS, MDSYS, SYS, SYSTEM.....

    Is previous Mode SYSTEM/USER/ORACLE still available with FNDCPASS ?
    Yes

    How to get ALLORACLE mode in FNDCPASS ?
    Apply Oracle Apps patch 4745998

    What files to change after changing Apps Password ?
    You use FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME to change Apps Password
    --Once you change apps password you need to change apps password stored in file wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg

    --In some instances you might have to change in CGIcmd.dat at $ORACLE_HOME/reports60/server

    --You also have to change in any custom concurrent manager start up script (If you have any)

    Added on 14th August 2007

    --If you have configured E-Business Suite with 10g Application Server SSO/OID then after changing APPS password, update provisioning profile with new apps password

    oidprovtool operation=modify \
    ldap_host={OID Server hostname} ldap_port={OID Server Port} \ ldap_user_dn="cn=orcladmin" ldap_user_password={orcladmin Password} \ application_dn=" {The LDAP distinguished name of the application}" \ interface_connect_info={E-Business Suite connect info of the format, host:port:Sid:username:password}


    after changing Apps password bounce Concurrent Managers.

    Related
    Following Metalink Notes are useful & related to Oracle Applications or Apps Password
    --303621.1 How to Change and Which Apps Database Users Passwords Can Be Changed in a Multi-Node Apps Installation?
    --159244.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

    Labels:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 12:37 PM  
    19 Comments:
    • At 10:00 AM, Blogger Suresh Lakshmanan said…

      good one atul.

       
    • At 3:23 PM, Blogger ashok said…

      good one atul...should APPS and APPLSYS have same password??

       
    • At 7:01 PM, Blogger Atul Kumar said…

      Yes, APPS and APPLSYS should have same password

       
    • At 7:48 PM, Blogger shiva said…

      Hi Atul,

      How to secure apps password ??
      apps password will be displayed with the following incidents:
      1) echo $1 or echo $* in any script
      2) workflow builder error issue
      3) while trasfering alert, we have to give apps password (how to decript the password)
      Please let us know in any other ways, users/developers can able to know the apps password in secured instance

      Thanks in advance, Shiva

       
    • At 8:01 PM, Blogger shiva said…

      Hi Atul,

      How to secure production instance apps password ??

      It will display with the following cases:
      1) echo $1 or echo $* in the script (encrypt is not enabled)
      2) workflow builder connection error will display apps password
      3) while transferring alert, it will display password (is there any way to decript the password)
      4) I think oracle has fixed in ad patch application log / report server
      Please let us know, how to secure our production instances with this issue.

      Thanks sir,
      Shiva
      6)

       
    • At 10:55 PM, Blogger Atul Kumar said…

      Shiva,
      Can you elaborate more on these apps password issues ?

      specially

      1) echo $1 or echo $* in the script (encrypt is not enabled)

      &

      3) while transferring alert, it will display password (is there any way to decript the password)

       
    • At 1:20 AM, Blogger shiva said…

      Hi Atul,

      What are all the precautions to be taken to secure apps password.

      Thanks
      Shiva

       
    • At 8:23 AM, Blogger Samer said…

      Hi Atul,


      how we can bounce the CM? and how many ways to do the same?

       
    • At 8:04 PM, Blogger Atul Kumar said…

      Use adcmctl.sh or Administer CM screen from frontend.

       
    • At 7:27 PM, Blogger naveed said…

      Hi Atul,

      Why do we need to have same passwords for both apps and applsys.

      And when we change the passwords for any one either apps or applsys do we manually need to make them in sync.

      Thanks,
      Naveed.

       
    • At 7:33 PM, Blogger Atul Kumar said…

      Naveed,
      As you might have seen we have moved to new site so article is moved to http://onlineappsdba.com/index.php/2007/01/23/change-oracle-apps-password-fndcpass so check this link for your answer and comment in new site in future

       
    • At 1:49 PM, Blogger Hitendra Santosh said…

      Hi Atul I have a question for you

      Is it required to modify all the files that you have prescribed.
      I think it is enough if we run Autoconfig.

       
    • At 2:03 PM, Blogger Atul Kumar said…

      Hitendra,
      Yes Autoconfig should change all files mentioned

       
    • At 11:39 AM, Blogger ramu said…

      Hi Atul,

      Regarding this password change i have one problem ..i changed password of apps to xxapps
      based on Metalink Note 303621.1.But every thing i did properly but my concurent managers are not running in sysadmin all running at actual mode is 0....Can you suggest how to resolve this issue..


      thanks
      Ramu.

       
    • At 9:39 AM, Blogger pavan said…

      Hi,
      I change Apps password using FNDCPASS,
      Now OAM is not working & giving error
      "- YOU ARE NOT AUTHORIZED TO VIEW THIS PAGE "(403 forbidden)
      can anybody provide solution??

      PAvankumar

       
    • At 7:02 AM, Blogger SHEKHAR said…

      Hai
      may be u din't change p/d in
      wdbsvr.app & cgicmd.dat
      bounce the apps tier

      SHEKHAR

       
    • At 6:43 AM, Anonymous Francisco Riccio said…

      Hi, a question, if i change a password of a schema of APPS for example GL with FNDCPASS i must before change the password of APPLSYS or apply a FNDCPASS to APPLSYS before of change the password to password of Application such as GL?

       
    • At 6:38 PM, Blogger Vishnu said…

      Hi Atul,

      Thankyou very much for the post..
      I searched a lot sites regarding running the scripts after changin apps passwd.

      You gave an excellent answer..

      Thanks a lot !!!

       
    • At 11:51 AM, Anonymous Anonymous said…

      do we need to shutdown middle tier services to change the password of a product in oracle apps using fndcpass? if so why?

       
    Post a Comment
    << Home
     
    About Me


    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Archives
    Add On
     

    Add to Technorati Favorites

     

     

    Add to Google

     

    Add to My AOL

     

    Subscribe in Bloglines

     

    Subscribe in NewsGator Online

     
    Powered by



    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar