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

  • From: John Piwowar <jpiwowar@xxxxxxxxx>
  • To: "m_etrib@xxxxxxxxx" <m_etrib@xxxxxxxxx>
  • Date: Thu, 28 Oct 2010 08:53:19 -0400

A few thoughts:
1) Did you run autoconfig after changing the apps password?  Yes, I hate it 
when people provide that to me as a first solution to every EBS config problem 
I have, but it helps in a surprisingly large percentage of incidents. 
2) Does your new apps password contain any special characters that might have 
been interpolated by the shell? I once spent an entertaining afternoon 
untangling myself from the mistake of using a $ in my apps password. 
3) That "DCPW null" errr looks like a good MOS search term. :)
4) Anything more interesting in the referenced adadmin.log file?
5) I'm not surprised that the database account status is "OPEN." you get an 
entirely different error message when the apps account is locked. 

Regards,

John P.

Sent from a mobile device to deliver a more rapid response.  Please excuse 
brevity and typos.
 

On 2010-10-28, at 7:24 AM, 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 
> 
> 
> 

Other related posts: