How to Resolve a Registry Lock Issue, When Attempting to Execute the EPMCONFIG.bat File

This issue occurred in one of our testing environments, when attempting to install EPM version 11.2.15. Upon execution of Config.bat, located at:   E:\Oracle\Middleware\user_projects\epmsystem1\bin

I was presented with an “Unable to Obtain lock for registry” prompt, which in turn, gives you the option to either still continue to open Shared Services and still attempting to perform the install, of which, I do NOT recommend, as the install will end up being installed incorrectly with missing tables, corrupt tables or no tables at all or the second choice of aborting shared services and correcting the issue at hand. To correct the issue, I performed the following steps bellow:

1)    Navigated to my server, where my EPM Shared Services Database was located and Expanded the Database tree, followed by locating the dbo.EPM_REGISTRY_LOCK table.

2)    Expended the “Columns” folder and inspected the associated listed LOCK tables.

1)    Executed a New Query and ran the following command: Delete from EPM_REGISTRY_LOCK;

2)    Once executed, I received confirmation of 1 row being impacted

3)    Navigated back to Windows Explorer and re-executed the EPM CONFIG.bat file without any Registry Lock prompt issues.

Previous
Previous

Watch Webinar: Beyond Finance-Unleashing The Full Potential of Oracle Essbase Across Your Organization

Next
Next

EPM 11.2.15 Upgrade-in-Place