Home -> Usenet -> comp.databases.oracle -> I am using Oracle 9.2.0.4 on IBM AIX 5.1 L System. Our DB Server had IP of "100.101.102.103" and our Tomcat Application Server (IP of 200.201.202.203) used to talk to above DB onn Port 1521. The system was working great for 6 months or so. Then we

I am using Oracle 9.2.0.4 on IBM AIX 5.1 L System. Our DB Server had IP of "100.101.102.103" and our Tomcat Application Server (IP of 200.201.202.203) used to talk to above DB onn Port 1521. The system was working great for 6 months or so. Then we

From: Hari Om <hari_om_at_hotmail.com>
Date: 28 May 2004 07:53:42 -0700
Message-ID: <d1d5ebe4.0405280653.a829173_at_posting.google.com> 





I am using Oracle 9.2.0.4 on IBM AIX 5.1 L System. Our DB Server had
IP of "100.101.102.103" and our Tomcat Application Server (IP of
200.201.202.203) used to talk to above DB onn Port 1521. The system
was working great for 6 months or so.



Then we changed our Netwok Locations of these Boxes and now both of
them have different IP.


DB IP: 1.2.3.4


App IP: 50.51.52.53



(Note above IP are hypothetically for example)



But now when I run my DB and LSNRCTL, I am surprised that it is still
listeneing on my old IP:





Started with pid=483502


Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100.101.102.103)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))






And so my Application fails to connect to the DB. I tried configuring
my LISTENER (using netmgr/netca and even manually editing listener.ora
file)



I changed all my CONFIGURATION Files (server.xml, tnsnames.ora,
listener.ora etc etc etc....) Did I miss any other file to tell Oracle
that my NEW IP is 1.2.3.4?



Can anyone help me on this solution? Any related information is
appreciated.



THANKS!

Received on Fri May 28 2004 - 16:53:42 CEST












Original text of this message