Home » RDBMS Server » Networking and Gateways » Listener (Oracle 11g OS - AIX)
Listener [message #463929] Mon, 05 July 2010 04:54 Go to next message
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
Re: Listener [message #463930 is a reply to message #463929] Mon, 05 July 2010 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Listener [message #463932 is a reply to message #463930] Mon, 05 July 2010 05:12 Go to previous messageGo to next message
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?
Re: Listener [message #463939 is a reply to message #463932] Mon, 05 July 2010 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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.
Previous Topic: Can't Connect to Remote DB Listener
Next Topic: MS Access to Oracle DB
Goto Forum:
  


Current Time: Thu Mar 28 05:45:42 CDT 2024