Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

linstener and tnsnames question

SOLVED
Go to solution
Juergen Tappe
Valued Contributor

linstener and tnsnames question

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.
Working together
10 REPLIES
Juergen Tappe
Valued Contributor

Re: linstener and tnsnames question

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))
)
Working together
Jeff_Traigle
Honored Contributor

Re: linstener and tnsnames question

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.
--
Jeff Traigle
Steven E. Protter
Exalted Contributor

Re: linstener and tnsnames question

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Juergen Tappe
Valued Contributor

Re: linstener and tnsnames question

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?
Working together
Juergen Tappe
Valued Contributor

Re: linstener and tnsnames question

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.
Working together
Jeff_Traigle
Honored Contributor

Re: linstener and tnsnames question

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?
--
Jeff Traigle
Juergen Tappe
Valued Contributor

Re: linstener and tnsnames question

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

So it seems to be oracle specific.
Working together
Jeff_Traigle
Honored Contributor

Re: linstener and tnsnames question

Hmmm... was the listener bounced once the new interface was brought online? Bouncing and rebooting fixes a lot of problems in Windows, right? :)
--
Jeff Traigle
Yogeeraj_1
Honored Contributor
Solution

Re: linstener and tnsnames question

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Juergen Tappe
Valued Contributor

Re: linstener and tnsnames question

Thx Yogeeraj,

thats excactly the way I fixed it inbetween, except I used the same port (1521) both both IPs.
Working together