linstener and tnsnames question

[Juergen Tappe]

Hi,

This might be an easy one for the oracle gurus.

I have an Oracle 8.0.5 NT System, which got a new Network Cards and IP Adresses.

We plan to disable the old (Token Ring) IP Address and let any communication run through the new ether card.

My question what I have to change in listener.ora and tnsnames.ora files.
Do I need to chance any other files I forgeot?

here the content of linster.ora:
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0

LISTENER =
(ADDRESS_LIST =
# (ADDRESS=
# (PROTOCOL= IPC)
# (KEY= PSMP)
# )
(ADDRESS=
(PROTOCOL= TCP)
(Host= psmpnt-prod) # DNS looked up
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = psmpnt-prod) # DNS looked ud
(SID_NAME = PSMP)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)


and here the content of tnsnames.ora:
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0

LISTENER =
(ADDRESS_LIST =
# (ADDRESS=
# (PROTOCOL= IPC)
# (KEY= PSMP)
# )
(ADDRESS=
(PROTOCOL= TCP)
(Host= psmpnt-prod)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = psmpnt-prod)
(SID_NAME = PSMP)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)

To clearify the situation:
The new ether Card is active already (currently both are active).

There are 2 ways of connection oracle. Some local applications and some remote clients.
They both connect to the DNS Name psmpnt-prod.
We want to change the DNS entry to the new IP Address. But we expect because of TTL issues some time before "evrybody" knows about the new IP.
My question is: what I have to change that the server is listening and answering to both adresses.

Thx in advance.

[Juergen Tappe]

sorry messed up cut+paste....

here the tnsnames.ora content:

PSMP.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = psmpnt-prod)(PORT = 1521))
(CONNECT_DATA = (SID = psmp))
)

TEST.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = psmpnt-server)(PORT = 1521))
(CONNECT_DATA = (SID = psmp))
)

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)

[Jeff_Traigle]

I went through an IP address change on Oracle servers on HP-UX. It shouldn't be any different on NT, I would think. Since you are using hostname in the .ora files and (presumably that host name can be resolved on either network), there is no need to change them. The listener listens on all active interfaces on a system. The only thing the HOST entry does is verify at least one exists. (Caveat... since protocols can be bound to specific interfaces in Windows, you might check to be sure that anything Oracle related isn't in there... that would be the one thing I can think of that could possibly make it act differently on NT than UNIX.) If you haven't already, you can go ahead and covert the network configuration (DNS, gateway, etc.) on this server to the new ethernet settings and things should still work until the final cut-off of the token ring side.

[Steven E. Protter]

The IP address change process is the same on any platform.

What you need to do is backup the files, make the changes, and use tnsping to test connectivity. You'll know it works before you try it.

You could avoid this in future upgrades by using hostnames instead of ip addresses. We still use IP addresses, but you don't have to.

SEP

[Juergen Tappe]

Jeff, SEP,
thx for answers.

Hence the system belongs to a customer and the DNS change will be made by another contructor (and we have no access to the DNS server) we want to ensure the system is answering to both IP Adresses.

The customer just tried to connect to the new IP -> no success
With the old IP its fine.

There is i.e. no entry in the hosts file for old or new IP address of the NT server at all.
So the NT server resolves evrything through DNS. Could it be an idea to enter both IPs to hosts files for the same short- and longname.
Do I need to add something to the listner.ora?
I think about adding such lines to the LISTENER = section:
(ADDRESS=
(PROTOCOL= TCP)
(Host= )
(Port= 1521)

Do I need to add anything to the SID_LIST_LISTENER = section as well?

[Juergen Tappe]

SEP, perhaps to make it clearer for you:

you wrote "backup the files,make the changes,..."

I am not sure which changes I have to do to which files.
Pls. could you provide a more specific answer to this question.

[Jeff_Traigle]

What error are you getting when you try to connect to the new IP address? Is just Oracle complaining or can you not resolve the name via DNS at all?

[Juergen Tappe]

ping is working fine - so the card is up, running and answering.

So it seems to be oracle specific.

[Jeff_Traigle]

Hmmm... was the listener bounced once the new interface was brought online? Bouncing and rebooting fixes a lot of problems in Windows, right? :)

[Yogeeraj_1 · Accepted solution]

hi,

Assuming that you have the following setup:
Card at PPA 1 - IP Address: 192.97.14.1
Card at PPA 2 - IP Address: 172.0.28.1

You can modify your listener.ora to be as follows:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.97.14.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.28.1)(PORT = 1527))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

of course at the client-side you should specify the connect listening port (i.e. in the tnsnames.ora)


hope this helps!

regards
Yogeeraj