Re: DB Names

From: PhaE <voosterbaan_at_desyde.nl>
Date: Wed, 13 Feb 2002 13:36:07 +0100
Message-ID: <D4ta8.30$Ue6.522@psinet-eu-nl>

You've GOT to be kidding..
What do users know about DB's?
And why should they decide what name the DB should be? Just use a logical naming method.
Like

PRD1, PRD2, PRD3 for production-databases,
DEV1, DEV3, DEV3 for development -databases,
TST1, TST2, TST3 for test-databases.

That is, if you REALLY want 4-letter SID's.. I personally prefer longer SIDS to distinguish the databases better and so I can see which one it is without checking the tnsnames.ora. Usually we use a combination of the application name and a followup-number, like

SOM_PRD1,
SOM_DEV1,
SOM_TST1,

etc..

And as posted further on, you can always change the connect_string so the users can use
PRODUCTION_DATABASE_WITH_LOTS_OF_STUFF_NUMBER_ONE to connect to SOM_PRD1
e.g.:

PRODUCTION_DATABASE_WITH_LOTS_OF_STUFF_NUMBER_ONE =   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <server_name or ip-adress>)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = SOM_PRD1)
    )
  )

Greetings,

Victor.

"konopam" <konopam_at_yahoo.com> wrote in message news:eHaa8.3$ei.116_at_client...
> Hello,
>
> I was wondering if anyone could give me some ideas on different sid
names --
> to this point we are using 8i but our users only want 4 letter names. I
have
> used test, play
> and live -- does anyone have any other decent 4 letter sid names that I
> could use?
>
> Appreciate any help
>
>
Received on Wed Feb 13 2002 - 06:36:07 CST