title: forcing the orcladmin password link: https://onemoretech.wordpress.com/2007/08/04/forcing-the-orcladmin-password/ author: lembobro description: post_id: 666 created: 2007/08/04 15:01:00 created_gmt: 2007/08/04 15:01:00 comment_status: open post_name: forcing-the-orcladmin-password status: publish post_type: post

forcing the orcladmin password

Someone asked, so here it is.

Something for all my fellow Oracle Internet Directory admins.

This is fully documented on MetaLink, but in various places.

Here’s the situation:

You’ve either forgotten the cn=orcladmin password, or someone has impolitely changed it without letting anyone know the new one. To add insult to injury, in the latter case the dumb schmuck has also altered the ODS (Oracle Directory Schema) user password on the infrastructure database so that OID won’t even start.

The solution:

Go to $ORACLE_HOME/ldap/admin and rename the oidpwdlldap1 and oidpwdr[$ORACLE_SID] files.

Use sqlplus to log into the infrastructure database back-ending OID as SYSTEM.

Reset the password for ODS (the “Oracle Directory Schema” user).

SQL> alter user ODS identified by [new password]

Then execute

oidpasswd connect=[$ORACLE_SID] create_wallet=true

(oidpasswd is located under $ORACLE_HOME/ldap/bin, not $ORACLE_HOME/bin)

to set the orcladmin superuser password to the same one you just forced for ODS. The tool will prompt you for that password and will do the needful across the system.

Sometimes things have progressed to the point where the ODS user account has been locked on the metadata repository database. If that happens, you need to sqlplus in and unlock it with

SQL> alter user ODS account unlock;

and you should be able to then follow the procedure above.

Copyright 2004-2019 Phil Lembo