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 > > > > > >