Saturday, January 19, 2013

[OBIEE11g] - Deleting and Re-Creating Users in Weblogic LDAP Server


  1. Open the file C:\OracleFMW\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\NQSConfig.INI
    and edit as below:
    FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
    then open the file: C:\OracleFMW\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml
    and update with the “UpdateAccountGUIDs” line as below:
    <Catalog>
    <UpgradeAndExit>false</UpgradeAndExit>
    <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
    </Catalog>
  2. Shutdown and Startup your OBIEE and Weblogic Services with
    C:\OracleFMW\instances\instance1\bifoundation\OracleBIApplication\coreapplication\StartStopServices.cmd
    stop_all
    C:\OracleFMW\instances\instance1\bifoundation\OracleBIApplication\coreapplication\StartStopServices.cmd
    start_all
    OR for unix you can use:
    ./opmnctl stopall
    ./opmnctl startall
  3. Revert back the changes in NQSConfig.INI and instanceconfig.xml files as it was before i.e:
    FMW_UPDATE_ROLE_AND_USER_REF_GUIDS
    = NO;
    and
    <Catalog>
    <UpgradeAndExit>false</UpgradeAndExit>
    </Catalog>
  4. Shutdown and Startup your OBIEE and Weblogic Services as mentioned in step 2.