Oracle Rac常用维护工具命令

加入收藏设为首页

Oracle管理: Oracle Rac常用维护工具命令
时间：2012/1/4 23:25:42 作者：solgle 来源：www.solgle.com 查看：874 评论：0
内容摘要：oracle RAC 常用维护工具命令---查看集群节点列表[grid@rac1 bin]$ ./olsnodes --hlepUsage: olsnodes [ [-n] [-i] [-s] [-t] [ | -l [-p]] | [-c] ] [-g] [-v]...
oracle RAC 常用维护工具命令

---查看集群节点列表

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

Usage: olsnodes [ [-n] [-i] [-s] [-t] [<node> | -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

<node> 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

本文出自：http://www.solgle.com/news/108.html

---查看节点列表

[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 <nodename> | -global} {<if_name>/<subnet>:<if_type>}...

oifcfg getif [-node <nodename> | -global] [ -if <if_name>[/<subnet>] [-type <if_type>] ]

oifcfg delif {{-node <nodename> | -global} [<if_name>[/<subnet>]] [-force] | -force}

oifcfg [-help]

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

<if_name> - name by which the interface is configured in the system

<subnet> - subnet address of the interface

<if_type> - 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 [<nodename>| -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 <wallet_type> [-name <name>] [-user <user_name>]

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 <name> [-dnsserver <DNS_server_address>] [-port <port>] [-attempts <attempts>] [-timeout <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 <address>] [-port <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]$

标签：oracle RAC常用维护工具命令


出处：solgle
网址：www.solgle.com
上一篇：ORA-02303:无法使用类型或表的相关性来删除或取代一个类型
下一篇：调整Oracle单实例日志文件大小

相关文章

相关评论

本类更新

本类推荐

本类排行

: 国家数据 | 中证指数 | Oracle官方文档 | 沪深行情 | 流量统计 | 深交所 | 上交所 | 中国证券登记 | 同业拆放利率 | 巨潮资讯 | 指数估值 | 看财报 |

联系我们 - 关于我们 - 网站同盟