Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle RAC 11gR1: Using wrong cluster interconnect for database

780076Jul 30 2012 — edited Jul 30 2012
Hi All

In Oracle ADDM report finding , we say that oracle is using wrong interface for the interconnect.See the below message

The instance is using the private interconnect device "bond0" with IP address 172.18.165.249 and source "OS dependent software".

In our configuration bond0 is used for public IP and bond1 is used for private IP (for cluster interconnect).

The wrong configuration(bond0 is mentioned instead of bond1) is also confirmed from Oracle Enterprise Manager -- "Cluster Interconnect" tab.


Interfaces in Use by Cluster Databases

Name Target Type Interface Name Host Name IP Address Interface Type Source Transfer Rate (MB/Sec) (Last 5 Minutes)

oraclust Cluster Database


ora1 Database Instance bond0 pccdpidb1 172.18.165.249 Private

OS dependent software .023 *


ora2 Database Instance bond0 pccdpidb2 172.18.165.248 Private

OS dependent software .023 *

whereas on the same page, we can see that cluster interconnect interface used by Hosts is correct bond1(private)

Interfaces by Hosts

Name Type Subnet Interface Type Total I/O Rate (MB/Sec) (Last 5 Minutes) Total Error Rate (%) (Last 5 Minutes)
crs Cluster

pccdpidb1 Host

bond1 Interface 192.168.10.1 Private .0011 *

0 *

pccdpidb2 Host

bond1 Interface 192.168.10.1 Private .0011 *

0 *

Also see the output of oifcfg cmd, which shows the correct configuration for cluster_interconnect.

# oifcfg getif
bond0 172.18.165.0 global public
bond1 192.168.10.1 global cluster_interconnect

# oifcfg iflist -p -n
bond0 172.18.165.128 PRIVATE 255.255.255.128
bond1 192.168.10.0 PRIVATE 255.255.255.128

so bond0 is also shown as "private" and should be corrected.pls suggest procedure to correct this to "public"?

SQL> show parameter cluster

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string


Can you please suggest how to correct the configuration for cluster interconnect from bond0 to bond1?

Regards
VS

Edited by: user5776633 on Jul 29, 2012 11:42 PM

Comments

That's fixed in v4.0.2

Gamblesk

Just installed 4.0.2.15 and the same thing happens.

I put a select sysdate from dual into the child report and I get a new cursor for every refresh when the parent refreshes.

Maybe this will help. This does not appear to happen when the child is set to refresh. Only when the parent is.

I'm not seeing that behavior. I'm counting open cursors by going against v$statname where name = 'opened cursors current'

Gamblesk

I am not sure what is different about what I am doing but here is a child report showing the value of opened cursors current and it count goes up with refreshes.

This also only happens when the type is set to table. It does not happen if the type is set to script.

I can gather anything else you think would be useful but I am not sure what else to add.

cursor_count_1.png

cursor_count_2.png

Parent query

select \* from v$session where username = 'DBA\_MONITOR'

Child query - Hardcoded SID to make sure it was showing right one.

select sysdate, stat.sid,

stat.value, statname.name

from v$sesstat stat,

    v$session sess,

    v$statname statname

where stat.sid = 617

and stat.sid = sess.sid

and statname.statistic# = stat.statistic#

and statname.name = 'opened cursors current'

It took a few minutes to find the exact reproducible scenario - a bit different than the one originally reported that we did FIX.

But, two things:

  1. thanks for the effort here and reporting this
  2. I've reopened the bug with a high priority and hope to have it addressed for our next update
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2012
Added on Jul 30 2012
#cluster, #performance-availability, #real-application-clusters
0 comments
463 views