{"id":2152,"date":"2010-12-14T08:56:32","date_gmt":"2010-12-14T12:56:32","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/12\/14\/how-to-add-custom-attributes-object-classes-in-oid-from-command-line-or-gui\/"},"modified":"2010-12-14T09:03:56","modified_gmt":"2010-12-14T13:03:56","slug":"how-to-add-custom-attributes-object-classes-in-oid-from-command-line-or-gui","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/12\/14\/how-to-add-custom-attributes-object-classes-in-oid-from-command-line-or-gui\/","title":{"rendered":"How to add custom attribute, Object Classe in OID from command line or GUI"},"content":{"rendered":"

I discussed about Attribute<\/strong> and Object Class <\/strong>in Oracle Internet Directory (OID)\u00a0in my previous post here<\/a>\u00a0 . OID comes with default attributes and objects classes and provides mechanism (Graphical User Interface – GUI\u00a0and Command Line Interface – CLI) to add attributes and objects classes (Process of adding attributes and object classes is also known as OID Schema Extension<\/font>)<\/p>\n

In this post I am going to show how to add attributes and object class<\/strong> both from CLI and GUI.<\/p>\n

First some theory<\/u><\/strong> :<\/p>\n

1.<\/strong> ODSM more here<\/a>,\u00a0 is a Graphical Tool to create\/view\/manage Attributes\/Object Classes (Select tab Schema<\/strong> & then select Attributes<\/strong> or Object Classes<\/strong>)<\/p>\n

2.<\/strong> OID schema is stored under cn=subschemasubentry <\/strong>at Root DSE (Directory Server Entry)\u00a0<\/strong><\/p>\n

3.<\/strong> To read schema definition (list of defined attributes, object classes) run
\n\u00a0ldapsearch -h [host] -p [port] -b “cn=subschemasubentry” -s base “objectclass=*”<\/strong>\u00a0 (where host is OID server and Port is OID port)<\/p>\n

4. <\/strong>Use ldapmodify (LDAP command) to define new attribute\/object class<\/p>\n

.<\/p>\n

.<\/p>\n

How to add attribute from GUI ?<\/u><\/strong><\/p>\n

1. <\/strong>Login to ODSM http:\/\/server:port\/odsm<\/strong>(where server is hostname of machine where ODSM\/WebLogic wls_ods1<\/strong> managed server is running and port is wls_ods1<\/strong> managed server port\u00a0i.e. 7005<\/strong>)<\/p>\n

2.<\/strong> Select tab Schema<\/strong><\/p>\n

3.<\/strong> Click on Attributes<\/strong> or Object Classes<\/strong><\/p>\n

4.<\/strong> Click on Add<\/strong> button<\/p>\n

<\/a><\/p>\n

.<\/p>\n

.<\/p>\n

How to add attribute from CLI ?<\/strong><\/u><\/p>\n

1.<\/strong>Create a ldif file with list of all attributes and object classes like<\/p>\n

_________________________<\/p>\n

dn: cn=subschemasubentry
\nchangetype: modify
\nadd: attributetypes
\n<\/strong>attributetypes: ( 99.99.99.99.01 NAME ‘attribute1’ DESC ‘Custom Attribute 1’ EQUALITY caseIgnoreMatch SYNTAX ‘1.3.3.4.1.1466.115.121.1.15’ )<\/p>\n

dn: cn=subschemasubentry
\nchangetype: modify
\nadd: attributetypes<\/strong>
\nattributetypes: ( 99.99.99.99.02 NAME ‘attribute2’ DESC ‘Custom Attribute 2’ EQUALITY caseIgnoreMatch SYNTAX ‘1.3.3.4.1.1466.115.121.1.15’ )<\/p>\n

dn: cn=subschemasubentry
\nchangetype: modify
\nadd: objectClasses<\/strong>
\nobjectClassess: ( 99.99.99.99.03 NAME ‘class1’ DESC ‘custom object class 1’ SUP top\u00a0STRUCTURAL MUST cn\u00a0MAY ( Attribute1 $ Attribute2 ) )<\/p>\n

dn: cn=subschemasubentry
\nchangetype: modify
\nadd: objectClasses
\n<\/strong>objectClassess: ( 99.99.99.99.04 NAME ‘class2’ DESC ‘custom object class 2’ SUP top AUXILIARY MAY ( Attribute1 $ Attribute2 ) )<\/p>\n

_________________<\/p>\n

Lets understand what is in above\u00a0LDIF\u00a0file<\/p>\n

a)<\/strong> I am creating two attributes and two object classes\u00a0using LDIF file above .<\/p>\n

B)<\/strong>\u00a0\u00a0Each attribute\/object class is separated by blank line (You will hit error if you don’t leave blank line between two attributes\/object classes<\/font>)<\/p>\n

c)<\/strong> Number 99.99.99.99.0X represents Object Identifier<\/a>\u00a0which is unique number<\/p>\n

d)<\/strong>\u00a0attribute1\/2,\u00a0class1\/2 represents name of <\/strong>attribute or object class<\/p>\n

e)<\/strong>\u00a0\u00a0EQUALITY caseIgnoreMatch represents that attribute is case insensitive<\/strong><\/p>\n

f)<\/strong> SYNTAX ‘1.3.3.4.1.1466.115.121.1.15’\u00a0 represents that attribute is of type Directory String<\/strong> . Other option for SYNTAX are Binary, Boolean, Certificate, Audio…<\/p>\n

g)<\/strong> SUP top in object class represents that Super class for particular Object class is top (top\u00a0is object class of OID)<\/p>\n

h)<\/strong> STRUCTURAL (objectclass1), AUXILIARY (objectclass2) represents object class type (In total Object Class are of three type STRUCTURAL, AUXILIARY\u00a0and ABSTRACT<\/font>\u00a0)<\/p>\n

i)<\/strong> MUST represents mandatory\u00a0attributes and MAY represents optional attributes.<\/p>\n

j) <\/strong>Multiple attributes are added by putting then\u00a0between ( ) and $ as seperator<\/p>\n

2.<\/strong>\u00a0Next step after creating\u00a0LDIF file is to load\u00a0this file<\/strong> in OID using<\/p>\n

$ORACLE_HOME\/bin\/ldapadd -h [OID_Host] -p [OID_Port] -D “cn=orcladmin” -w\u00a0[orcladmin_password] -f [name_of_LDIF_file]<\/strong>\u00a0 (Where ORACLE_HOME is set to OID ORACLE_HOME<\/font>)\u00a0<\/p>\n

3.<\/strong> Above step will create attribute and object class in OID , next step is to add indexes to attributes loaded above (Attribute with Indexes are search-able<\/font>)<\/p>\n

$ORACLE_HOME\/ldap\/bin\/catalog connect=oiddb add=TRUE attribute=[name_of_attribute] verbose=TRUE\u00a0\u00a0<\/strong>(Where ORACLE_HOME is set to OID ORACLE_HOME. Make sure ORACLE_INSTANCE is set to OID instance<\/font>)\u00a0<\/p>\n

.<\/p>\n

References<\/u><\/strong><\/p>\n