Re: Multiple service names for a single instance?

From: Murali <oraclems_at_hotmail.com>
Date: 1 Mar 2002 08:38:19 -0800
Message-ID: <22e6597b.0203010838.4cd4cce@posting.google.com>

>> In the listener.ora, tell the listener to listen on two ports for TCP

>> connections.
>> 
>> LISTENER =
>>   (DESCRIPTION =
>>     (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1521))
>>     (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1526))
>>   )
>>   .
>>   .
>>   .
>>   .
>> 

> Have you EVER tried this?

I may not know everything, but I try not to post false information. I tried this on my 9.0.1 database and just copied/pasted to the news group from my files after confirming that this works. I tried it again on an 8.1.7 database after reading your post (not that I doubted myself, just to see if it was a 9i only thing), and guess what ? It worked again.

> I did. Guess what? It doesn't work.

You mean you cant GET it to work.

> Please don't try to make a fool out of me when you don't know what you
> are talking about.
>

I am not getting paid to put you down or anything. Please dont take it personally. I just tried what you said doesnt work, and it worked. But just to show that I do know what I'm talking about, here's my listener status:

LSNRCTL> start
Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.1.7.0.0 - Production System parameter file is
/u01/app/oracle/product/8.1.7/network/admin/listener.ora Log messages written to
/u01/app/oracle/product/8.1.7/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1526)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))

I did not make this up... You can see the listener listening on both 1521 and 1526 for TCP connections. Here's my netstat output:

tcp        0      0 *:2481                  *:*                    
LISTEN
tcp        0      0 *:1526                  *:*                    
LISTEN
tcp        0      0 *:1521                  *:*                    

LISTEN Again both ports show up. Hey, I dont know what you tried, and unless you give me the OS and version information, or prove it doesnt work, I will just take it that the listener can listen on more than 1 port for TCP connections at the same time.

Murali
http://www.dbaquest.com/ Received on Fri Mar 01 2002 - 10:38:19 CST