Unable to register instance to listener
ovasenNov 15 2012 — edited Nov 16 2012Hi.
On our Exadata machine we run single instances as an active-passive cluster managed by the infrastructure.
The listener runs out of the grid infrastructure home. I have tried to register the services by specifying LOCAL_LISTENER with reference to a network ALIAS in the database Oracle Home tnsnames.ora.
I am running three listener, default listener listens to 1521, an additional listener on another IP segment listens to 1522 and one listener from the management network listens to port 1523.
In the ORACLE_HOME tnsnames.ora, for the alias referred to by LOCAL_LISTENER, the HOST is set to the hostnames from /etc/hosts that correpons to the IP address the listeners listens to. Hmm. Good sentence.
So, when I try to run alter system register;, it finishes but nothing happens. I must also add that in the %GRID_HOME%/network/admin/listener.ora, there are some references to static listener registrations. I am wondering if this might affect the outcome. Any Exadata guys out ther who have seen this issue?
Cheers, Kjell Ove Skarsbo.