Re: Does this happen to you at work?

On 5/10/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote:
> and most of database name under my care is either orcl or prod
>=20

Oh, joy. =20

Yeah, I've got that problem where I work.  Databases (indeed servers
as well) tended to be set up by people in the local departments they
tended to just give them what ever name made sense to them not
thinking that maybe someone from outside that department might have to
support them some day.

We've got a lot of databases with names like prod, test, uat &c along
with a fair few named marvin, ford, zaphod, thomas, fatcon, rover,
pugwash, blackpig &c.  We do have a standard for naming servers but
that's not helpful as it was designed by someone who only dealt with
file and print servers scattered accross a geographically diverse
organisation so the name relates to where the server is, not what it
does.  The upshot of this (coupled with the frequent office moves) is
that from a server name you cannot tell what it does, which
application it supports or where it is now but you do know where it
was when it was initially built.

I'm currently in the process of putting together a standards document
for Oracle databases and am including a passage stating that databases
shall have meaningful names relating to their purpose.

Stephen


--=20
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: