Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [SPAM] Re: quick question.. Naming conventions of db sids...

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

From: Carel-Jan Engel <>
Date: Sat, 11 Sep 2004 01:46:53 +0200
Message-Id: <>

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/

l10g_at_dbalert199:/opt/oracle/product/>dgs dgs_at_dbalert199:/opt/oracle/product/>cd bin /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 -
> To search the archives -

To unsubscribe - 
To search the archives -
Received on Fri Sep 10 2004 - 18:34:12 CDT

Original text of this message