Re: Ad Administration , Ad Patch don't work & Application don't open
- From: Michael Brown <dba@xxxxxxxxxxxxxxxxx>
- To: m_etrib@xxxxxxxxx
- Date: Mon, 1 Nov 2010 15:37:45 -0400
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:
