| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Second listener is not working
Hi
How are you testing your new listener? Did you update a tnsnames to point to the new listener and the connect to it that way. What are you getting with tnsping it will provide data based upon how you advise your client to connect ie whats in your tnsnames file on the client.
Netstat -al is a good start for checking what ports are open and listening. Try some of the other options of netstat to see what works best for you
Cheers
-----Original Message-----
From: J. Dex [mailto:cemail_219_at_hotmail.com]
Sent: Monday, 27 August 2007 12:05 PM
To: oracle-l_at_freelists.org
Subject: Second listener is not working
Why would a database not connect under a new listener on a different
port
(1522) but will still connect under the old listener (1521) even though
it is no longer in the sid_desc list for that listener and both
listeners have been bounced?
I created a second listener using netca (9206 on Linux) on a different
port.
I then altered listener.ora to move one of the databases so that it
would now be under the description for the second listener on the other
port. I stopped and restarted both listeners. When I try to connect,
it will still only connect to the 1521 port listener (even though it is
not under that description anymore). I get ORA-12535 when trying to
connect with it under the correct port (1522) with the second listener.
On Linux, I am not sure how to tell if the 1522 port is open.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Aug 26 2007 - 23:56:19 CDT
 |
 |