Fail to initialize server_lock error

I have seen some cases where users face following error while starting Unifier application.

Connecting to Unifier database…
Server Version: 16.1.0.0 b-02282016-09
Fail to initialize server_lock.
Fail to initialize server_lock.
Exception in thread “Unifier Startup” java.lang.RuntimeException: java.lang.Exception: Fail to initialize server_lock.

Unifier_error

This error comes because of insufficient privileges granted to Unifier Database user. In order to resolve this, perform following steps:

  • Connect to your Unifier database with SYS user
  • Run following scripts and replace unifier with your Unifier database username

grant connect, resource, create table, create view to unifier ;
commit;
grant unlimited tablespace to unifier;
commit;

  • Restart your weblogic where Unifier is deployed.
Advertisements

Maximum open cursors exceeded while installing Project Control UPK

If you are getting below error while installing Project Control zip file then follow steps as mentioned in this blog post.

ORA-01000: maximum open cursors exceeded

To resolve the issue first connect to database with sys user as SYSDBA role.
Read More »