Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER SYSTEM SET local_listener at instance startup: where is the value taken from ?

1007321Sep 23 2014 — edited Oct 3 2014

Hello,

We're on 11gR2, with several two-node RACs and Grid infra.

I've noticed something strange: on some instances, when booting, I see in my alert.log

~ ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=12.3.32.127)(PORT=1521))' SCOPE=MEMORY SID='...';

and for other databases, when an instance is starting up again, something different can be seen: the VIP hostname instead of

its IP address, kind of:

~ ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=pprracsrv02)(PORT=1521))' SCOPE=MEMORY SID='...';

My question: where does the clusterware pick up this value to automatically set your local_listener when an instance is rebooted ?

Thanks.

Seb

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2014
Added on Sep 23 2014
2 comments
2,457 views