Changes between Version 1 and Version 2 of UPDT_unit_changes


Ignore:
Timestamp:
11/17/14 16:48:46 (10 years ago)
Author:
lttoth@…
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UPDT_unit_changes

    v1 v2  
    66EDIR_STRUCTURE table, adding/deleting/modifying unit records.  An EDIR stored procedure  
    77is subsequently executed to update EDIR unit records with EDIR_STRUCTURE table changes.   
     8 
    89Following the EDIR update, departments depending on EDIR unit information are informed of  
    910the changes and requested to provide feedback. 
    1011 
    11 # on receipt of email stating BOR table updates are complete, 
    12 # update the registry and generate and apply directory LDIF 
     12== Update Process for EDIR ==  
     13Upon receipt of the email stating BOR table updates are complete, update the registry and generate and apply directory LDIF 
    1314 
    14 # either via Appworx: 
     15=== Via !AppWorx === 
    1516 
    16         EDIR_UNIT_UPDATES 
     17        Request !AppWorx Process Flow, EDIR_UNIT_UPDATES 
    1718 
    18 # or manually: 
    19  
    20         # execute stored procedure to update registry 
    21         # ssh to sxldap account on summit 
    22         cd $HOME/local/ldap/registry 
    23         sqlplus / 
    24                 @execute_xprocess 
    25                         -- when prompted, enter the following: 
     19=== Manual Processing === 
     20The EDIR unit update process can be executed manually by running scripts as the RPTP cluster account, ''sxldap''. 
     21==== Update the People Registry Tables ==== 
     22        1. ssh to sxldap account on summit 
     23        1. cd $HOME/local/ldap/registry 
     24        1. At command line prompt, enter "sqlplus /" 
     25                * @execute_xprocess 
     26                        * -- when prompted, enter the following: 
    2627                        ldap_dept_maint(false,return_status) 
    27  
    28                 -- the resulting output will be written to /tmp 
    29                 exit 
     28                        * -- the resulting output will be written to /tmp exi 
     29==== Apply Resulting LDIF ==== 
     30Once the people registry updates are complete, take the following steps to apply the resulting LDIF to the LDAP repository. 
    3031         
    31         # on completion of the registry update, 
    32         # copy and apply resulting LDIF 
    33          
    34                 # ask DBA group to execute the following to  
    35                 # add world read permission to ldif files in /tmp 
    36                 ~oracle/local/production/PMldap_tmp_chmod.ksh 
    37          
    38                 # after the file permissions have been changed, 
    39                 # copy the resulting ldif to sxldap owned  
    40                 # directory and to iplanet account on eklutna 
    41                 cd $HOME/appworx/ 
    42                 ./manage_ldif_files.ksh 
    43          
    44                 # after copying the resulting ldif, 
    45                 # tell iplanet on eklutna to apply it 
    46                 ./apply_ldif_files.ksh 
    47          
    48                 # have DBA group run this script to  
    49                 # delete ldif from /tmp/ 
    50                 ~oracle/local/production/PMldap_tmp_cleanup.ksh 
     32                1. ask DBA group to execute the following to  
     33                add world read permission to ldif files in /tmp 
     34                  * ~oracle/local/production/PMldap_tmp_chmod.ksh 
     35                1. after the file permissions have been changed, 
     36                copy the resulting ldif to sxldap owned  
     37                directory and to iplanet account on eklutna 
     38                  * cd $HOME/appworx/ 
     39                  * ./manage_ldif_files.ksh 
     40                1. after copying the resulting ldif, 
     41                tell iplanet on eklutna to apply it 
     42                  * ./apply_ldif_files.ksh 
     43                1. have DBA group run this script to  
     44                delete ldif from /tmp/ 
     45                  * ~oracle/local/production/PMldap_tmp_cleanup.ksh 
    5146 
    5247# after confirming LDIF applied, 
    … …  
    10499LEGACY CHANGE HISTORY - NOTE: All subsequent changes are recorded in TracWiki[[br]] 
    105100########################################################[[br]] 
    106 20070906 sxelm corrected ldap_dept_maint reference (erroneously ldap_dept_update) 
    107 20070608 sxelm replaced edir-admin-l references with sdedirregistry 
     10120070906 sxelm corrected ldap_dept_maint reference (erroneously ldap_dept_update)[[br]] 
     10220070608 sxelm replaced edir-admin-l references with sdedirregistry[[br]] 
    10810320070607 sxelm added reference to Appworx job that circumvents need for DBA support