How to reset Oracle Password and disable password expiration

• Find out the profile the user (I'm doing this for SYS user) is associated with.

SQL> select profile from dba_users where username = 'SYS';

PROFILE

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

DEFAULT

• Alter the profile to have unlimited password tries and expiration

SQL> ALTER PROFILE DEFAULT LIMIT

  2  FAILED_LOGIN_ATTEMPTS UNLIMITED

  3  PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

• Reset the password for the user.

SQL> ALTER USER SYS IDENTIFIED BY "MyPass";

User altered.

SQL> commit;

Commit complete.

SQL>

Adding a photo to Active Directory (on any LDAP) User.

For my tests I wanted to add a jpeg photo to Active Directory users. Google search yields some results/tools which I didn't find particularly helpful. Hence I tried to see a better and more easy way of doing things.
Using Apache Directory Studio you can Add/Edit/Delete LDAP entries quite easily.

Here's what you do:

• Install Apache Directory Studio (Note: This requires JDK installed on the machine)
• Launch the Editor and add a connection to your LDAP Server.

• You should be able to view entries now:

• Now add a "New Attribute" called jpegPhoto and point it to your sample jpegPhoto.

And you're done.

Adding an administrative user (cn=root like) in Tivoli Directory Server.

This is picked from the paper: http://www.ibm.com/developerworks/tivoli/library/t-dartds/


For my records:

• Use idsldapadd to add the following user:

C:\Program Files\IBM\LDAP\V6.3\bin>idsldapadd.cmd -p 1389 -D "cn=root" -w "mysecret123"

dn: cn=sdi-admin, cn=AdminGroup, cn=Configuration

cn: sdi-admin

ibm-slapdAdminDN: cn=sdi-admin

ibm-slapdAdminPW: mypass

ibm-slapdAdminRole: AuditAdmin

ibm-slapdAdminRole: DirDataAdmin

ibm-slapdAdminRole: SchemaAdmin

ibm-slapdAdminRole: ServerStartStopAdmin

objectclass: top

objectclass: ibm-slapdConfigEntry

objectclass: ibm-slapdAdminGroupMember

Operation 0 adding new entry cn=sdi-admin, cn=AdminGroup, cn=Configuration

• Restart Tivoli Directory Server.