OraFAQ Forum: Networking and Gateways » listener configuration

Home » RDBMS Server » Networking and Gateways » listener configuration (Oracle 11gR2 on Solaris)

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

listener configuration [message #595396]

Tue, 10 September 2013 18:44

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?
Thanks

Report message to a moderator

Re: listener configuration [message #595397 is a reply to message #595396]

Tue, 10 September 2013 19:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

caprikar wrote on Tue, 10 September 2013 16:44

Hi,
I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?
Thanks

yes

(What difference does it make?)

BTW, tnsnames.ora is a client only file & is not required on DB Server.
listener.ora is NOT required to start or use any listener!

Report message to a moderator

Re: listener configuration [message #595398 is a reply to message #595396]

Tue, 10 September 2013 20:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check Installing Oracle Grid Infrastructure.

Report message to a moderator

Re: listener configuration [message #595552 is a reply to message #595397]

Wed, 11 September 2013 13:44

caprikar
Messages: 226
Registered: March 2007

Senior Member

Yes? to configure and start the listener from oracle home or from grid home?
If there is no difference, then why oracle provide listener configuration from 2 different homes?

Report message to a moderator

Re: listener configuration [message #595555 is a reply to message #595552]

Wed, 11 September 2013 13:50

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because: 1) grid is not mandatory and 2) it is better to use grid home if you install it; do you need to have listener configuration in all installations to configure it depending on your needs.

Regards
Michel

Report message to a moderator

Re: listener configuration [message #595557 is a reply to message #595555]

Wed, 11 September 2013 13:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Yes? to configure and start the listener from oracle home or from grid home?
Yes to either.
Listener does not know or care which directory is used to start it.
The database does not know or care which directory is used to start the listener.

>If there is no difference, then why oracle provide listener configuration from 2 different homes?
No listener is required to start or use any Oracle DB.
Oracle leaves the choice up to the DBA to decided which choice is "better" for him/her regarding if listener is to be started & from where.

Report message to a moderator

Previous Topic:	Fatal NI connect error 12638, connecting to:
Next Topic:	National Character Set issue in HSODBC (dg4msql).

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 19:21:27 CST 2025