Oracle Support

-h : ldap hostname (OID source)

-p : ldap port (3060 default)

-D : OID administrator (cn=orcladmin)

-w : OID admin password

-L : Print entries in LDIF format

-s : This defines scope of search (one for us)

 base: For searching only the base entry.

 one : For searching only the children of the base entry.

 sub : For searching the base entry and all its descendants.

-b : base DN for search (cn=Groups, dc=com,dc=ae)

"(objectclass=*)" : Search based on all object classes that groups are associated to

#!/bin/bash

export MW_HOME=/oracle/app/product/oidfmw

export ORACLE_HOME=/oracle/app/product/oidfmw

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export DOMAIN_HOME=$MW_HOME/user_projects/domains/oid_domain

export JAVA_HOME=/oracle/app/java

echo "Enter orcladmin password"

read -s password

ldapsearch -p 3060 -h  source_oid_server.domain -D "cn=orcladmin" -w $password -L -s one -b "cn=Groups, dc=com,dc=ae" "(objectclass=*)" "*" > bi_oid_source_groups.ldif

echo "BI ALL Group exported successfully : bi_oid_source_groups.ldif"

grep dn bi_oid_source_groups.ldif |grep FILTER | sed 's/dn: //g' > bi_oid_source_FILTER_dn_delete.ldif

echo "BI FILTER Group DN list extracted successfully : bi_oid_source_FILTER_dn_delete.ldif"

sh bi_all_group_export.sh

Enter orcladmin password

BI ALL Group exported successfully : bi_oid_source_groups.ldif

BI FILTER Group DN list extracted successfully : bi_oid_source_FILTER_dn_delete.ldif

sh bi_all_group_export.sh

Enter orcladmin password

BI ALL Group exported successfully : bi_oid_target_groups.ldif

BI FILTER Group DN list extracted successfully : bi_oid_target_FILTER_dn_delete.ldif

export MW_HOME=/oracle/app/product/oidfmw

export ORACLE_HOME=/oracle/app/product/oidfmw

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export DOMAIN_HOME=$MW_HOME/user_projects/domains/oid_domain

export JAVA_HOME=/oracle/app/java

echo "Enter orcladmin password"

read -s password

ldapdelete -p 3060 -h  target_oid_server.domain -D "cn=orcladmin" -w $password -c -v -f bi_oid_target_FILTER_dn_delete.ldif

echo "BI FILTER Groups deleted successfully : bi_oid_target_FILTER_dn_delete.ldif"

usage: ldapadd [options]

    list of operations are read from stdin or

    from the file with -f file option.

options:

    -D binddn   bind DN

    -w passwd   bind password (for simple authentication)

    -h host     LDAP server

    -p port     port on LDAP server

    -W wurl     wallet location for SSL connection(one-way or two-way)

    -P wpasswd  wallet password for SSL connection(one-way or two-way)

    -U SSLAuth  SSL Authentication Mode ("1" no-auth,"2" one-way,"3" two-way)

    -f file     perform sequence of operations listed in `file'

    -X dsmlfile perform sequence of operations from xml file `dslmfile'

    -b          for binary attrs read values from file specified in attrval

    -c          continous operation (do not stop on error)

    -F          force all changes records to be used

    -E charset  encoding character set

    -M          send ManageDsaIT control to server

    -i          bind as current user for chasing Referrals

    -O refhop   set referral hop limit to `refhop'

    -V version  version of LDAP protocol

    -n          print the operations but don't actually do them

    -d level    set LDAP debugging level to `level'

    -o logfile  log messages will be written to `logfile'

    -v          turn in verbose mode (diagnostics to standard output)

    -q          prompt for simple bind password

    -Q          prompt for SSL wallet password

export MW_HOME=/oracle/app/product/oidfmw

export ORACLE_HOME=/oracle/app/product/oidfmw

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export DOMAIN_HOME=$MW_HOME/user_projects/domains/oid_domain

export JAVA_HOME=/oracle/app/java

echo "Enter orcladmin password"

read -s password

ldapadd -p 3060 -h   target_oid_server.domain -D "cn=orcladmin" -w $password -c -v -f bi_oid_source_groups.ldif

echo "BI ALL Group imported successfully"