Tag Archives: SCAN

Error remote connection to SCAN after Oracle RAC 11gR2 installation

If after the installation of Oracle RAC 11gR2, when you try to connect remotely you have the following error:

ORA-12545: Connect failed because target host or object does not exist

connecting on both nodes of RAC you have the following error:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

and both LISTENER and LISTENER_SCAN1 are ok.

Then look at database parameter local_listener.

If it’s pointing to one of vip name’s (NODE1-vip or NODE2-vip), change it to RAC name (RAC01)

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=NODE1-vip)(PORT=1521))))

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC01)(PORT=1521))))';

System altered.

SQL> alter system register;

System altered.

I hope it was useful!!!

Optimization WordPress Plugins & Solutions by W3 EDGE