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

From: Vikram <vikramsingh120@xxxxxxxxx>
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Sat, 6 Nov 2010 12:05:16 -0700
Good news.
But is the application still not starting? What is the error you see? If the
error is at the self-service page, then do you have Apache logs?

-Vikram

On Fri, Nov 5, 2010 at 6:57 AM, Mostafa Eletriby <m_etrib@xxxxxxxxx> wrote:

> Hello DBAs,
>
> I solved the problem of Adadmin & it is normally running now with no errors
> , also adpatch & other ad utilities, according to the notes that James sent
> me before that I shouldn't run autoconfig after the changes of fndcpass & I
> restored the session of autoconfig & I reached this point.
> But the application still don't open & I am doing some trials although all
> services are started normally.
> My question is when should I run autoconfig again as I restored the session
> to before my initial change of apps password.
> to update the current parameters correctly of context file.
>
> the errors that lastly appeared at FNDCPASS is for oracle applications
> users not Oracle IDs as they are now having one password & no problems with
> them with the log ,except for Guest user , it's password couldn't be
> encrypted, what should I do with this user ???
>
>
> select distinct(status) from apps.FND_PRODUCT_INSTALLATIONS;
>
> STATUS
> I
> N
> S
> ========================
>
> select username, account_status from dba_users where username like 'APP%';
>
> USERNAME       ACCOUNT_STATUS
> APPLSYSPUB   OPEN
> APPLSYS          OPEN
> APPS                OPEN
>
> Installation is fresh for testing.
> Application was running normally before my trials to change apps password
> by fndcpass.
>
> Thanks
>
>
> --- On *Thu, 11/4/10, Vikram <vikramsingh120@xxxxxxxxx>* wrote:
>
>
> From: Vikram <vikramsingh120@xxxxxxxxx>
>
> Subject: Re: Ad Administration , Ad Patch don't work & Application don't
> open
> To: ora-apps-dba@xxxxxxxxxxxxx
> Date: Thursday, November 4, 2010, 3:30 PM
>
>
> 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<http://mc/compose?to=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<http://mc/compose?to=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<http://mc/compose?to=elmaris@xxxxxxxxx>
> >
>
> *To:* 
> ora-apps-dba@xxxxxxxxxxxxx<http://mc/compose?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<http://mc/compose?to=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<http://mc/compose?to=harish.muramshetty@xxxxxxxxx>
> >* wrote:
>
>
> From: Harish Muramshetty 
> <harish.muramshetty@xxxxxxxxx<http://mc/compose?to=harish.muramshetty@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: m_etrib@xxxxxxxxx <http://mc/compose?to=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/
>
>
>
>
>
>
>
>
>
>
>
>
>
References:
- Re: Ad Administration , Ad Patch don't work & Application don't open
  - From: Vikram
- Re: Ad Administration , Ad Patch don't work & Application don't open
  - From: Mostafa Eletriby
Re: Ad Administration , Ad Patch don't work & Application don't open

Other related posts:
