Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsdst02.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!e66ce0df!not-for-mail From: "Gerry Sinkiewicz" Newsgroups: comp.databases.oracle.server References: <1151929563.088038.183200@p79g2000cwp.googlegroups.com> Subject: Re: Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Message-ID: NNTP-Posting-Host: 64.252.69.151 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr12.news.prodigy.com 1152305059 ST000 64.252.69.151 (Fri, 07 Jul 2006 16:44:19 EDT) NNTP-Posting-Date: Fri, 07 Jul 2006 16:44:19 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: FKPGWWCD[ZTARTTYKBCBNQ@@AZOZ@GXOXJXNMRQIMASJETAANVW[AKWZE\]^XQWIGNE_[EBL@^_\^JOCQ^RSNVLGTFTKHTXHHP[NB\_C@\SD@EP_[KCXX__AGDDEKGFNB\ZOKLRNCY_CGG[RHT_UN@C_BSY\G__IJIX_PLSA[CCFAULEY\FL\VLGANTQQ]FN Date: Fri, 07 Jul 2006 20:44:19 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270629 "Mladen Gogala" wrote in message news:pan.2006.07.05.19.03.59.351477@sbcglobal.net... > On Mon, 03 Jul 2006 05:26:03 -0700, nirav wrote: > > > Since in the clustered environment we have 9.2.0.6 version, is it AT > > ALL POSSIBLE to move this database, which is 9.2.0.7 to that > > enviroment? > > Yes sir. You will have to recreate the controlfile and add another log > thread and change maxinstances parameter. Once that is done, your database > is essentially RAC. > > -- > http://www.mgogala.com > The OP did not mention RAC, just Veritas VCS (failover cluster). For RAC 9i you need either RAW, OCFS (or is that 10g only), or some other cooked disk file system capable of being shared by several instances at one time (like RDB on VAX). What he wants to do is of course possible as Dave Stien wrote. I have many such examples in mind.