By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,665 Members | 1,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,665 IT Pros & Developers. It's quick & easy.

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.

P: n/a
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!
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hari Om wrote:
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!


Tomcat? jdbc, probably. Check the WEB_INF direcory for
application specific .properties file(s). There
should be a connection entry in it, which could
contain an IP-address.
Next time, make sure your DNS is up and working,
and stick to that.
--

Regards,
Frank van Bortel

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.