3 Replies Latest reply: Feb 18, 2014 9:41 PM by Lonion RSS

    How to add PUBLIC IP to the Listener?

    Lonion

      Oracle Version: 11.2.0.3

      OS: RedHat Linux

      Number of Nodes: 2

       

      On node1:

       

      When I want to connect the database through PUBLIC IP, it occur ora-12541. I know why, because the PUBLIC IP didn't listen by the LISTENER like below.

      [grid@rac1 admin]$ lsnrctl status

       

       

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-FEB-2014 11:07:27

       

       

      Copyright (c) 1991, 2011, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

      Start Date                19-FEB-2014 10:47:02

      Uptime                    0 days 0 hr. 20 min. 24 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/grid/network/admin/listener.ora

      Listener Log File         /u01/app/gridb/diag/tnslsnr/rac1/listener/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.171)(PORT=1521)))         # 192.168.2.171 is Virtual IP

       

      cat endpoints_listener.ora

      [grid@rac1 admin]$ cat endpoints_listener.ora

      LISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)(IP=FIRST))))         # line added by Agent

       

      So, my question is 「How to add PUBLIC IP to the Listener and make it like below?」

      [grid@rac1 admin]$ lsnrctl status

       

       

      LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-FEB-2014 11:07:27

       

       

      Copyright (c) 1991, 2011, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

      Start Date                19-FEB-2014 10:47:02

      Uptime                    0 days 0 hr. 20 min. 24 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/grid/network/admin/listener.ora

      Listener Log File         /u01/app/gridb/diag/tnslsnr/rac1/listener/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.161)(PORT=1521)))         # 192.168.2.161 is PUBLIC IP

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.171)(PORT=1521)))         # 192.168.2.171 is Virtual IP