Re: Ad Administration , Ad Patch don't work & Application don't open

  • From: Vikram <vikramsingh120@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Thu, 4 Nov 2010 12:30:22 -0700

Mustafa,

Try checking the below MOS notes:


   1. *Error Migrating Platform adpatch fails with : DCPW null for "APPLSYS"
   [0] [ID 756706.1]*
   2. *aipspv(): Error Setting Up PDI List for Upgrade [ID 330238.1]*

What is the output for the below queries:
SQL> select distinct(status) from apps.FND_PRODUCT_INSTALLATIONS;
SQL> select username, account_status from dba_users where username like
'APP%';

Is this application newly created? or cloned? or migrated to a new platform?
When was the last time the application worked fine?

Too many questions, huh!

-Vikram

On Tue, Nov 2, 2010 at 10:42 AM, James Morrow <morrow.james@xxxxxxxxx>wrote:

> Mustafa --
>
> When you changed the APPS, APPLSYS, and APPLSYSPUB passwords using
> FNDCPASS, did the log file contain these lines?
>
> FNDCPASS was not able to decrypt password for user 'APPS' during applsys
> password change.
> FNDCPASS was not able to decrypt password for user 'APPLSYS' during applsys
> password change.
>
> If so, take a look at:
>
> Changing APPS Password Using Fndcpass Gives 'not able to decrypt password'
> Message (Doc ID 733427.1)
>
> -- James
> ----------------------------------------------------------------------
> James J. Morrow | Senior Oracle Applications DBA
> morrow.james <at> gmail <dot> com
>
>
> On Tue, Nov 2, 2010 at 9:41 AM, Kellyn Pedersen <kjped1313@xxxxxxxxx>wrote:
>
>>  Pssst....Maris... I think he's been told this like 5 times now and just
>> isn't listening... I hope you have better luck than the rest of the folks on
>> here... :)
>>
>>
>> Kellyn Pedersen
>>
>> Sr. Database Administrator
>>
>> http://www.linkedin.com/in/kellynpedersen
>>
>> www.dbakevlar.blogspot.com
>>
>>
>>
>>
>>  ------------------------------
>> *From:* Maris Elsins <elmaris@xxxxxxxxx>
>>
>> *To:* ora-apps-dba@xxxxxxxxxxxxx
>> *Sent:* Tue, November 2, 2010 7:20:31 AM
>>
>> *Subject:* Re: Ad Administration , Ad Patch don't work & Application
>> don't open
>>
>> Hi,
>> I just quickly checked the conversation, sorry if that was mentioned
>> already..
>> What the error message actually says is: your FND oracle user password
>> could not be decrypted using the apps password. (those passwords are stored
>> encrypted with APPS password in table fnd_oracle_userid and decrypted when
>> needed).
>> As you are not actually giving the full sequence of the actions taken
>> There are some options:
>> 1) either you changed apps or applsys password using "alter user" not
>> FNDCPASS
>> 2) or you changed FND user password using "alter user" not FNDCPASS
>>
>> If you could provide the log file of FNDCPASS command where you changed
>> the APPS password it should contan list of users where decryption was not
>> possible.
>> So please provide more info if you expect to get help here.
>>
>> br,
>> Maris Elsins
>> http://appsdbalife.wordpress.com
>>
>> P.S. This is where the error is stated:
>> >Reading database for information about the products.
>> >AD Administration error:
>> >DCPW null for "APPLSYS" [0]
>> >
>> >
>> >AD Administration error:
>> >Failed getting PDI list for product 'fnd'
>> >
>> >AD Administration error:
>> >aipspv(): Error setting up PDI list for upgrade
>>
>>
>>
>> On Tue, Nov 2, 2010 at 2:47 PM, Mostafa Eletriby <m_etrib@xxxxxxxxx>wrote:
>>
>>>   Dear Harish,
>>>
>>> Actually the instance is at R 12.1.3   & these files are NOT present ,
>>> they only exist at 11i.
>>>
>>> Thanks
>>>
>>>
>>> --- On *Tue, 11/2/10, Harish Muramshetty 
>>> <harish.muramshetty@xxxxxxxxx>*wrote:
>>>
>>>
>>> From: Harish Muramshetty <harish.muramshetty@xxxxxxxxx>
>>>
>>> Subject: Re: Ad Administration , Ad Patch don't work & Application don't
>>> open
>>> To: ora-apps-dba@xxxxxxxxxxxxx
>>> Cc: m_etrib@xxxxxxxxx
>>> Date: Tuesday, November 2, 2010, 5:14 AM
>>>
>>>
>>>  Hi Mostafa,
>>>
>>> Check the apps password in the below files..whether its same or not.
>>>
>>> *$IAS_ORACLE_HOME/Apache/modplsql/cfg/*
>>> **
>>> *$ORACLE_HOME/8.0.6/reports60/server/CGIcmd.dat*
>>>
>>>
>>>
>>> Regards,
>>> Harish.
>>>
>>>
>>>
>>> On Tue, Nov 2, 2010 at 12:52 PM, Mostafa Eletriby 
>>> <m_etrib@xxxxxxxxx<http://mc/compose?to=m_etrib@xxxxxxxxx>
>>> > wrote:
>>>
>>>   This is the sequence I followed
>>>
>>> 1) checked accounts
>>> 2) Ran FNDCPASS
>>> 3) Ran autoconfig
>>> 4) Relink ad executables
>>>     by execute following command
>>>      adrelink.sh force=y “ad all”
>>>
>>> 5) Ran adadmin & still don't work
>>>
>>> Also Application don't start.
>>>
>>> Is there any other solution?
>>>
>>> Thanks
>>>
>>> --- On *Mon, 11/1/10, Michael Brown 
>>> <dba@xxxxxxxxxxxxxxxxx<http://mc/compose?to=dba@xxxxxxxxxxxxxxxxx>
>>> >* wrote:
>>>
>>>
>>> From: Michael Brown 
>>> <dba@xxxxxxxxxxxxxxxxx<http://mc/compose?to=dba@xxxxxxxxxxxxxxxxx>>
>>>
>>>
>>> Subject: Re: Ad Administration , Ad Patch don't work & Application don't
>>> open
>>> To: m_etrib@xxxxxxxxx <http://mc/compose?to=m_etrib@xxxxxxxxx>
>>> Cc: sybins@xxxxxxxxx <http://mc/compose?to=sybins@xxxxxxxxx>,
>>> ora-apps-dba@xxxxxxxxxxxxx<http://mc/compose?to=ora-apps-dba@xxxxxxxxxxxxx>,
>>> oracle-l@xxxxxxxxxxxxx <http://mc/compose?to=oracle-l@xxxxxxxxxxxxx>,
>>> oracle-tips@xxxxxxxxxxxxx<http://mc/compose?to=oracle-tips@xxxxxxxxxxxxx>
>>> Date: Monday, November 1, 2010, 3:37 PM
>>>
>>> Was this your sequence:
>>> 1) checked accounts
>>> 2) Ran FNDCPASS
>>> 3) Ran adadmin
>>>
>>> or was this your sequence
>>>
>>> 1) Ran FNDCPASS
>>> 2) Ran autoconfig
>>> 3) checked apps and applsys by running sqlplus /nolog
>>> 3a) connect apps/new_apps_password
>>> 3b) connect applsys/new_apps_password
>>> 4) ran adadmin
>>> 5) attempted to change back by running, FNDCPASS apps/new_apps_password 0
>>> Y system/system_password SYSTEM APPLSYS old_apps_password
>>> 6) ran autoconfig
>>> 7) ran adadmin and it still did not work.
>>>
>>>
>>>
>>>
>>>  On Nov 1, 2010, at 8:09 AM, Mostafa Eletriby wrote:
>>>
>>>    I logged in successfully by these users & accounts are not locked.
>>> Then I used FNDCPASS to change apps password but couldn't be reset &
>>> adadmin still don't work.
>>> Also I don't have a backup from table FND_USERS, I just took backup of
>>> table fnd_oracle_userid  , Do you think that decryption of passwords is
>>> corrupted ??
>>>
>>> Please do you have any solutions ?
>>> Thanks a lot
>>>
>>> --- On *Mon, 11/1/10, sybin s 
>>> <sybins@xxxxxxxxx<http://mc/compose?to=sybins@xxxxxxxxx>
>>> >* wrote:
>>>
>>>
>>> From: sybin s <sybins@xxxxxxxxx <http://mc/compose?to=sybins@xxxxxxxxx>>
>>>
>>>
>>> Subject: Re: Ad Administration , Ad Patch don't work & Application don't
>>> open
>>> To: 
>>> ora-apps-dba@xxxxxxxxxxxxx<http://mc/compose?to=ora-apps-dba@xxxxxxxxxxxxx>
>>>   Cc: oracle-l@xxxxxxxxxxxxx<http://mc/compose?to=oracle-l@xxxxxxxxxxxxx>,
>>> oracle-tips@xxxxxxxxxxxxx<http://mc/compose?to=oracle-tips@xxxxxxxxxxxxx>
>>> Date: Monday, November 1, 2010, 7:09 AM
>>>
>>>    Hi Mostafa,
>>>
>>> Please restore the database or atleast the FND user tables if you have it
>>> from the backup and do the FNDCPASS again and run autoconfig and see...
>>>
>>> -Sybin
>>>
>>>   On Thu, Oct 28, 2010 at 2:24 PM, Mostafa Eletriby 
>>> <m_etrib@xxxxxxxxx>wrote:
>>>
>>>    Hello DBAs ,
>>>
>>> I have a problem at Ad Administration utility, after changing Apps
>>> password by FNDCPASS.
>>> Ad administration & ad patch don't work , also the application doesn't
>>> start.
>>>
>>> Instance: R12.1.3
>>>
>>>
>>> Please help me.
>>>
>>> ==============================================
>>>
>>>
>>> AD Administration is verifying your username/password.
>>> The status of various features in this run of AD Administration is:
>>>
>>>                                            <-Feature version in->
>>> Feature                          Active?   APPLTOP    Data model    Flags
>>> ------------------------------   -------   --------   -----------
>>> -----------
>>> CHECKFILE                        Yes       1          1             Y N N
>>> Y N Y
>>> PREREQ                           Yes       6          6             Y N N
>>> Y N Y
>>> CONCURRENT_SESSIONS              No        2          2             Y Y N
>>> Y Y N
>>> PATCH_TIMING                     Yes       2          2             Y N N
>>> Y N Y
>>> PATCH_HIST_IN_DB                 Yes       6          6             Y N N
>>> Y N Y
>>> SCHEMA_SWAP                      Yes       1          1             Y N N
>>> Y Y Y
>>> JAVA_WORKER                      Yes       1          1             Y N N
>>> Y N Y
>>> CODELEVEL                        Yes       1          1             Y N N
>>> Y N Y
>>>
>>>
>>>
>>> Identifier for the current session is 31773
>>>
>>> Reading product information from file...
>>>
>>> Reading language and territory information from file...
>>>
>>> Reading language information from applUS.txt ...
>>>
>>>  AD Administration warning:
>>>  Product Data File
>>>  /u01/oracle/PROD/apps/apps_st/appl/admin/zfaprod.txt
>>>  does not exist for product "zfa".
>>> This product is registered in the database but the
>>> above file does not exist in APPL_TOP.  The product
>>> will be ignored without error.
>>>
>>>
>>> AD Administration warning:
>>>  Product Data File
>>>  /u01/oracle/PROD/apps/apps_st/appl/admin/zsaprod.txt
>>>  does not exist for product "zsa".
>>> This product is registered in the database but the
>>> above file does not exist in APPL_TOP.  The product
>>> will be ignored without error.
>>>
>>>
>>> AD Administration warning:
>>>  Product Data File
>>>  /u01/oracle/PROD/apps/apps_st/appl/admin/jtsprod.txt
>>>  does not exist for product "jts".
>>> This product is registered in the database but the
>>> above file does not exist in APPL_TOP.  The product
>>> will be ignored without error.
>>>
>>>
>>> Reading database to see what industry is currently installed.
>>>
>>> Reading FND_LANGUAGES to see what is currently installed.
>>> Currently, the following language is installed:
>>>
>>> Code   Language                                Status
>>> ----   --------------------------------------- ---------
>>> US     American English                        Base
>>>
>>> Your base language will be AMERICAN.
>>>
>>> Setting up module information.
>>> Reading database for information about the modules.
>>> Saving module information.
>>> Reading database for information about the products.
>>> AD Administration error:
>>> DCPW null for "APPLSYS" [0]
>>>
>>>
>>> AD Administration error:
>>> Failed getting PDI list for product 'fnd'
>>>
>>> AD Administration error:
>>> aipspv(): Error setting up PDI list for upgrade
>>>
>>> You should check the file
>>> /u01/oracle/PROD/apps/apps_st/appl/admin/PROD/log/adadmin.log
>>>
>>> for errors.
>>>
>>> [oracle@R12 appl]$
>>> =======================================
>>> select ACCOUNT_STATUS from dba_users where username = 'APPS';
>>> ------------------------------
>>> ACCOUNT_STATUS
>>> -------------------------------
>>> OPEN
>>> ========================================
>>>
>>> Please Support me.
>>> Thanks
>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>> Michael Brown
>>> dba@xxxxxxxxxxxxxxxxx <http://mc/compose?to=dba@xxxxxxxxxxxxxxxxx>
>>> http://blog.michael-brown.org/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>

Other related posts:

  1. Home
  2. ora-apps-dba
  3. Archive
  4. 11-2010