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.

 

Now run the following query

SELECT MAX(A.VALUE) AS HIGHEST_OPEN_CUR, P.VALUE AS MAX_OPEN_CUR FROM V$SES

STAT A, V$STATNAME B, V$PARAMETER P WHERE A.STATISTIC# = B.STATISTIC# AND B.NAME

 = ‘OPENED CURSORS CURRENT’ AND P.NAME= ‘OPEN_CURSORS’ GROUP BY P.VALUE;

Output of this query will show the current Cursor limit, if it is less increase it by running following query

ALTER SYSTEM SET OPEN_CURSORS=1337 SID=’*’ SCOPE=BOTH;

Commit the changes.

Stop Weblogic by running stopWeblogic.cmd file present at

<weblogic installation directory>\user_projects\domains\<domain name>\bin

Drop unifier database user by running below query

DROP USER unifier CASCADE;

Commit the changes.

Create user again and grant necessary privileges.

Start Weblogic server by running startWeblogic.cmd file and continue installation of Unifier.