ORACLE 11G RAC--集群应用层命令扫盲

应用层就是RAC数据库，工具有SRVCTL,ONSCTL,CRS_STAT. 1.CRS_STAT:用来查看CRS维护的所有资源的运行状态。 [oracle@rac1 bin]$ ./crs_stat NAME=ora.CRS.dg

TYPE=ora.diskgroup.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.FRA.dg

TYPE=ora.diskgroup.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.LISTENER.lsnr TYPE=ora.listener.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.LISTENER_SCAN1.lsnr TYPE=ora.scan_listener.type TARGET=ONLINE

STATE=ONLINE on rac2

NAME=ora.RACDB_DATA.dg TYPE=ora.diskgroup.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.asm TYPE=ora.asm.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.eons TYPE=ora.eons.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.gsd TYPE=ora.gsd.type TARGET=OFFLINE STATE=OFFLINE

NAME=ora.net1.network

TYPE=ora.network.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.oc4j TYPE=ora.oc4j.type TARGET=OFFLINE STATE=OFFLINE

NAME=ora.ons TYPE=ora.ons.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.rac1.ASM1.asm TYPE=application TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.rac1.LISTENER_RAC1.lsnr TYPE=application TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.rac1.gsd TYPE=application TARGET=OFFLINE STATE=OFFLINE

NAME=ora.rac1.ons TYPE=application TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.rac1.vip

TYPE=ora.cluster_vip_net1.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.rac2.ASM2.asm TYPE=application TARGET=ONLINE

STATE=ONLINE on rac2

NAME=ora.rac2.LISTENER_RAC2.lsnr TYPE=application TARGET=ONLINE

STATE=ONLINE on rac2

NAME=ora.rac2.gsd TYPE=application TARGET=OFFLINE STATE=OFFLINE

NAME=ora.rac2.ons TYPE=application TARGET=ONLINE

STATE=ONLINE on rac2

NAME=ora.rac2.vip

TYPE=ora.cluster_vip_net1.type TARGET=ONLINE

STATE=ONLINE on rac2

NAME=ora.racdb.db TYPE=ora.database.type TARGET=ONLINE

STATE=ONLINE on rac1

NAME=ora.scan1.vip TYPE=ora.scan_vip.type TARGET=ONLINE

STATE=ONLINE on rac2

[oracle@rac1 bin]$ 查看指定资源的状态

[oracle@rac1 bin]$ ./crs_stat ora.racdb.db NAME=ora.racdb.db TYPE=ora.database.type TARGET=ONLINE

STATE=ONLINE on rac1

[oracle@rac1 bin]$ 查看详细信息

[oracle@rac1 bin]$ ./crs_stat -v ora.racdb.db NAME=ora.racdb.db TYPE=ora.database.type RESTART_ATTEMPTS=2

RESTART_COUNT=0

GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=racdb1 GEN_USR_ORA_INST_NAME@SERVERNAME(rac2)=racdb2 USR_ORA_INST_NAME@SERVERNAME(rac1)=racdb1 USR_ORA_INST_NAME@SERVERNAME(rac2)=racdb2 FAILURE_THRESHOLD=1 FAILURE_COUNT=0 TARGET=ONLINE

STATE=ONLINE on rac1

[oracle@rac1 bin]$ 查看更详细的信息

[oracle@rac1 bin]$ ./crs_stat -p ora.racdb.db NAME=ora.racdb.db TYPE=ora.database.type ACTION_SCRIPT=

ACTIVE_PLACEMENT=1 AUTO_START=restore CHECK_INTERVAL=1

DESCRIPTION=Oracle Database resource FAILOVER_DELAY=0 FAILURE_INTERVAL=60 FAILURE_THRESHOLD=1

GEN_USR_ORA_INST_NAME@SERVERNAME(rac1)=racdb1 GEN_USR_ORA_INST_NAME@SERVERNAME(rac2)=racdb2 HOSTING_MEMBERS= PLACEMENT=restricted RESTART_ATTEMPTS=2 SCRIPT_TIMEOUT=60 START_TIMEOUT=600 STOP_TIMEOUT=600

UPTIME_THRESHOLD=1h

USR_ORA_INST_NAME@SERVERNAME(rac1)=racdb1 USR_ORA_INST_NAME@SERVERNAME(rac2)=racdb2

[oracle@rac1 bin]$

查看每个资源的权限定义crs_stat -ls

2.onsctl,用来管理配置ONS[ORACLE NOTIFICATION SERVICE] 查看ONS配置内容

[root@rac1 ~]# cat /u01/app/11.2.0/11ggrid/opmn/conf/ons.config localport=6100 # line added by Agent allowgroup=true usesharedinstall=true

remoteport=6200 # line added by Agent

nodes=rac1:6200,rac2:6200 # line added by Agent [root@rac1 ~]#

localport代表本地监听端口，本地指127.0.0.1，用来和运行在本地的客户端通信。 remoteport代表远程监听端口，用来和远程的客户端进行通信。 查看两个端口的使用方式：

[root@rac1 ~]# netstat -ano|grep 6100

tcp 0 0 127.0.0.1:6100 0.0.0.0:* LISTEN off (0.00/0/0)

tcp 0 0 127.0.0.1:56632 127.0.0.1:6100 ESTABLISHED keepalive (4919.37/0/0)

tcp 0 0 127.0.0.1:56630 127.0.0.1:6100 ESTABLISHED keepalive (4918.31/0/0)

tcp 0 0 127.0.0.1:6100 127.0.0.1:56630 ESTABLISHED off (0.00/0/0) tcp 0 0 127.0.0.1:6100 127.0.0.1:56632 ESTABLISHED off (0.00/0/0) tcp 0 0 127.0.0.1:6100 127.0.0.1:47402 TIME_WAIT timewait (8.25/0/0)

[root@rac1 ~]# netstat -ano|grep 6200

tcp 0 0 0.0.0.0:6200 0.0.0.0:* LISTEN off (0.00/0/0)

tcp 0 0 192.168.44.101:43749 192.168.44.102:6200 ESTABLISHED off (0.00/0/0)

[root@rac1 ~]#

ONSCTL START|STOP|DEBUG|RECONFIG|DETAILED可用来启，停，调式，重新载入配置文件

查看ONS进程运行情况

[root@rac1 ~]# ps -aef|grep ons

grid 3617 3571 0 Aug07 ? 00:05:12 /usr/NX/bin/nxagent -D -options /home/grid/.nx/C-rac1-1007-BD81B97F009D9E23984F52209ED67ED9/options -name NX - grid@rac1:1007 - racB :1007 oracle 7390 1 0 Aug08 ? 00:02:36 /u01/app/oracle/product/11.2.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/11.2.0/dbhome_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman/log/emdb.nohup

grid 23072 1 0 Aug15 ? 00:00:00 /u01/app/11.2.0/11ggrid/opmn/bin/ons -d grid 23073 23072 0 Aug15 ? 00:00:00 /u01/app/11.2.0/11ggrid/opmn/bin/ons -d

grid 23151 1 0 Aug15 ? 00:00:55 /u01/app/11.2.0/11ggrid/jdk/jre//bin/java -Doracle.supercluster.cluster.server=eonsd -Djava.net.preferIPv4Stack=true -Djava.util.logging.config.file=/u01/app/11.2.0/11ggrid/srvm/admin/logging.properties -classpath /u01/app/11.2.0/11ggrid/jdk/jre//lib/rt.jar:/u01/app/11.2.0/11ggrid/jlib/srvm.jar:/u01/app/11.2.0/11ggrid/jlib/srvmhas.jar:/u01/app/11.2.0/11ggrid/jlib/supercluster.jar:/u01/app/11.2.0/11ggrid/jlib/supercluster-common.jar:/u01/app/11.2.0/11ggrid/ons/lib/ons.jar oracle.supercluster.impl.cluster.EONSServerImpl oracle 23699 7390 0 Aug15 ? 00:01:36 /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -server -Xmx192M -XX:MaxPermSize=200M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库ORACLE 11G RAC--集群应用层命令扫盲在线全文阅读。