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

How to add PUBLIC IP to the Listener?

Lonion Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points