Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle RAC Listener fullname and IP address

How do I confirm the the pulblic ip, private ip and VIP in each node for an oracle database in order to configure listeners in OEM. Is there a show parameter command for that?

I tried srvctl config nodeapps -a

I did nslookup, but I want to confirm the IP address of the RAC listener.

I'm aware of cat /etc/hosts but I want to confirm it via oracle parameters or sql statement or srvctl command. I don't feel there is a direct way.

show parameter local_listener will give me VIP for example.

Configure listener in OEM requires Net Address data which is still failing. Thought maybe you guys may have an idea.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center