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

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> wrote:
> 
> From: sybin s <sybins@xxxxxxxxx>
> Subject: Re: Ad Administration , Ad Patch don't work & Application don't open
> To: ora-apps-dba@xxxxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx, 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://blog.michael-brown.org




Other related posts: