topic Re: ArcSDE Administrator in Data Management Questions

ArcSDE Administrator

AymanSalah2 — Wed, 23 Jan 2013 03:24:59 GMT

What is the best practices for ArcSDE Administrator and DB Administrator, to have one Administrator for both ArcSDE and DB or to have two Administrators, one for ArcSDE and one for DBA on the same production server.

Re: ArcSDE Administrator

VinceAngelo — Wed, 23 Jan 2013 10:29:28 GMT

I really don't think that "best practice" applies here, other than that someone who is
able to do each role is available. Every organization has their own constellation of job
responsibilities. If there are multiple individuals who hold System Admin, Database
Admin, and Geodatabase Admin duties, then it's best if they are at least somewhat
cross-trained and can work well together.

- V

Re: ArcSDE Administrator

AymanSalah2 — Wed, 23 Jan 2013 13:42:47 GMT

As SDE is fully depend on Oracle, it might be some confusing operations for the DB. such as a new table create which DB don't know about. or some indexing issues or any reason that the DB dosn't know about. What I am really looking for if any body work in environment where they had 2 Administrator and if they faced slimier or other problem like this.

Re: ArcSDE Administrator

LeoDonahue — Wed, 23 Jan 2013 14:02:59 GMT

As SDE is fully depend on Oracle, it might be some confusing operations for the DB. such as a new table create which DB don't know about. or some indexing issues or any reason that the DB dosn't know about. What I am really looking for if any body work in environment where they had 2 Administrator and if they faced slimier or other problem like this.

But those permissions would have to be assigned to the featureclass data owner, so the DBA would know about it. Right?

Re: ArcSDE Administrator

VinceAngelo — Wed, 23 Jan 2013 14:22:21 GMT

I worked in an environment with a dozen of DBAs, two dozen SAs (Unix and Windows
as separate specialties), and a dozen disk storage specialists, with four ArcSDE admins.

As a DBA/SA/network engineer/software developer/geodatabase admin, I've seen dozens
of role administration configurations at client sites. They all had merit for the site, and I
found a way to get necessary work done -- It just requires coordination and cross-training
(formal or otherwise).

- V