RE: multiple DB's on windoze...
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'greg.loughmiller@xxxxxxxxxxxx'" <greg.loughmiller@xxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Oct 2004 08:59:33 -0400
Greg, I create a 'profile' directory and make sure this directory is in the path. I then create sid.bat files in this directory. The sid.bat file contains all of the oracle environmental info. For example: SET ORACLE_SID=Wtwp SET ORACLE_HOME=C:\Oracle\ora817 Each sid.bat file can manipulate the path depending on which version of Oracle you are running. So your batch files (like rman) can execute this profile file to point to the correct database. I have all kinds of thinkgs in each file - like dba account, password, rman account, password and connect string; directories to hold output from batch files and script files. Mkes life a bit easier. Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- From: Loughmiller, Greg [mailto:greg.loughmiller@xxxxxxxxxxxx] Sent: Friday, October 08, 2004 8:49 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: multiple DB's on windoze... Hey guys, I'm venturing into the windoze world from Unix... I am setting up a 9i and 10g database on this puppy.. And my question is: 1. How do I handle setting the different environment variables between the instances? (i.e. PATH for example) Any other "gotchas" that present differences/issues in doing this on windoze? I have the Unix stuff covered like the dew in Dixie. But I'm walking in the windoze cow pasture, the grass is high, and I just can't avoid some of the "mess" yet... Thanks in advance! Greg Loughmiller -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l