OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Listener (Oracle 11g OS - AIX)

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

Listener [message #463929]

Mon, 05 July 2010 04:54

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Hi,

In one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.

In the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?

As we created another one new database in the database, I am wondering where i need to add this SID in the listener.ora file to reload the listener.

Any suggestions pls

Prashanth

Report message to a moderator

Re: Listener [message #463930 is a reply to message #463929]

Mon, 05 July 2010 05:05

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

Senior Member
Account Moderator

Quote:

I am wondering where i need to add this SID in the listener.ora file to reload the listener.

Where you want but following the listener.ora syntax. See Net Services Reference

Regards
Michel

Report message to a moderator

Re: Listener [message #463932 is a reply to message #463930]

Mon, 05 July 2010 05:12

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Thanks for your quick reply.

I added the entry in the listener.ora file with new entries, but no luck after reloading it.

As I said earlier I am unable to see none of the SIDs in the listener.ora file, but if I mention the lsnrctl status it gives all the service up with listener running.

I am not sure which file it refers?

Report message to a moderator

Re: Listener [message #463939 is a reply to message #463932]

Mon, 05 July 2010 05:45

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

Senior Member
Account Moderator

In these days, you do not find SID in listener.ora file, instance registers itself to the listener.
Please read Net Services Administrator's Guide.

Regards
Michel

[Updated on: Mon, 05 July 2010 05:45]

Report message to a moderator

Re: Listener [message #464010 is a reply to message #463939]

Mon, 05 July 2010 16:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I added the entry in the listener.ora file with new entries, but no luck after reloading it.
>As I said earlier I am unable to see none of the SIDs in the listener.ora file

With V10+ the listener.ora file is NOT required as long as you are willing to accept all default values.

Report message to a moderator

Previous Topic:	Can't Connect to Remote DB Listener
Next Topic:	MS Access to Oracle DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 20 03:47:59 CST 2025