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

  • From: Harish Muramshetty <harish.muramshetty@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Tue, 2 Nov 2010 13:14:09 +0400

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> 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>* wrote:
>
>
> From: Michael Brown <dba@xxxxxxxxxxxxxxxxx>
>
> Subject: Re: Ad Administration , Ad Patch don't work & Application don't
> open
> To: m_etrib@xxxxxxxxx
> Cc: sybins@xxxxxxxxx, ora-apps-dba@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx,
> 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: