Re: How to change host name and IP address

Hi Sybrand,

I had figured out myself that I should reconfigure listener.ora and tnsnames.ora - but unfortunately that did not work: I could not connect to the database afterwards.

After restarting the server several times everything suddenly works like expected.
Hmmm..... :-/

Thank you very much for your assistance.

By the way: I am running Oracle10g (not XE) on Win32.

• Thomas

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:gg8g22h139d8v1q6vu9gjmmrduadi547ld_at_4ax.com...
> 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
Received on Tue Mar 28 2006 - 05:49:01 CST