Network essentials for Oracle RAC DBA

For Oracle RAC install one is expected to know about basic Network related stuff, which will help in troubling shooting some basic stuff.

NOTE: Applicable to Solaris only, other *nix will have equivalent commands.

1. How to check available network interfaces?

# dladm show-dev

bge0 link: up speed: 1000 Mbps duplex: full
bge1 link: unknown speed: 1000 Mbps duplex: full
nxge0 link: unknown speed: 0 Mbps duplex: unknown
nxge1 link: unknown speed: 0 Mbps duplex: unknown
nxge2 link: unknown speed: 0 Mbps duplex: unknown
nxge3 link: unknown speed: 0 Mbps duplex: unknown

This command will show available interfaces, their status, speed etc.

2. How to change the interface properties like changing interface from half to full duplex?

On SPARC
========

# ndd -set /dev/bge instance 0
# ndd -set /dev/bge adv_10fdx_cap 1

On x86
======

# ndd -set /dev/bge0 adv_10fdx_cap 1

This command will change the properties of interface bge0, to full duplex.

3. How to plumb / unplumb the interface?

To plumb the interface
========================

# ifconfig bge0 plumb
# ifconfig bge0 10.20.30.1 netmask 255.255.252.000 up

To unplumb the interface
========================

# ifconfig bge0 unplumb

4. How to make the interface properties persistent across reboot?

# vi /etc/hostname.
add the interface related to properties to the file

Basic example, whould be to associate IP address to the interface

# vi /etc/hostname.bge0
10.20.30.1

5. How to check the default gateway?

# netstat -r

Routing Table: IPv4
Destination Gateway Flags Ref Use Interface
——————– ——————– —– —– ———- ———
default x1253-gateway UG 1 16
10.182.96.0 xyz U 1 18 ge0
10.182.96.0 xyz U 1 0 ge0:1
10.20.28.0 xyz-priv U 1 3 bge0
BASE-ADDRESS.MCAST.NET xyz U 1 0 ge0
localhost localhost UH 38 47226 lo0

Advertisements
This entry was posted in Oracle Real Application Cluster and tagged . Bookmark the permalink.

One Response to Network essentials for Oracle RAC DBA

  1. Pingback: Storage Essentials for Oracle RAC DBA | Oracle-Hands-On

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