-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
For detailed help on each command and object and its options use: srvctl
srvctl
[root@rac1 utl]# ./srvctl config database racdb
[root@rac1 utl]#
-d选项查看某个数据库配置
[oracle@rac1 ~]$ cd /u01/app/11.2.0/11ggrid/crs/utl [oracle@rac1 utl]$ ./srvctl config database -d racdb Database unique name: racdb Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracle
Spfile: +RACDB_DATA/racdb/spfileracdb.ora Domain: **e.com Start options: open
Stop options: immediate Database role: PRIMARY
Management policy: AUTOMATIC Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: RACDB_DATA,FRA Services:
Database is administrator managed [oracle@rac1 utl]$
查看NODEAPPLICATION配置
[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -n
VIP exists.: /rac1vip/192.168.44.201/255.255.255.0/eth0 GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 22440, multicast IP address 234.109.49.0, listening port 2016 [oracle@rac1 utl]$ ./srvctl config nodeapps -n rac2 -n
VIP exists.: /rac2vip/192.168.44.202/255.255.255.0/eth0 GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 22440, multicast IP address 234.109.49.0, listening port 2016 [oracle@rac1 utl]$ -a查看VIP配置
[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -a -n
VIP exists.: /rac1vip/192.168.44.201/255.255.255.0/eth0 [oracle@rac1 utl]$ -g查看GSD配置
[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -g -n
[oracle@rac1 utl]$ -s查看ONS
[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -s -n
ONS daemon exists. Local port 6100, remote port 6200 [oracle@rac1 utl]$ -l查看LISTENER
[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -l -n
VIP exists.: /rac1vip/192.168.44.201/255.255.255.0/eth0 GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 22440, multicast IP address 234.109.49.0, listening port 2016 -n option has been deprecated and will be ignored. Name: LISTENER
Network: 1, Owner: grid Home:
[oracle@rac1 utl]$ ./srvctl config asm -n rac1 -n option has been deprecated and will be ignored. ASM home: /u01/app/11.2.0/11ggrid ASM listener: LISTENER
[oracle@rac1 utl]$ ./srvctl config asm -n rac2 -n option has been deprecated and will be ignored. ASM home: /u01/app/11.2.0/11ggrid ASM listener: LISTENER [oracle@rac1 utl]$
select username,terminal,program,inst_id from gv$session where username='WJG';
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说综合文库ORACLE 11G RAC--集群应用层命令扫盲(2)在线全文阅读。
相关推荐: