Home » RDBMS Server » Networking and Gateways » Listener (oracle 10g R2)
icon3.gif  Listener [message #326520] Wed, 11 June 2008 21:11 Go to next message
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.
Re: Listener [message #326521 is a reply to message #326520] Wed, 11 June 2008 21:20 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
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.


Re: Listener [message #326523 is a reply to message #326521] Wed, 11 June 2008 21:54 Go to previous messageGo to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
i need it because my boss says so
Re: Listener [message #326524 is a reply to message #326523] Wed, 11 June 2008 22:04 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
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!
Re: Listener [message #328020 is a reply to message #326523] Wed, 18 June 2008 11:06 Go to previous messageGo to next message
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
Re: Listener [message #328707 is a reply to message #326520] Sun, 22 June 2008 00:28 Go to previous message
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
Previous Topic: Connection Manager woes
Next Topic: heterogeneous link from oracle XE to firebird
Goto Forum:
  


Current Time: Wed Apr 16 15:58:04 CDT 2014

Total time taken to generate the page: 0.13207 seconds