Re: Naming that baby!
Date: Fri, 28 May 1993 23:47:21 GMT
Message-ID: <1993May28.234721.25593_at_newsgate.sps.mot.com>
Gary B. Eckhardt replied to:
>In article mkh_at_rag.asc.slb.com, jadams_at_austin.slcs.slb.com (John Adams) writes:
>> 1) What do you use for $ORACLE_SID? How did you come up with that name?
>
> We came up with a common convention that includes 'dev' or 'pro' in the name
> of the SID, meaning 'development' and 'production' accordingly. In addition,
> we have a single letter appended to the beginning meaning the platform that it
> is running on, i.e. 'S'or 'V', meaning 'Sun' and 'Vax' accordingly.
> And finally, we might have many production databases all running on different
> machines, so we append a single number on the end to signify which one.
> Thus, 'SDEV1', 'SPRO1', 'VDEV1' are all valid SID's. Note that these are only
> to identify the database. Each application uses a database alias that points to
> one of these, so that if we transplant an application from one database to another,
> we just have to change the alias.
>
You're heading in the direction of 'intelligent' keys. They are virtually guaranteed come back and bite you one day. For instance in the above proposal what if you had both Sun and Sequent machines? I simply call my instances FRED, BERT etc and keep a look up table of where they live.
>>
... other stuff deleted.
>>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen Usual disclaimers apply Motorola ASIC Division Chandler, AZ-85224 email: ttg242_at_email.sps.mot.com+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Received on Sat May 29 1993 - 01:47:21 CEST