Dev's Weblog

Reading time: < 1 minute

SQL> select scn_to_timestamp(max(ora_rowscn)) from WRH$_FILESTATXS;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))

---------------------------------------------------------------------------

24-JUN-10 11.00.10.000000000 AM

Reading time: 2 - 2 minutes

a ias_admin is user required to use Enterprise Manager Web (Application Server Console - iASConsole) Site.

a ias_admin password is set during Installation of Oracle Application Server (902, 904, 10.1.2.X) or Oracle Identity Management (Infra Tier 10.1.4.X)aias_admin account is NOT stored in OID (Oracle Internet Directory), It is stored in XML file (JAZN-XML - Java AuthoriZatioN)

How to Reset / Change ias_admin Password

You can reset/change ias_admin password in following ways

1. Using Enterprise Manager (Application Server Control) Web Site

-Login to Instance Home Page
-Click on Preferences on top right
-In new screen, click on "Change Password" on left menu
-Enter current password and New Password

2. Using Command line tool

emctl set password oldpassword new password

like

emctl set password password1 password2

If you don't know current ias_admin password then change it in configuration file

3. Change ias_admin password directly in configuration file
-Backup $ORACLE_HOME/sysman/j2ee/config/jazn-data.xml
-Search for xml entry like below

< user >
< name > ias_admin < / >
< credentials >{903}8QkQ/crno3lX0f3+67djasdasdvdawe < / credentials >
< /user >

and Update new password (password2 like )

< user >< name > ias_admin < / >
< credentials > !password2 / credentials >
< /user >

Note ! (Exclamation Mark in front of password. This signifies that password is stored in clear text)