No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

Oracle RAC SCAN IP
Next thread: Audit successful login session for sql developer in oracle database
Prev thread: Golden Gate data retention policy

Message Score Author Date
Hi, In a RAC configuration, nodes (let's ay we ...... Lauri Apr 28, 2020, 19:25
Hi Lauri, SCAN VIPs (virtual IPs) are regular I...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Jan Schnackenberg Apr 28, 2020, 21:25
Hi Jan, Thanks for this explanation, This I un...... Lauri Apr 29, 2020, 06:27
Hi Lauri, very high level view: you tell the Gr...... Jan Schnackenberg Apr 29, 2020, 21:46
Hi Jan, Ok, thanks. This is something I can do ...... Lauri Apr 30, 2020, 11:09

Follow up by mail Click here


Subject: Oracle RAC SCAN IP
Author: Lauri, Netherlands
Date: Apr 28, 2020, 19:25, 101 days ago
Os info: Linux x86 64
Oracle info: 19c, 18c, 12c
Error info: n/a
Message: Hi,

In a RAC configuration, nodes (let's ay we have two nodes) will be given a public IP and a private IP.
It is this possible to ping from one node to the other with one of these IPs.
Does someone know how a SCAN IP can be defined?
It corresponds to a server that in fact does not exist.

Thanks by advance for any explanation.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle RAC SCAN IP
Author: Jan Schnackenberg, Germany
Date: Apr 28, 2020, 21:25, 100 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Lauri,

SCAN VIPs (virtual IPs) are regular IP addresses. They are managed by the Grid Infrastructure and each will be dynamically registered to one of the RAC nodes, and can (and will) be relocated to another node whenever the Grid Infrastructure feels the need to do this ("srvctl relocate" command by the admin, node-down event, etc.).

They are called "virtual IP address" because they are mapped to one of the "virtual host names" in the DNS server. "Virtual" to distinguish them from the physical host name, which is to say, the actual host names of the nodes.

Since these addresses are regular IP addresses, they can be used to initiate and receive IP communication. Most common is, of course, incoming connections from database clients. But yes, you can ping them. Unless a firewall (either on the host itself or between the client and your RAC-node with the started SCAN VIP).


So far a short description of what a SCAN IP is.


Regarding your question and the statement, that "it corresponds to a server that in fact does not exist", I'm not sure I understand what you're trying to say/ask.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Oracle RAC SCAN IP
Author: Lauri, Netherlands
Date: Apr 29, 2020, 06:27, 100 days ago
Message: Hi Jan,

Thanks for this explanation,
This I undersand.
What I do not understand is how to configure SCAN IP if for instance if I have the two nodes in Oracle VirtualBox?
Both virtual nodes have a valid IP hat I can ping, but what about SCAN IP?

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Oracle RAC SCAN IP
Author: Jan Schnackenberg, Germany
Date: Apr 29, 2020, 21:46, 99 days ago
Message: Hi Lauri,

very high level view: you tell the Grid Infrastructure the NAME of your SCAN-VIPs and it will do all the rest automatically.

Remember that the SCAN VIP name is one or more IP-addresses that are all mapped to the same domain-name via DNS (NOT the /etc/hosts file!). For a regular name resolution the DNS server will always answer with one of the configured addresses in round-robin fashion, thereby providing some level of load balancing across the different SCAN VIPs.

So, once your network guys have provided you with the required IP addresses, you have the name your SCAN should use, and both have been configured in the DNS server, you can install your Grid Infrastructure. There you only provide this name, and the Grid Infrastructure will automatically discover all configured IP addresses for this name, configure the matching SCAN-VIP services, start them, configure a SCAN listener for each SCAN-VIP and start those, too.

As far as I remember, you cannot install RAC without this, so... I'm not sure what your setup is, that you feel the need to configure SCAN manually.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Oracle RAC SCAN IP
Author: Lauri, Netherlands
Date: Apr 30, 2020, 11:09, 99 days ago
Message: Hi Jan,

Ok, thanks. This is something I can do myself.

Kind Regards.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here