| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Ok two databases..two machines..one database name
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" <carmichr_at_hotmail.com> Date: 5/24/2001 5:10 PM
short answer: yes you can
>From: "Steve McClure" <steve_at_pactr.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: steve_at_pactr.com
>
>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: ListGuru_at_fatcity.com (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: Rachel Carmichael INET: carmichr_at_hotmail.com 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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).Received on Fri May 25 2001 - 09:16:15 CDT
 |
 |