Rachel,
I love that nice short answer. But I'll take the LONG road, if you please.
Steve,
The SID has nothing to do with the database outside of the physical bounds
of the computer your running it on. Over here I'm still running with a very OLD
way of setting up SIDs that came up through V5. Back then with SQL*Net V1
Oracle recommended setting your SIDs to something that was "case insensitive".
The reason is that the connect string back then was "T:<hostname>:<sid>" so a
SID of 'PROD' was different than 'prod' and it could become troublesome to
explain it all the time. Well the only thing I can think of that are totally
case insensitive are numbers. Consequently whenever we set up a new machine the
first instance thereon was designated '02'. Fifteen machines later the strategy
still works, makes sense to those of us configuring Oracle Names, and the users
could care less. So just as long tnsnames or Oracle Names points to the right
database with the right name, your all right.
Dick Goulet
____________________Reply Separator____________________
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date: 5/24/2001 5:10 PM
short answer: yes you can
>From: "Steve McClure" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Ok two databases..two machines..one database name
>Date: Thu, 24 May 2001 16:40:50 -0800
>
>I have been tasked with moving a production database to a 'backup' machine.
>I ran my plan past you a week or so ago. Essentially I will put the DB in
>backup mode, copy the datafiles, shutdown, copy redo and control files,
>then
>recover on the second machine. So far plain vanilla. I understand the
>above procedure enough to have actually thought of it.
>
>My problem now is this. I need to test this instance on the 'backup'
>machine before we actually do the move. This is Just to make sure the
>application is completely in order. One of the developers is telling me
>that having the two databases up and running with the same SID, even on
>separate machines MAY cause trouble for the production instance. I believe
>that if I make sure the tnsnames.ora file for both servers points to their
>own local instances, that I will not have a problem. The clients will only
>access the database pointed to in their tnsnames files, so I am confident
>we
>are ok there. My question is can I have databases with the same name
>running simultaneously on two different machines if I make sure the
>tnsnames
>for each database points to it's own server? The database is 7.3.4. As
>soon as I send this off I am going to create a small DB just to test this
>out, but your input, as usual, is appreciated.
>
>Thanks,
>Steve McClure
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve McClure
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
