Re: renaming an instance
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 10 May 2013 20:17:52 +0100
Message-ID: <518D47E0.4010809_at_dunbar-it.co.uk>
On 10/05/13 18:34, Zelli, Brian wrote:
> Ok, the dev group wants the instance name changed.
> I saw some articles when I googled but wondered what is the quickest way to rename an instance?
> ciao,
Date: Fri, 10 May 2013 20:17:52 +0100
Message-ID: <518D47E0.4010809_at_dunbar-it.co.uk>
On 10/05/13 18:34, Zelli, Brian wrote:
> Ok, the dev group wants the instance name changed.
> I saw some articles when I googled but wondered what is the quickest way to rename an instance?
> ciao,
Part 1:
http://qdosmsq.dunbar-it.co.uk/blog/2012/03/rename-an-oracle-10g-or-11g-database/
Part 2:
http://qdosmsq.dunbar-it.co.uk/blog/2012/08/rename-an-oracle-10g-or-11g-database-part-2/
Applies to 10g and/or 11g - untested on anything else. But the procedure outlined t=in those two links works for a non-RAC database.
HTH
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 10 2013 - 21:17:52 CEST