| 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: Ok two databases..two machines..one database name
We have two 804 db's with same sid running on two different machines. One is production and another is development. Our TNSNAMES contain machine_name + sid. This way we identify which db we are connecting.
Initially I had lot of problems getting OEM recognize these two db's. When I called up Oracle support, they said that I cannot have two db's with same sid and global name and OEM agent would not recognize. Essentially, they washed off their hands clean.
Then, I played around with the intelligent agent file and finally OEM started recognizing the two db's.
ONE CAUTION: Keep your archived redo's stored separately and come up with a plan on identifying which tape belongs to what machine. Passwords, yes, be careful.
Rao
-----Original Message-----
Sent: Thursday, May 24, 2001 8:41 PM
To: Multiple recipients of list ORACLE-L
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).
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 - 07:04:23 CDT
 |
 |