Steps to reset ODS account Password

1.1   Stop the OID services on both oid hosts ( for clustered env)

1.2    Connect to OID database as sys user and reset the ODS user account password to new value .

 $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 25 10:21:25 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user ODS identified by welcome1;

1.3  Login to OID node 1

1.4   Rename the existing wallet files of this OID node 1.

It will be under ORACLE_INSTANCE\admin folder

D:\u01\app\oracle\admin\oid_inst1\OID\admin\oidpwdXXXXXX

D:\u01\app\oracle\admin\oid_inst1\OID\admin\oidpwdrSID

 

1.5   Set the necessary environment variable ex : ORACLE_HOME, ORACLE_INSTANCE, TNS_ADMIN & PATH variable.

1.6   Run the OIDPASSWD utility for creation of new wallet files for OID DB ODS schema.

Syntax : oidpasswd  connect=oiddb create_wallet=true

enter the new password configured for the ODS account in database. 

[oracle@oracle]$ oidpasswd connect=oiddb create_wallet=true
 password:
confirm password:
password set

1.7   Please make sure that new wallet files has been created.

Eg: 

D:\u01\app\oracle\admin\oid_inst1\OID\admin\oidpwdXXXXXX

D:\u01\app\oracle\admin\oid_inst1\OID\admin\oidpwdrSID

  

1.8  Rename the existing wallet files on node 2 and then copy wallet files from node 1 to node 2.

1.9  Start OID services on Node1  and Node2 .