From: Jolet, John (John.Jolet@MISYSHEALTHCARE.COM)
Date: Thu Nov 21 2002 - 12:49:20 EST
or maybe you've got dns cached?
-----Original Message-----
From: Bullerwell, Edward [mailto:edward.bullerwell@SOBEYS.COM]
Sent: Thursday, November 21, 2002 11:44 AM
To: aix-l@Princeton.EDU
Subject: Re: Oracle problem
The only explanation I can think of is that you are accessing the wrong
listener.ora file, or there is a problem in your /etc/hosts file.
The listener.ora has the hostname, and the listening port in the form
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = 152x))
)
)
The environment variable TNS_ADMIN points to the directory holding the
tnsnames.ora and listener.ora; if this variable
is not present, the listener.ora file is located in
$ORACLE_HOME/network/admin/listener.ora.
-----Original Message-----
From: Adityanarayana K (SYSTEMS-ISL-ITPL)
[ mailto:adityanarayanak@VYSBANK.COM <mailto:adityanarayanak@VYSBANK.COM> ]
Sent: Thursday, November 21, 2002 12:37 PM
To: aix-l@Princeton.EDU
Subject: Oracle problem
Hi,
Can any one help me in the following scenario.
We have oracle database tested in staging. Oracle 8.1.7 running on AIX
4.3.3. The server is having multiple adapters.
We moved the server to another subnet. While doing this we dropped the
previous IP addr and assigned new IP.
We changed listner.ora and tnsnames.ora to point to changed IP.
Restarted database and Listner.
But, the listner is starting with changed IP with Old hostname.
How to get new hostname
Thanks and regards
<< File: InterScan_Disclaimer.txt >>
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:22 EDT