Re: How to change host name and IP address

On Mon, 27 Mar 2006 12:02:01 +0200, "Thomas Vedel" <thv_at_lr.dk> wrote:

>I have made a test installation of an Oracle 10g database on a host, that I
>want to give a new host name and IP number.
>
>I am new to Oracle and can not figure out what to change to make the
>database accessible after the renaming. Any hints on how to proceed - e.g.
>to any documentation - would be greatly appreciated.
>
>Best regards
>
>Thomas Vedel
>Danish Agricultural Advisory Service
>

Oracle 10g is imprecise. Oracle10g and Oracle10g XE may be different beasts with respect to connectivity.
On a normal 10g you'll need to reconfigure listener.ora and tnsnames.ora. Information about configuring those files can be found in the Getting Started Manual and the Net Administrator Manual.

--
Sybrand Bakker, Senior Oracle DBA