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 -DORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 -Doracle.home=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/server.xml
root 26167 25635 0 22:08 pts/3 00:00:00 grep ons
oracle 29445 29401 0 Aug07 ? 00:16:42 /usr/NX/bin/nxagent -D -options /home/oracle/.nx/C-rac1-1008-2895CA7248F6302E5580BA7452F0165B/options -name NX - oracle@rac1:1008 - racB :1008
檢視ONS服務狀態
[root@rac1 bin]# ./onsctl ping
ons is running ...
[root@rac1 bin]#
檢視DEBUG資訊
[root@rac1 bin]# ./onsctl debug
HTTP/1.1 200 OK
Content-Length: 2425
Content-Type: text/html
Response:
== rac1:6200 23073 12/08/16 22:11:39 ==
Home: /u01/app/11.2.0/11ggrid
======== NS ========
IP ADDRESS PORT TIME SEQUENCE FLAGS
--------------------------------------- ----- -------- -------- --------
192.168.44.101 6200 502bbf1f 00000002 00000008
Listener:
TYPE BIND ADDRESS PORT SOCKET
-------- --------------------------------------- ----- ------
Local 127.0.0.1 6100 5
Remote any 6200 7
Servers: (1)
INSTANCE NAME TIME SEQUENCE FLAGS DEFER
---------------------------------------- -------- -------- -------- ----------
dbInstance_rac2_6200 5021073b 0000000c 00000002 0
192.168.44.102 6200
Connection Topology: (2)
IP PORT VERS TIME
--------------------------------------- ----- ----- --------
192.168.44.102 6200 4 502bbf1f
** 192.168.44.101 6200
192.168.44.101 6200 4 502bbf1f=
** 192.168.44.102 6200
Server connections:
ID CONNECTION ADDRESS PORT FLAGS SENDQ REF SUB WSA
-------- --------------------------------------- ----- ------ ----- --- --- ---
0 192.168.44.102 6200 010405 00000 001 000
Client connections:
ID CONNECTION ADDRESS PORT FLAGS SENDQ REF SUB WSA
-------- --------------------------------------- ----- ------ ----- --- --- ---
1 internal 0 01008a 00000 001 001
4 127.0.0.1 6100 01001a 00000 001 001
5 127.0.0.1 6100 01001a 00000 001 000
request 127.0.0.1 6100 03201a 00000 001 000
Worker Ticket: 4112/4112, Last: 12/08/16 22:11:35
THREAD FLAGS
-------- --------
b5f73b90 00000012
b5f6bb90 00000012
b5f63b90 00000012
Resources:
Notifications:
Received: Total 5 (Internal 2), in Receive Q: 0
Processed: Total 5, in Process Q: 0
Pools:
Message: 49/50 (1), Link: 100/100 (1), Ack: 100/100 (1)
[root@rac1 bin]#
3.SRVCTL,這個命令功能比較強，可以操作DATABASE,INSTANCE,ASM,SERVICE,LISTENER,NODE APPLICATION.NODE APPLICATION又包含GSD,ONS,VIP.可以用SRVCTL統一管理這些資源。
用法說明：
[root@rac1 utl]# ./srvctl -help
Usage: srvctl
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 -DORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 -Doracle.home=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb/config/server.xml
root 26167 25635 0 22:08 pts/3 00:00:00 grep ons
oracle 29445 29401 0 Aug07 ? 00:16:42 /usr/NX/bin/nxagent -D -options /home/oracle/.nx/C-rac1-1008-2895CA7248F6302E5580BA7452F0165B/options -name NX - oracle@rac1:1008 - racB :1008
檢視ONS服務狀態
[root@rac1 bin]# ./onsctl ping
ons is running ...
[root@rac1 bin]#
檢視DEBUG資訊
[root@rac1 bin]# ./onsctl debug
HTTP/1.1 200 OK
Content-Length: 2425
Content-Type: text/html
Response:
== rac1:6200 23073 12/08/16 22:11:39 ==
Home: /u01/app/11.2.0/11ggrid
======== NS ========
IP ADDRESS PORT TIME SEQUENCE FLAGS
--------------------------------------- ----- -------- -------- --------
192.168.44.101 6200 502bbf1f 00000002 00000008
Listener:
TYPE BIND ADDRESS PORT SOCKET
-------- --------------------------------------- ----- ------
Local 127.0.0.1 6100 5
Remote any 6200 7
Servers: (1)
INSTANCE NAME TIME SEQUENCE FLAGS DEFER
---------------------------------------- -------- -------- -------- ----------
dbInstance_rac2_6200 5021073b 0000000c 00000002 0
192.168.44.102 6200
Connection Topology: (2)
IP PORT VERS TIME
--------------------------------------- ----- ----- --------
192.168.44.102 6200 4 502bbf1f
** 192.168.44.101 6200
192.168.44.101 6200 4 502bbf1f=
** 192.168.44.102 6200
Server connections:
ID CONNECTION ADDRESS PORT FLAGS SENDQ REF SUB WSA
-------- --------------------------------------- ----- ------ ----- --- --- ---
0 192.168.44.102 6200 010405 00000 001 000
Client connections:
ID CONNECTION ADDRESS PORT FLAGS SENDQ REF SUB WSA
-------- --------------------------------------- ----- ------ ----- --- --- ---
1 internal 0 01008a 00000 001 001
4 127.0.0.1 6100 01001a 00000 001 001
5 127.0.0.1 6100 01001a 00000 001 000
request 127.0.0.1 6100 03201a 00000 001 000
Worker Ticket: 4112/4112, Last: 12/08/16 22:11:35
THREAD FLAGS
-------- --------
b5f73b90 00000012
b5f6bb90 00000012
b5f63b90 00000012
Resources:
Notifications:
Received: Total 5 (Internal 2), in Receive Q: 0
Processed: Total 5, in Process Q: 0
Pools:
Message: 49/50 (1), Link: 100/100 (1), Ack: 100/100 (1)
[root@rac1 bin]#
3.SRVCTL,這個命令功能比較強，可以操作DATABASE,INSTANCE,ASM,SERVICE,LISTENER,NODE APPLICATION.NODE APPLICATION又包含GSD,ONS,VIP.可以用SRVCTL統一管理這些資源。
用法說明：
[root@rac1 utl]# ./srvctl -help
Usage: srvctl
相關文章
- ORACLE 11G RAC--維護叢集的OCR命令介紹Oracle
- oracle 11g rac 叢集操作命令Oracle
- ORACLE 11G RAC--日誌路徑Oracle
- oracle mutex概念掃盲之一OracleMutex
- 「掃盲」 ElasticsearchElasticsearch
- Promise掃盲Promise
- HTML掃盲HTML
- ORACLE 11g RAC 叢集互連延遲Oracle
- oracle RAC 診斷叢集狀態命令Oracle
- 沃趣微講堂 | Oracle叢集技術（四）：叢集初始化資源層Oracle
- Oracle 11g RAC 叢集 SCAN IP Listener說明Oracle
- Oracle10g RAC叢集基本命令Oracle
- RocketMQ掃盲篇MQ
- PostgreSQL掃盲教程SQL
- ECMAScript 6 掃盲
- ELK 在 Spark 叢集的應用Spark
- Quartz叢集原理及配置應用quartz
- 叢集的應用例項(zt)
- Hadoop 叢集命令Hadoop
- Oracle10g RAC叢集基本命令（轉）Oracle
- ORACLE 11G 建立 DATAGUARD(雙節點RAC-->單例項DG)Oracle單例
- Zookeeper應用場景之【叢集管理】
- 【掃盲篇】衛生資訊資料集欄位解釋
- Dozer掃盲級教程
- Spring AOP 掃盲Spring
- JVM快速掃盲篇JVM
- Css知識掃盲CSS
- (原)SQL掃盲貼SQL
- ORACLE 命令的應用Oracle
- 應用級叢集系統的設計
- SAP掃盲系列之二：SAP ABAP應用伺服器的組成部分伺服器
- Java Web 掃盲行動JavaWeb
- Filecoin: 挖礦流程掃盲
- 數字證書掃盲
- Oracle叢集件元件Oracle元件
- oracle叢集patchingOracle
- rac叢集日常維護命令
- hbase叢集 常用維護命令