Tuesday, 20 August 2013

How To Change SYSADMIN Password in Oracle Applications?


The “SYSADMIN” password can be change in the following ways in 11i and R12 Oracle Applications.
1.Application Level(Front end)
2.OS Level(Using FNDCPASS)
1.Application Level:
Log with a user which has the System Administrator responsibility ->
  • Go to Edit Option under the Menu Options->
  • Select Preferences and Change Password ->
http://myappsdba.com/wp-content/uploads/2012/05/sys1-300x161.png
Navigation Path for Changing Password
Change the password by typing the new password in the field Password.
http://myappsdba.com/wp-content/uploads/2012/05/sys2-300x121.png
Change Password
2.OS Level(Using FNDCPASS):
  • Login to the Apps User
  • Run the Apps environment file
  • Run FNDCPASS to change the SYSADMIN password
FNDCPASS apps/apps 0 Y system/**** USER SYSADMIN <NewPassword>
Sample Output:
mydb1:applprod$FNDCPASS apps/apps 0 Y system/manager USER
SYSADMIN Password2New
Log filename : L4579518.log
Report filename : O4579518.out

Configuration of Enterprise Manager in Oracle Applications R12


As Oracle Database owner

$cd $ORACLE_HOME/dbs

$ls orapw<SID>

If password file doesn’t exist, create one.

$ orapwd file=orapw password= entries=5

Set the parameter remote_login_passwordfile=EXCLUSIVE

After this make sure you are able to connect to database as SYSDBA from Application Tier.

Manually configuring EM (Steps to be performed as Database owner)

$ emca -config dbcontrol db -repos create

STARTED EMCA at Jan 28, 2011 2:26:17 PM
EM Configuration Assistant, Version 11.1.0.7.0 ProductionCopyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:Database SID: <SID>

Listener port number: <Port No.>

Password for SYS user:

Password for DBSNMP user:


Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /u01/xxxxx/db/tech_st/11.1.0

Local hostname ……………. XXXXXX.xxxx.com

Listener port number ……………. <Port No.>

Database SID ……………. XXXX

Email address for notifications ……………

Outgoing Mail (SMTP) server for notifications ……………

Do you wish to continue? [yes(Y)/no(N)]: Y

Jan 28, 2011 2:27:36 PM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/xxxxx/db/tech_st/11.1.0/cfgtoollogs/emca/XXXX/emca_2011_01_28_14_26_17.log.Jan 28, 2011 2:27:38 PM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) …INFO: Uploading configuration data to EM repository (this may take a while) …Jan 28, 2011 3:18:57 PM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyJan 28, 2011 3:19:00 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLibINFO: Software library configured successfully.Jan 28, 2011 3:19:00 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Deploying Provisioning archives …Jan 28, 2011 3:19:20 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibraryINFO: Provisioning archives deployed successfully.Jan 28, 2011 3:19:20 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) …Jan 28, 2011 3:19:41 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Jan 28, 2011 3:19:41 PM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) …Jan 28, 2011 3:20:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyJan 28, 2011 3:20:26 PM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://xxxxxx.xxxx.com:1158/em <<<<<<<<<<<Jan 28, 2011 3:20:34 PM oracle.sysman.emcp.EMDBPostConfig invokeWARNING:************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /mnt1/dbdev/db/tech_st/11.1.0/srvdevl.ccil.com_DEV/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************Enterprise Manager

configuration completed successfullyFINISHED EMCA at Jan 28, 2011 3:20:34 PM
$
Login to EM with URL listed above.