I want to use the following string to connect to my Oracle 12c RAC.
CONNECT username/password@localhost:1521/service.mydbhost.com
What is the best way or should I even try to configure the listener to listen on the localhost?
It works on my single node boxes but not the RAC.
We are utlizing dynamic registration and the LOCAL_LISTENER parameter stores this..
SQL> show parameter LOCAL_LISTENER;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.1.1811)(PORT=1521))