OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Listener (oracle 10g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listener [message #326520]

Wed, 11 June 2008 21:11

dannywcw
Messages: 24
Registered: March 2007

Junior Member

hi,

i have 3 db now running and 3 of them sharing the same listener(LISTENER). Now i want to seperate them so that individually they have their own listener. how can i do that? links? thank you.

Report message to a moderator

Re: Listener [message #326521 is a reply to message #326520]

Wed, 11 June 2008 21:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

>Now i want to seperate them so that individually they have their own listener.
Why?
Only in rare case is anything to be gained by running more than one listener on a system?

Do you realize that two listeners can NOT "share" the same port?
This means you'd need to change tnsnames.ora file to communicate with the 2 new listeners.
Are you ready, willing & able to do so?

>how can i do that?
Answer my questions & I'll answer more of yours.

Report message to a moderator

Re: Listener [message #326523 is a reply to message #326521]

Wed, 11 June 2008 21:54

dannywcw
Messages: 24
Registered: March 2007

Junior Member

i need it because my boss says so

Report message to a moderator

Re: Listener [message #326524 is a reply to message #326523]

Wed, 11 June 2008 22:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

dannywcw wrote on Wed, 11 June 2008 19:54

i need it because my boss says so

Fair enough.

Nothing is impossible for the person who does not have to do it.

I am sure your boss can provide you the details to accomplish the directed task.

Good Luck!

Report message to a moderator

Re: Listener [message #328020 is a reply to message #326523]

Wed, 18 June 2008 11:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

...i need it because my boss says so ...
Is your boss is technical person? or NON-TECHNICAL ?

anyway whatever.
always do which good and best for database, never follow which best/good & said by boss.

Regards,
Taj

Report message to a moderator

Re: Listener [message #328707 is a reply to message #326520]

Sun, 22 June 2008 00:28

ora110
Messages: 42
Registered: September 2007
Location: China

Member

why did your boss say so? I think your boss must not be a technical person.Tt's not a good idea.
The three database share the same listener port is right .It's safe.
you should explain the situation to your boss....
Maybe your boss is right ,you can modify listener.ora and add the other two listener with the deferrent port (eg 1522,1523)
---------------
regards,
Gary

Report message to a moderator

Previous Topic:	Connection Manager woes
Next Topic:	heterogeneous link from oracle XE to firebird

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:39:59 CDT 2024