Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Error Connecting to a GEODATABASE (ArcMap 10, ESRI) after Patch Set 19651773 Applied

edited Oct 29, 2014 10:26AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered ✓

I have Oracle installed on a Windows 2003R2 Server. I upgraded to 11.2.0.4 and applied the 19651773 (Oct 2014) patch set. Once I did, users started getting the following error:

Users able to connect without issue before the patch. I had a user try on another database that was at 11.2.0.4, patch 18842982 (July 2014) and he was able to without issue.

I found another user (login) that worked so I compared ROLES. The "good" one had SELECT_CATALOG_ROLE. I GRANTED this ROLE to the first user and he was able to connect.

Has anyone else run into this issue? My instinct tells me that this is Oracle tightening up security but in doing so, this higher ROLE is needed for the GIS developers to do their job. Now I feel like the user has access to more (security) information. Am I understanding this correctly?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center