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.

 

p11_1

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.

p11_2

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s