Mostafa Eletriby | 1 Nov 13:09 2010
Picon

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

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-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

From: sybin s <sybins-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: Ad Administration , Ad Patch don't work & Application don't open
To: ora-apps-dba-uGLqWuYN4qMgsBAKwltoeQ@public.gmane.org
Cc: oracle-l-uGLqWuYN4qMgsBAKwltoeQ@public.gmane.org, oracle-tips <at> freelists.org
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-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> 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 <at> R12 appl]$
=======================================
select ACCOUNT_STATUS from dba_users where username = 'APPS';
------------------------------
ACCOUNT_STATUS
-------------------------------
OPEN
========================================

Please Support me.
Thanks





Michael Brown | 1 Nov 20:37 2010

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-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

From: sybin s <sybins-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: Ad Administration , Ad Patch don't work & Application don't open
To: ora-apps-dba-uGLqWuYN4qMgsBAKwltoeQ@public.gmane.org
Cc: oracle-l-uGLqWuYN4qMgsBAKwltoeQ@public.gmane.org, oracle-tips-uGLqWuYN4qMgsBAKwltoeQ@public.gmane.org
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-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> 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 <at> R12 appl]$
=======================================
select ACCOUNT_STATUS from dba_users where username = 'APPS';
------------------------------
ACCOUNT_STATUS
-------------------------------
OPEN
========================================

Please Support me.
Thanks








Gmane