Saturday, March 3, 2012

HOW TO RESET SYSADMIN PASSWORD

How to Reset only the SYSADMIN Password

PROBLEM DESCRIPTION 
------------------- 
You have forgotten the SYSADMIN applications password and cannot login. You know the apps and applsys passwords but does not want to follow the steps to 
reset all passwords since resetting applsys would require re-registering all applications user passwords. 

How can you reset only the SYSADMIN password? 

SOLUTION DESCRIPTION 
-------------------- 
The applsys password provides the basis for all user passwords so resetting applsys will require re-registering all user passwords. 
If there are any other users with System Administrator privileges, then they can reset the SYSADMIN user's password from within applications. 
Otherwise SYSADMIN can be reset without affecting other users as follows: 
1. Log in to SQL*Plus as applsys 
2. Backup FND_USER and FND_ORACLE_USERID tables using 
create table FND_USER_BAK as select * from FND_USER; 
create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID; 
3. update FND_USER 
set ENCRYPTED_FOUNDATION_PASSWORD ='2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411', 
ENCRYPTED_USER_PASSWORD='D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13' 
where user_name='SYSADMIN'; 
sql>commit; 

The SYSADMIN password is now set to WELCOME.

FRM-41045:CANNOT FIND ITEM. INVALID ID WHEN ALTERING EFFECTIVE DATE


https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=970799.1

Cause

APPSTAND.fmb latest version 12.0.6.12010000.2 (which supports non-Gregorian calendar) exists in 12.1.1. 
But Alter Effective Date form (DTXCGDAT) got complied with the old version 120.6 and that is causing the issue.

The following bug was logged for the customer

Bug 9080326 - !FRM-41045:CANNOT FIND ITEM. INVALID ID WHEN ALTERING EFFECTIVE DATE

Solution

 Please follow below steps and verify the issue:
 1) Connect to the instance using telnet or putty where the issue is  reproducible.
 .
 2) Take a backup of $DT_TOP/forms/US/DTXCGDAT.fmx and $DT_TOP/forms/AR/DTXCGDAT.fmx
 .
 3) Compile DTXCGDAT.fmb using the latest version of APPSTAND.fmb 
 (12.0.6.12010000.2) and copy this new DTXCGDAT.fmx to  $DT_TOP/forms/US/
 . 
 cd $AU_TOP/forms/AR
   frmcmp_batch.sh userid=apps/apps module=DTXCGDAT.fmb output_file=$DT_TOP/forms/AR/DTXCGDAT.fmx module_type=form batch=no compile_all=yes
cd $AU_TOP/forms/US/
   frmcmp_batch.sh userid=apps/apps module=DTXCGDAT.fmb output_file=$DT_TOP/forms/US/DTXCGDAT.fmx module_type=form batch=no compile_all=yes


 4) Bounce the apache and verify the issue.



Issue : 
when running : 

 frmcmp_batch.sh userid=apps/apps module=$AU_TOP/forms/AR/DTXCGDAT.fmb output_file=$DT_TOP/forms/AR/DTXCGDAT.fmx module_type=form batch=no compile_all=yes

if u get :

ORA-12154 TNS could not resolve the connect identifier specified - while compiling manually forms

sol : 
http://viniciuspapadba.blogspot.com/2012/10/ora-12154-tns-could-not-resolve-connect.html


if u get : 

FRM-18108: Failed to load the following objects.  Source Module:APPSTAND.fmb   Source Object: WHEN-NEW-ITEM-INSTANCE

sol : 

cd $AU_TOP/forms/AR/
and run : 

frmcmp_batch.sh userid=apps/apps module=$AU_TOP/forms/US/DTXCGDAT.fmb output_file=$DT_TOP/forms/US/DTXCGDAT.fmx module_type=form batch=no compile_all=yes