Re: Changing the Host name.

From: Guido Doumen <gdoumen_at_bart.nl>
Date: Thu, 27 Aug 1998 22:42:47 +0200
Message-ID: <35E5C4C7.81A8A07A_at_bart.nl>

 

 
 
 

IW wrote:
 

Hi,
I'm working on Win NT server 4.0, SP3, with Oracle workgroup server 7.3.4
If i change the server host name after the Oracle was installed, the oracle
stop responding and i have to install the Oracle from start, is there a
better way to do it ?

Hi,
your problem is, that the listener is still trying to listen on the old hostname. So you have to change the configuration of the listener.

The easiest way to make that is to edit the file
%ORACLE_HOME%\network\admin\listener.ora

you should find a entry like

LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (Host = YOURHOSTNAME)
          (PROTOCOL= TCP)
          (Port= 1521)
        )
 ....
  )

replace YOURHOSTNAME by your new hostname or even better by the ip-address

You might also need to change the file
ORACLE_HOME\network\admin\tnsnames.ora
 

Guido Received on Thu Aug 27 1998 - 22:42:47 CEST