OraFAQ Forum: Server Administration » How to create second listener.

Home » RDBMS Server » Server Administration » How to create second listener.

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

How to create second listener. [message #183438]

Thu, 20 July 2006 22:42

bmsharma
Messages: 24
Registered: April 2006
Location: Surat

Junior Member

Hi all

Can anybody tell me that how to create second listener in oracle 10G.

Regards
Bally

Report message to a moderator

Re: How to create second listener. [message #183445 is a reply to message #183438]

Fri, 21 July 2006 00:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

By using vi or editor of choice.
Why do you think that a 2nd listener is needed/desired/required?

Report message to a moderator

Re: How to create second listener. [message #183528 is a reply to message #183438]

Fri, 21 July 2006 04:32

bmsharma
Messages: 24
Registered: April 2006
Location: Surat

Junior Member

Very right sir, any modification in the configuration file has to be opened or modified in the editor.

I need backup listener so that if one fails due to some other reason then requested can be listened by standby listener.

Regards
Bally

Report message to a moderator

Re: How to create second listener. [message #183536 is a reply to message #183438]

Fri, 21 July 2006 04:42

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

start a seperate listener on another port pointing to the same sid
on the client side call the listener you wish to use

Report message to a moderator

Re: How to create second listener. [message #183539 is a reply to message #183438]

Fri, 21 July 2006 04:45

bmsharma
Messages: 24
Registered: April 2006
Location: Surat

Junior Member

Dear Sir, I have already quoted in my previous reply that i need it for the failover.

Report message to a moderator

Re: How to create second listener. [message #183542 is a reply to message #183438]

Fri, 21 July 2006 04:48

bmsharma
Messages: 24
Registered: April 2006
Location: Surat

Junior Member

Ok its mean in listener.ora of the server i have to create the new entries for the new listener and on client side, in TNSname.ora i have to give the entry for new listener.

Am i right?

Report message to a moderator

Re: How to create second listener. [message #183559 is a reply to message #183542]

Fri, 21 July 2006 06:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Dear Sir, I have already quoted in my previous reply that i need it for the failover.
I would not worry much about this. I do not understand how you want to do this.
Listener, is just a listener.
How would you expect it to failover automatically? (Unless you have a failover algorithm as in RAC?).
Consider you have two seperate listeners.
If one fails, other will be still listening.
But how will your application know? You will need to manually edit tnsnames.ora (clientside).
So what is the big idea?
Have a good backup of listener.ora (serverside).
If the listener fails/crashes for some reason, start it again.

Report message to a moderator

Previous Topic:	script creation
Next Topic:	Character set for 10g database for Japanese Language

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:55:42 CDT 2024