Oracle-L: Re:Database naming conventions

From: <dgoulet_at_vicr.com>
Date: Fri, 14 Feb 2003 10:34:42 -0800
Message-ID: <F001.0054DFF7.20030214103442@fatcity.com>

Melissa,

My naming convention is to have the host name and the database instance follow it. I have been using ORACLE_SID's that are numeric for years since v6 which helps therefore the 02 database on the server brahms.vicr.com is named brahms2. Makes life easier identifying where you are. Having ora preclude it is rather wierd and meaningless.

Dick Goulet

____________________Reply Separator____________________
Author: "Godlewski; Melissa" <Melissa.Godlewski_at_hq.doe.gov>
Date:       2/14/2003 8:23 AM

List,

I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it would be called P24X7. Or along similar lines.

I'm working with an other DBA who wants everything to start with ora. Therefore it would be called orad24x7 and orap24x7. I've argued the ora is rather redundant since everyone will know it's an Oracle database they are connecting to. He is adamant it should have the ora identification so it is easily identified. I feel it will cause more confusion having ora at the beging of every dbname.

Any thoughts for against either position?

TIA
M.Godlewski

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750320016-14022003>List,
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750320016-14022003>I'm
use to using a standard D=development T=test P=production.  So for a database newly created on development it would be called something like D24X7.  Then when it was created on Production it would be called P24X7.  Or along similar lines.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750320016-14022003>I'm
working with an other DBA who wants everything to start with ora.  Therefore it would be called orad24x7 and orap24x7.  I've argued the ora is

rather redundant since everyone will know it's an Oracle database they are connecting to.  He is adamant it should have the ora identification so it is easily identified.  I feel it will cause more confusion having ora at the beging of every dbname.  </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT><FONT color=#0000ff face=Arial size=2><SPAN class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750320016-14022003>Any
thoughts for against either position?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003>TIA</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003>M.Godlewski</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=750320016-14022003></SPAN></FONT> </DIV></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Feb 14 2003 - 12:34:42 CST