Infrastructure at your Service

Michael Hein

SCAN listener does not know about service

When trying to connect to a database via SCAN listener in a RAC environment with sqlplus, an ORA-12514 error is thrown. Tnsping can resolve the connect string. Whereas connecting to the same database over node listener with sqlplus succeeds.

One possible reason could be, that the parameter remote_listener of the database to be connected is not set to SCAN listener of RAC cluster.

So try to set remote_listener to SCAN_LISTENER_HOST:SCAN_LISTENER_PORT like (e.g. host is scan_host, port is 1521):

alter system set remote_listener = 'scan_host:1521' scope=both;

 

One Comment

  • Hi Michael,
    oraagent.bin (the one spawned by crsd) should set
    ALTER SYSTEM SET REMOTE_LISTENER=’ scan_host:1521′ …
    (mind the leading space! this identifies value set by oraagent.bin).
    if it doesn’t, you might check crsd_oraagent_oracle.trc
    oraagent.bin doesn’t set anything if the value is set in spfile already – so check there for any garbage (alert.log shows a history of this value over time)
    hth,
    Martin

     

Leave a Reply

Michael Hein
Michael Hein