oracle rac _oifcfg iflist -p -n,Oracle Rac常用维护工具命令

oracle RAC 常用维护工具命令

---查看集群节点列表

[grid@rac1 bin]$ ./olsnodes --hlep

Usage: olsnodes [ [-n] [-i] [-s] [-t] [ | -l [-p]] | [-c] ] [-g] [-v]

where

-n print node number with the node name

-p print private interconnect address for the local node

-i print virtual IP address with the node name

print information for the specified node

-l print information for the local node

-s print node status - active or inactive

-t print node type - pinned or unpinned

-g turn on logging

-v Run in debug mode; use at direction of Oracle Support only.

-c print clusterware name

---查看节点列表

[grid@rac1 bin]$ ./olsnodes

rac1

rac2

[grid@rac1 bin]$ ./olsnodes -n

rac1    1

rac2    2

[grid@rac1 bin]$ ./olsnodes -n -i -t

rac1    1    rac1-vip    Unpinned

rac2    2    rac2-vip    Unpinned

----查看网络配置

[grid@rac1 bin]$ ./oifcfg

Name:

oifcfg - Oracle Interface Configuration Tool.

Usage:  oifcfg iflist [-p [-n]]

oifcfg setif {-node | -global} {/:}...

oifcfg getif [-node | -global] [ -if [/] [-type ] ]

oifcfg delif {{-node | -global} [[/]] [-force] | -force}

oifcfg [-help]

- name of the host, as known to a communications network

 - name by which the interface is configured in the system

  - subnet address of the interface

 - type of the interface { cluster_interconnect | public }

---列出网卡网段

[grid@rac1 bin]$ ./oifcfg iflist

eth0  192.16.3.0

eth1  10.16.6.0

eth1  169.254.0.0

[grid@rac1 bin]$ ./oifcfg getif

eth0  192.16.3.0  global  public

eth1  10.16.6.0  global  cluster_interconnect

[grid@rac1 bin]$ ./oifcfg getif -type public

eth0  192.16.3.0  global  public

[grid@rac1 bin]$

-----./crsctl query 查询节点信息

[grid@rac1 bin]$ ./crsctl query

Usage:

crsctl query crs administrator

Display admin list

crsctl query crs activeversion

Lists the Oracle Clusterware operating version

crsctl query crs releaseversion

Lists the Oracle Clusterware release version

crsctl query crs softwareversion [| -all]

Lists the version of Oracle Clusterware software installed

where

Default         List software version of the local node

nodename        List software version of named node

-all            List software version for all the nodes in the cluster

crsctl query css ipmiconfig

Checks whether Oracle Clusterware has been configured for IPMI

crsctl query css ipmidevice

Checks whether the IPMI device/driver is present

crsctl query css votedisk

Lists the voting files used by Cluster Synchronization Services

crsctl query wallet -type [-name ] [-user ]

Check if the designated wallet or user exists

where

wallet_type     Type of wallet i.e. APPQOSADMIN, APPQOSUSER or APPQOSDB.

name            Name is required for APPQOSDB wallets.

user_name       User to be queried from wallet.

crsctl query dns -servers

Lists the system configured DNS server, search paths, attempt and timeout values

crsctl query dns -name [-dnsserver ] [-port ] [-attempts ] [-timeout ] [-v]

Returns a list of addresses returned by DNS lookup of the name with the specified DNS server

Where

name                Fully qualified domain name to lookup

DNS_server_address  Address of the DNS server on which name needs to be looked up

port                Port on which DNS server is listening

attempts            Number of retry attempts

timeout             Timeout in seconds

crsctl query socket udp [-address

] [-port ]

Verifies that a daemon can listen on specified address and port

Where

address             IP address on which socket needs to be created

port                port on which socket needs to be created

[grid@rac1 bin]$

---eg

[grid@rac1 bin]$ ./crsctl query crs softwareversion

Oracle Clusterware version on node [rac1] is [11.2.0.4.0]

[grid@rac1 bin]$ ./crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

1. ONLINE   8c93743e52a74f5dbff93cadb03ae8fe (ORCL:DISK1) [DATA1]

Located 1 voting disk(s).

[grid@rac1 bin]$

[grid@rac1 bin]$ ./crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

---集群节点心跳最大延时，以秒为单位

[grid@rac1 bin]$ ./crsctl get css disktimeout

CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.

[grid@rac1 bin]$