RE: [SPAM] Re: quick question.. Naming conventions of db sids...

Lawrence,
The problem with the DB-table is that you have to dig into the database to find it. And, even then, changing the role of a database is error-prone. It's easy to forget the DB table. And what about the database that went down, and comes up again, but it's role has been taken over?

I should add that I use a ksh alias per database. My .profile walks the oratab file and creates an alias SID that sets the CDPATH to things like the correct ORACLE_HOME, admin/SID etc, so that I can just key the sid to get the correct settings. Of course ORACLE_HOME itself, and ORACLE_SID are set as well. example (showing the use of CDPATH):

dgs_at_dbalert199:/opt/oracle/admin/dgs/pfile>l10g l10g_at_dbalert199:/opt/oracle/admin/dgs/pfile>cd network /opt/oracle/product/10.0.1.0/network

l10g_at_dbalert199:/opt/oracle/product/10.0.1.0/network>dgs dgs_at_dbalert199:/opt/oracle/product/10.0.1.0/network>cd bin /opt/oracle/product/9.2.0/bin

dgs_at_dbalert199:/opt/oracle/product/9.2.0/bin>

l10g and dgs are the sids involved. With the command l10g I switched to that SID. cd network brings me to the correct ORACLE_HOME/network. dgs switches back to dgs again. The sit is displayed in the prompt. It's not rocket-science, but makes my life a bit easier. No oraenv, export ORACLE_SID or other things needed. Just key in the plain sid, and everything gets set and done. For uppercase SIDs a lowercase alias is created as well. Saves anotherkey-press.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sat, 2004-09-11 at 01:15, Wolfson Larry - lwolfs wrote:

> Carel-Jan liked your idea.
>
> We also have a lot of DBs named PROD, TEST, ORCL etc. What we do is
> create a table called DB and put in what we consider to be the "real" name
> and other pertinent info.
>
> So DB name in PROD could be CHICAGO, SFRAN, JACK, DALLAS, or PLANT54 etc.
>
>
> Larry
>
>
>
>
>
> **********************************************************************
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged.
> If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination,
> distribution, or copying of this communication is strictly
> prohibited.
> If you have received this communication in error,
> please re-send this communication to the sender and
> delete the original message or any copy of it from your
> computer system. Thank You.
>
> --
> To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
> To search the archives - http://www.freelists.org/archives/oracle-l/

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/