ArcCatalog: Maximum Connection Error to one Oracle Instance

1674
1
Jump to solution
10-27-2014 08:08 AM
Highlighted
Occasional Contributor II

Hi,

We have an Oracle server hosting GIS data. All of our schemas are inside one instance in the database. One schema is called 'DEV'. In ArcCatalog we can't change its 'owner' to 'DEV' user (using the 'geodatabase connection properties' window): We get a 'Maximum Number of Connections to Instance' like error. The owner, by default, is always 'SDE' but that is wrong owner and so shows wrong features/tables. And we can change the owner to some other users but they would show wrong features.

What is interesting is that in the 'Oracle SQL Manager' client we could use the credentials for the DEV user and correctly see the Features/Tables. Our database person confirms that connections to the instance are indeed not maxed out.

So the issue is in ArcCatalog only. And the issue persists on ArcCatalog running on two different workstations.

 

Any idea?

Thanks.

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Occasional Contributor II

Never mind. It turned out that there two ArcGIS Servers in our environment Publishing some Services whose database schemas were the same Oracle schema. Turning those Services off on one of the servers got rid of the maximum connection problem.

View solution in original post

Reply
0 Kudos
1 Reply
Highlighted
Occasional Contributor II

Never mind. It turned out that there two ArcGIS Servers in our environment Publishing some Services whose database schemas were the same Oracle schema. Turning those Services off on one of the servers got rid of the maximum connection problem.

View solution in original post

Reply
0 Kudos