ArcSDE Administrator

[AymanSalah2]

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.

[VinceAngelo]

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

[AymanSalah2]

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.

[LeoDonahue]

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?

[VinceAngelo]

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