Change of IP address

Printable View

11-03-2004, 10:45 AM
yls177

Change of IP address

I have changed my ip-address of my server. my os is hpux 11.0, oracle 8.1.7 . I can telnet to the server. The below shows that i am using /etc/hosts

nslookup myhost
using /etc/hosts on : myhost

looking up FILES
Name : myhost
Address : 11.22.33.1

However, i have problems connecting to oracle with the message

TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0

This is resolved by changing the hostname to ip address and both my oracle and listener is up.

Any advise to what must be done so that i can use the hostname instead of the ip address?

Thanks
11-03-2004, 10:56 AM
davey23uk

yes, change all dns entries to use the correct IP address instead of the old one
11-03-2004, 10:59 AM
Mr.Hanky

Quote:

Originally posted by davey23uk
yes, change all dns entries to use the correct IP address instead of the old one

What he said.
11-03-2004, 11:00 AM
hrishy

Hi

Can you ping ur server by hostname as well as by ipadress

regards
Hrishy
11-03-2004, 11:11 AM
yls177

yes, i can ping my server by my hostname and ip address. In my first thread, i specify that i am using /etc/hosts as evidenced by the result of nslookup.

in hpux 11.0, /etc/nsswitch.conf and /etc/resolv.conf determines how the name is being resolved. and my output of nslookup did specify that i am using /etc/hosts.

Please advise
11-03-2004, 11:14 AM
pando

modify listener.ora
11-03-2004, 11:55 AM
yls177

okay, what modifications are u referring to ?

I have changed the hostname to ip address in both listner.ora and tnsnames.ora and my oracle is okay.

However, my application access this oracle has some issues with the hostnames itself.

Please advise
11-03-2004, 12:05 PM
marist89

sounds like a naming issue. Substitute your ip number for the hostname in the tnsnames.ora.
11-03-2004, 01:56 PM
bazza

Quote:

Originally posted by yls177
yes, i can ping my server by my hostname and ip address. In my first thread, i specify that i am using /etc/hosts as evidenced by the result of nslookup.

in hpux 11.0, /etc/nsswitch.conf and /etc/resolv.conf determines how the name is being resolved. and my output of nslookup did specify that i am using /etc/hosts.

Please advise

Can you reverse nslookup?
11-03-2004, 09:20 PM
yls177

Quote:

Originally posted by marist89
sounds like a naming issue. Substitute your ip number for the hostname in the tnsnames.ora.

right. that is going to work for the oracle side. but i have problems with my SAP since it uses the hostname as well. And i cant change this to ip address.
11-03-2004, 10:25 PM
marist89

Quote:

Originally posted by yls177
right. that is going to work for the oracle side. but i have problems with my SAP since it uses the hostname as well. And i cant change this to ip address.

There you go, your DNS is wrong.
11-04-2004, 12:21 AM
yls177

i am on /etc/hosts...
11-04-2004, 10:09 AM
marist89

Quote:

Originally posted by yls177
i am on /etc/hosts...

so. The fact that you can connect from the server but not from a client tells us that the server's dns is using /etc/hosts but the network's dns is something different. The fact of the matter is you changed the hostname. Now you can't connect because the host can not be found. It's pretty common sense.
11-04-2004, 10:55 AM
bazza

Quote:

Originally posted by marist89
so. The fact that you can connect from the server but not from a client tells us that the server's dns is using /etc/hosts but the network's dns is something different. The fact of the matter is you changed the hostname. Now you can't connect because the host can not be found. It's pretty common sense.

Reverse nslookup should show you it as well.
11-05-2004, 10:47 AM
yls177

Quote:

so. The fact that you can connect from the server but not from a client tells us that the server's dns is using /etc/hosts but the network's dns is something different. The fact of the matter is you changed the hostname. Now you can't connect because the host can not be found. It's pretty common sense.

i beg to differ. I didnt change the hostname. I only changed the ip address. And when i changed back to the original ip, i still get the same error messages. Whether its new or original ip address

1) i can still do a ping, telnet of hostname and ip
2) nslookup is resolving to the same hostname and ip.
11-05-2004, 11:06 AM
gandolf989

Quote:

Originally posted by yls177
i beg to differ. I didnt change the hostname. I only changed the ip address. And when i changed back to the original ip, i still get the same error messages. Whether its new or original ip address

1) i can still do a ping, telnet of hostname and ip
2) nslookup is resolving to the same hostname and ip.

But can you do a tnsping? Of course you have already checked you listener.ora and tnsnames.ora files on the server as well as your tnsnames.ora file on the client and you should know for a fact that you aren't hard coding any ip addresses. You might also look at the sqlnet.ora on both the client and server for domain, encryption for anything the might impeed the connection.

And I would also assume that you have restarted the listener recently.
11-05-2004, 11:41 AM
marist89

This is a networking issue. Maybe it's because of a router problem, maybe it's because of a firewall problem, or maybe your DNS is out of sync. Fact is, it's a networking problem. Moving...