Change Password Using FNDCPASS Utility.

-
Usage of FNDCPASS Utility
FNDCPASS <APPS username>/<APPS password> 0 Y <SYSTEM username>/<SYSTEM password> <token> <username> <new password>

Following are the FNDCPASS Utility options that could be used with different <token>.
  1. Change the APPS and APPLSYS schema password
The SYSTEM token is used when changing the APPLSYS password.

FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new password>

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
  1. Change an Oracle Applications schema password (other than APPS/APPLSYS)
The ORACLE token is used when changing a SINGLE Applications schema password.

FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new password>

FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
  1. Change all ORACLE schema passwords
The ALLORACLE token is used when changing ALL Applications schema passwords.

FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new password>

FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
  1. Change an Oracle Applications user’s password
The USER token is used when changing an Applications USER password.

FNDCPASS <logon> 0 Y <system/password> USER <username> <new password>

FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
Important: Oracle Applications system should be shut down before changing any schema passwords. Also FND_USER and FND_ORACLE_USERID tables should be backed up before changing any passwords.

Comments

Post a Comment

Popular posts from this blog

ORA-06512: at SYS.DBMS_METADATA_UTIL Error

-
 If you face an error like the following while performing “impdp” operations: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3343 ORA-06512: at "SYS.KUPM$MCP", line 2636 ORA-39097: Data Pump job encountered unexpected error -1001 Solution: execute the following command: SQL> exec dbms_metadata_util.load_stylesheets; If the above query executes sucessfully then try the “impdp” command again. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> exec dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed. SQL>
Read more

RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase

-
Error Occurred :– Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() –> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest.tipl.com)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=TIR12.ticfg.com))) Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection Connection could not be obtained; returning null RC-00118: Error occurred during creation of database StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:661) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.re...
Read more

The install cannot proceed as service OracleServiceXE is present on the system

-
If you are not able to remove oracle from the above workaround. Please follow below steps to remove OracleServiceXE. Solution:– Try to delete the service using the command prompt: Click Start, type ‘cmd’ in the search field, and when ‘cmd’ shows up in the list of options, right click it and select ‘Run as Administrator’. At the Command Prompt window, type “sc delete OracleServiceXE” without the quotes and press Enter. Type “Exit” and press Enter. Hope it helps. C:\> sc stop OracleServiceXE                      (to Stop service) C:\> sc delete OracleServiceXE                      (to remove)
Read more