RAC - Remote Listener Issue
Hey guys, I have an open call with the oracle support, but they are just to slow, so I need to ask the real experts :-)
I have 2 Node RAC with 3 databases on it.
Also I have 2 more machine which have the connection manager installed and those are used to connect to the database via a web application. All good......
I created a listener entry for the connection manager cluster and set the parameter remote_listener to this entry.
So one of the 3 database is registering its service on the connection manager. Still all good. Login vie the the webapp works fine.
BUT !!! When I try a local sql connection ( connect sys/password@dbsrv as sysdba) it comes up the an TNS error code.
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor. tnsping works fine for the database. the normal listener is also showing the correct status of the database
lsnrctl status....
Service "dbsrv" has 1 instance(s).
Instance "dbsrv1", status READY, has 2 handler(s) for this service...
....
When I set the parameter remote_listener to the cluster "scan_listener:1521" the sql connection works.
Also I can´t get a valid cluster ressource connection status in the enterprise manager, when the parameter remote_listener is set to cman listener.
When the parameter is set to the cluster scan name the enterprise manager is working fine as well
But when its set to the cluster listener, the database is not registering with the connection manager listener. So no login would be possible.
So two questions left....
Can I have an additional entry for the connection manager in the tnsnames.ora and set the parameter remote_listener to this entry ?
What impact does this have -
Why is a local sql connect not possible, when the parameter remote_listener is not set ?
The EM is a non prior problem, but any ideas to that as well ?