- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- linstener and tnsnames question
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 01:46 AM
тАО04-26-2004 01:46 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 01:54 AM
тАО04-26-2004 01:54 AM
Re: linstener and tnsnames question
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))
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:08 AM
тАО04-26-2004 03:08 AM
Re: linstener and tnsnames question
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:21 AM
тАО04-26-2004 03:21 AM
Re: linstener and tnsnames question
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:32 AM
тАО04-26-2004 03:32 AM
Re: linstener and tnsnames question
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:36 AM
тАО04-26-2004 03:36 AM
Re: linstener and tnsnames question
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:39 AM
тАО04-26-2004 03:39 AM
Re: linstener and tnsnames question
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:42 AM
тАО04-26-2004 03:42 AM
Re: linstener and tnsnames question
So it seems to be oracle specific.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 03:45 AM
тАО04-26-2004 03:45 AM
Re: linstener and tnsnames question
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 04:43 PM
тАО04-26-2004 04:43 PM
SolutionAssuming 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