Re: Cannot connect to ORACLE after changing IP address

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Mon, 23 Jul 2001 07:56:05 +0200
Message-ID: <9jgea7$oa5$1@ctb-nnrp2.saix.net>

"Gunawan Santoso" <gunawans_at_rad.net.id> wrote

> I couldn't connect to my oracle 8.0.5 server after I changed the
> IP address

<snipped>
> Question: How to fix this problem? What is the proper step of changing
> address for Oracle server?

You need to edit the LISTENER.ORA file and correct the IP address on which the listener must listen. It is also safer to rather use the local hostname instead of hardcoding the IP address in the LISTENER.ORA. This way the listener will resolve the hostname and get the correct IP address.

If you also have a TNSNAMES.ORA entry for your local database, you will need to fix the IP address there to. Comments about using hostname instead, also applies.

Both these files should be in:
C:\OraNT\net80\admin
or
C:\OraNT\network\admin

(assuming that C:\OraNT is your Oracle Home)

--
Billy

Received on Mon Jul 23 2001 - 00:56:05 CDT