From: Knut Talman Newsgroups: comp.databases.oracle.server Subject: Re: Changing IP address and name of Solaris box, ISSUES? Date: Thu, 07 Jun 2001 04:10:11 +0200 Organization: myToys.de GmbH Lines: 19 Message-ID: <3B1EE283.4E1DB4B4@mytoys.de> References: <5C1D33C965BC92CE.08778BD87001DEA2.2C84C72EB4D2A1AB@lp.airnews.net> NNTP-Posting-Host: h-213.61.134.194.host.de.colt.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: crusher.de.colt.net 991879812 26047 213.61.134.194 (7 Jun 2001 02:10:12 GMT) X-Complaints-To: usenet@news1.de.colt.net NNTP-Posting-Date: 7 Jun 2001 02:10:12 GMT X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: de > What would I have to change for oracle to continue to work on a solaris box, > if I change the IP and name? I don't have to re-install do I? Unfortunately you *will have* to re-install! Just kidding... You only have to adjust your sqlnet.ora, listener.ora and tnsnames.ora to reflect your new settings. You have to do this on the server, the clients need a change in tnsnames.ora and sqlnet.ora (if you also changed the domain). Regards, Knut -- Knut Talman Fon +49 30 72 62 01 411 dba@myToys.de Fax +49 30 72 62 01 222 The degree of normality in a database is inversely proportional to that of its DBA