Create wallets for OID database password

This post explains the steps to create wallets for Oracle Internet Directory database password and the oracle database replication sever password using the oidpasswd utility .

For more details on oidpasswd utility check the post :oidpasswd utility

Steps to create wallets for OID database password


eg:Export ORACLE_HOME=D:\u01\app\oracle\admin

Set ORACLE_INSTANCE to asinst_home

eg: Export ORACLE_INSTANCE= D:\u01\app\oracle\admin\oid_inst1

Shutdown OID  on  all the nodes using opmnctl stopall( for clustered env)

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

$ sqlplus / as sysdba

SQL*Plus: Release 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 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Change the database password of ODS schema account to a new value .

SQL> alter user ODS identified by welcome1;

Login to OID node 1

Rename the existing wallet files of this OID node 1. It will be under ORACLE_INSTANCE\admin folder



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 updated in the in database when prompted.

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

This will create the wallets for OID database password .



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

Restart OID services on Node1 and Node2 .


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>