From oracle-l-bounce@freelists.org Wed Jul 13 08:33:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6DDXN6n032026 for ; Wed, 13 Jul 2005 08:33:23 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6DDXKIP032012 for ; Wed, 13 Jul 2005 08:33:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8CC671D12A2; Wed, 13 Jul 2005 08:33:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03601-05; Wed, 13 Jul 2005 08:33:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A4951D162E; Wed, 13 Jul 2005 08:33:11 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=MVO5BG4JuHMzShZH76qfdY+gGy6PWKJrdyzWfaja2/CJEmHAHzTMhqDdWj0tM+FvnST4wDQXR4NW8UF6ffBBQ/D32Gm18xTIjk6fe00fFMEIFS6/3HFF1BfZbdzYV1trotm6cdr2MSEJmC0LpHtDF/ayNVIWRn98bw2I91h6XgE= Message-ID: <02df01c587af$17bb13d0$1a03310a@IBME1D11967173> From: "Radoulov, Dimitre" To: "Yechiel Adar" , References: <036c01c58631$43ead4b0$1a03310a@IBME1D11967173> <42D508E3.3090702@inter.net.il> Subject: Re: Change hostname after instance creation Date: Wed, 13 Jul 2005 15:30:51 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02DC_01C587BF.DA16D580" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-archive-position: 22380 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.1 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_02DC_01C587BF.DA16D580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks! Dimitre=20 ----- Original Message -----=20 From: Yechiel Adar=20 To: cichomitiko@gmail.com ; Oracle-L@freelists.org=20 Sent: Wednesday, July 13, 2005 2:28 PM Subject: Re: Change hostname after instance creation What we did was to temporarily add a new drive (D). Then we built a database on that drive ( with the same sid) , removed = the extra drive and plugged in the new mount point. You will need to copy the password file from the temporary server to = the new server, or recreate it. Work like a charm. The database=20 Adar Yechiel Rechovot, Israel is there something to reconfigure (Oracle software or Oracle = instance) in addition to the host name entries in = tnsnames.ora/listener.ora?=20 Regards Dimitre=20 ------=_NextPart_000_02DC_01C587BF.DA16D580 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Thanks!

Dimitre

----- Original Message -----
From:=20 Yechiel=20 Adar
To: cichomitiko@gmail.com ; Oracle-L@freelists.org =

Sent: Wednesday, July 13, 2005 = 2:28=20 PM

Subject: Re: Change hostname = after=20 instance creation

What we did was to temporarily add a new drive = (D).
Then we=20 built a database on that drive ( with the same sid) , removed the = extra drive=20 and plugged in the new mount point.
You will need to copy the = password file=20 from the temporary server to the new server, or recreate = it.

Work like=20 a charm.

The database
Adar Yechiel Rechovot, Israel

is there = something to=20 reconfigure (Oracle software or Oracle instance) in addition to the = host=20 name entries in tnsnames.ora/listener.ora?

Regards
Dimitre

------=_NextPart_000_02DC_01C587BF.DA16D580-- -- http://www.freelists.org/webpage/oracle-l