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!!!
Cheers

  1. please check your dns server configuration

  2. hi thanks lot man …you rock….

    Yes….it was really useful!!!

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Optimization WordPress Plugins & Solutions by W3 EDGE