Rac listeners

[satish]

Dear erman,

Do we need to ser local listener paremeter for both database and asm instances

According to Real Application Clusters Installation Guide During Oracle Database creation, the LOCAL_LISTENER parameter is automatically configured to point to the local listener for the database. The Database Agent sets the LOCAL_LISTENER parameter to a connect descriptor that does not require a TNS alias.

Thank you

[ErmanArslansOracleBlog]

You need to have a local listeners for your database instances.. If you have a 2 node rac, then you need to have at least one local listener per node. (total 2 local listeners)
you can think like;

clients connect through the scan listener, and scan listener redirects the connections to the local listeners.
local listeners triggers the shadow processes and connects the clients to these shadow processes.

And yes, ASM instances also have local listener parameters set.

[satish]

Thanks for the update erman.


Local listeners for databases should run from oracle home or grid home?

[ErmanArslansOracleBlog]

local listener can be run on GRID Homes or RDBMS homes..
the general recommendation is "running local listeners from GRID homes)

[satish]

Thanks erman,

Even if we run local listener from GRID HOME,local_listener parameter should be set in spfile for oracle instance right?

[ErmanArslansOracleBlog]

in any case, set it in spfile.

[ErmanArslansOracleBlog]

And yes.
İt should be set in RDBMS's spfile.

[satish]

Thanks erman for making it clear