RE: Multiple databases under the same ORACLE_HOME
Title: Multiple databases under the same ORACLE_HOME If it is the same installation it is under the same home, it's just a different SID. Aren't I right on this? Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey BronfinSent: Monday, June 18, 2001 10:56 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer.
RE: Multiple databases under the same ORACLE_HOME
Title: Multiple databases under the same ORACLE_HOME I have figured it out ! Thanks a lot to everybody who responded ! -Original Message-From: Andrey Bronfin Sent: Monday, June 18, 2001 4:56 PMTo: Multiple recipients of list ORACLE-LSubject: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer.
RE: Multiple databases under the same ORACLE_HOME
Yes. Each db gets its own service, created by you, using the oradim command (and/or two services, and/or oradim80, both depending on the version of Oracle you're running.) You would want to separate the db's data files from the Oracle_Home anyway. The only thing in Oracle_Home would be the init.ora file, which would contain the line ifile=FILENAME where FILENAME is the name of the db's real init.ora file, which you put in its own database specific directory outside of Oracle_Home. Check out the paper(s) on OFA, Oracle Optimal Flexible Architecture, available in many places on the net, I imagine Metalink has it too. HTH, Yosi -Original Message- Sent: Monday, June 18, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer. -- 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).
RE: Multiple databases under the same ORACLE_HOME
Yes it is possible to have mutiple under same oracle home in windows nt. The only thing to do is just go to console and type set oracle_sid=new_sid then create the database with this new sid and thus u can have two databases runing at same time on windows nt --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Multiple databases under the same ORACLE_HOMEIf it is the same installation it is under the same home, it's just a different SID. Aren't I right on this? Kev -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey Bronfin Sent: Monday, June 18, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal 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: Multiple databases under the same ORACLE_HOME
Title: Multiple databases under the same ORACLE_HOME We used to have 4 database instances under the same home on NT. IT worked just fine. In order to set them up we used the ORADIM command and created the services. Once this was done we set the SID and created the DB . Worked fine. -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Monday, June 18, 2001 9:56 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer.
