Re: Ad Administration , Ad Patch don't work & Application don't open
Date: Mon, 1 Nov 2010 05:09:52 -0700 (PDT)
Message-ID: <133431.61564.qm_at_web37004.mail.mud.yahoo.com>
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_at_gmail.com> wrote:
From: sybin s <sybins_at_gmail.com>
Subject: Re: Ad Administration , Ad Patch don't work & Application don't open
To: ora-apps-dba_at_freelists.org
Cc: oracle-l_at_freelists.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_at_yahoo.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 01 2010 - 07:09:52 CDT