Different register and connection IP

Q: If the database registers to IP1 and the listener listens on both IP1 and IP2. Will the client be able to connect to the database via IP2?

A: Yes.

Test environment:

OS: Redhat Linux 6.3 x86_64
DB: Oracle 11.2.0.3 RAC


[grid@bcmsdbs01 admin]$ lsnrctl status LISTENER_TEST

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-MAY-2016 09:40:12

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_TEST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_TEST
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 13-MAY-2016 09:38:39
Uptime 0 days 0 hr. 1 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraapp/grid/gridhome/network/admin/listener.ora
Listener Log File /oraapp/grid/gridbase/diag/tnslsnr/bcmsdbs01/listener_test/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_TEST)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=200.31.43.41)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=200.31.43.43)(PORT=1522)))
Services Summary...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@bcmsdbs01 admin]$ sqlplus caoff/caoff@200.31.43.41:1522/mydb

SQL*Plus: Release 11.2.0.3.0 Production on Fri May 13 09:40:41 2016

Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter listen

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=200.
 31.43.43)(PORT=1522))))
remote_listener string
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s