Re: Ok two databases..two machines..one database name
Paul, why are you sorry? You CAN have two databases with the same database name on different machines. Differing passwords is a good idea, I should have thought of it. I would NOT however, name the tnsnames.ora entries the same name on the two machines, that's another way to help prevent problems. From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Ok two databases..two machines..one database name Date: Thu, 24 May 2001 21:20:21 -0800 Rachel Carmichael wrote: short answer: yes you can From: Steve McClure [EMAIL PROTECTED] 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 Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't that helpful: Use the service_name : schema in your sql prompt - and - more importantly - use unique passwords on each database. Very helpful when you're brain dead to prevent you from having to test your recovery skills in an unscheduled setting. Sorry Rachel. :) Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).
RE: Ok two databases..two machines..one database name
When we do this (alongwith giving different passwords), we differentiate in tnsnames by using the server_sid type idea eg, SERVER1_TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521)) (CONNECT_DATA = (SID = TEST) ) ) SERVER2_TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER2)(PORT = 1521)) (CONNECT_DATA = (SID = TEST) ) ) Therefore when we need to connect it would use the differing connect strings. Regards Lee -Original Message- Sent: 25 May 2001 12:11 To: Multiple recipients of list ORACLE-L Paul, why are you sorry? You CAN have two databases with the same database name on different machines. Differing passwords is a good idea, I should have thought of it. I would NOT however, name the tnsnames.ora entries the same name on the two machines, that's another way to help prevent problems. From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Ok two databases..two machines..one database name Date: Thu, 24 May 2001 21:20:21 -0800 Rachel Carmichael wrote: short answer: yes you can From: Steve McClure [EMAIL PROTECTED] 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 Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't that helpful: Use the service_name : schema in your sql prompt - and - more importantly - use unique passwords on each database. Very helpful when you're brain dead to prevent you from having to test your recovery skills in an unscheduled setting. Sorry Rachel. :) Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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). 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
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: [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: Rao, Maheswara 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).
RE: Ok two databases..two machines..one database name
Thanks All. My test was also successful. I had planned on two different aliases in tnsnames.ora. Otherwise I would be doomed to failure. I will implement the differing passwords idea though. Thanks again. Hey that is two in a row, where I was pretty much right, but needed a little confirmation. I had better be careful or I am going to confidently screw up my database one of these days. Steve McClure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rao, Maheswara Sent: Friday, May 25, 2001 6:11 AM To: Multiple recipients of list ORACLE-L Subject: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: [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: Rao, Maheswara 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: 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).
Re: Ok two databases..two machines..one database name
Steve, I see that you were successful in getting this to work, but thought I might add to it just a bit. I've moved that system from one box to another before, with the addition of changing the SID and DB name. You may not want to do that for some reason, but it just involves 3 other steps: 1. rebuild the control file with the new db name 2. change the SID in the oratab file 3. change the db_name in init.ora 4. change the GLOBAL_NAME with ALTER DATABASE OK, that's 4. I thought of another while writing it. Jared On Thursday 24 May 2001 17:40, Steve McClure wrote: 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: Jared Still 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).
Re: Ok two databases..two machines..one database name
Rachel Carmichael wrote: short answer: yes you can From: Steve McClure [EMAIL PROTECTED] 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 Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't that helpful: Use the service_name : schema in your sql prompt - and - more importantly - use unique passwords on each database. Very helpful when you're brain dead to prevent you from having to test your recovery skills in an unscheduled setting. Sorry Rachel. :) Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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).