How to user FNDCPASS to change the passwords of a Oracle Apps Front End Passwords/Database Product Passwords/Apps Passwords?
1. To Change Front End application password for a user?
FNDCPASS apps/appspwd 0 Y system/systempwd USER username passwd
Example: FNDCPASS apps/apps0 Y system/manager USER test test123
2. To Change Database Product Password?
FNDCPASS apps/appspwd 0 Y system/systempwd ORACLE prodschema passwd
Example: FNDCPASS apps/apps 0 Y system/manager ORACLE GL glnew
Note: After Execution of FNDCPASS it will generate two files one is 282990.log and 32123.out files
Open the log file and see whether concurrent program successfully executed or not. If so, Everything ran successfully
Enabling TLS in Oracle Apps R12.2 Here we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...
How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g 1. Create Temporary Tablespace Temp CREATE TEMPORARY TABLESPACE TEMP2 TEMP...
How to drop and recreate UNDO Tablespace in Oracle 9i/10g/11g ? Solution : 1. Determine the size of your undo tablespace SQL> selec...
R12.2. Services Start and Stop Procedure All components - Application (Middle Tier) START $INST_TOP/admin/scripts adstrtal.s...