Skip to Main Content

Database Software

How users connections are established on RAC ENV

JhilJan 15 2018 — edited Jan 16 2018

Dear RAC Experts,

>> On Node1

Public   : 192.168.212.40

Private  : 10.0.0.1

Virtual  : 192.168.212.70

>> On Node2

Public   : 192.168.212.41

Private  : 10.0.0.2

Virtual  : 192.168.212.71

Cluster may Active-Active or Active Passive !

>> Is this exactly correct ?

User are initially connected to Virtual IP (which is running on NODE1),

   then user's  connections are routed to Public IP of the NODE1.

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2018 02:05:44

Copyright (c) 1991, 2009, 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.1.0 - Production

Start Date                16-JAN-2018 02:04:46

Uptime                    0 days 0 hr. 0 min. 59 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/product/11.2.0/grid_home/network/admin/listener.ora

Listener Log File         /u01/app/grid/diag/tnslsnr/RAC1/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "crms" has 1 instance(s).

  Instance "crms1", status READY, has 1 handler(s) for this service...

Service "crmsXDB" has 1 instance(s).

  Instance "crms1", status READY, has 1 handler(s) for this service...

Service "tesco" has 1 instance(s).

  Instance "tesco", status READY, has 1 handler(s) for this service...

Service "tescoXDB" has 1 instance(s).

  Instance "tesco", status READY, has 1 handler(s) for this service...

The command completed successfully

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2018
Added on Jan 15 2018
8 comments
503 views