From oracle-l-bounce@freelists.org Wed Jul 13 06:28:50 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6DBSn9P013273 for ; Wed, 13 Jul 2005 06:28:49 -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 j6DBSjIP013257 for ; Wed, 13 Jul 2005 06:28:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B931F1D1522; Wed, 13 Jul 2005 06:28:40 -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 12145-08; Wed, 13 Jul 2005 06:28:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 423021D1498; Wed, 13 Jul 2005 06:28:40 -0500 (EST) Message-ID: <42D508E3.3090702@inter.net.il> Date: Wed, 13 Jul 2005 14:28:19 +0200 From: Yechiel Adar User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: cichomitiko@gmail.com, Oracle-L@freelists.org Subject: Re: Change hostname after instance creation References: <036c01c58631$43ead4b0$1a03310a@IBME1D11967173> In-Reply-To: <036c01c58631$43ead4b0$1a03310a@IBME1D11967173> Content-Type: multipart/alternative; boundary="------------070802080600010703060009" X-archive-position: 22370 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adar76@inter.net.il Precedence: normal Reply-To: adar76@inter.net.il 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=-1.9 required=5.0 tests=AWL,BAYES_00, FROM_ENDS_IN_NUMS,HTML_MESSAGE autolearn=no version=2.63 --------------070802080600010703060009 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 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? > > > > Regards > Dimitre > > --------------070802080600010703060009 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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

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?

Regards
Dimitre

--------------070802080600010703060009-- -- http://www.freelists.org/webpage/oracle-l