77范文网 - 专业文章范例文档资料分享平台

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

来源:网络收集 时间:2019-02-15 下载这篇文档 手机版
说明:文章内容仅供预览,部分内容可能不全,需要完整文档或者需要复制内容,请下载word后使用。下载word有问题请添加微信号:或QQ: 处理(尽可能给您提供完整文档),感谢您的支持与谅解。点击这里给我发消息

-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 [] commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config objects: database|instance|service|nodeapps|vip|asm|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns

For detailed help on each command and object and its options use: srvctl -h or

srvctl -h [root@rac1 utl]# 查看数据库配置

[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 option has been deprecated. VIP exists.:rac1

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 option has been deprecated. VIP exists.:rac2

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 option has been deprecated. VIP exists.:rac1

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 option has been deprecated. GSD exists.

[oracle@rac1 utl]$ -s查看ONS

[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -s -n option has been deprecated.

ONS daemon exists. Local port 6100, remote port 6200 [oracle@rac1 utl]$ -l查看LISTENER

[oracle@rac1 utl]$ ./srvctl config nodeapps -n rac1 -l -n option has been deprecated. -l option has been deprecated and will be ignored. VIP exists.:rac1

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: End points: TCP:1521 [oracle@rac1 utl]$ 查看ASM

[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)在线全文阅读。

ORACLE 11G RAC--集群应用层命令扫盲(2).doc 将本文的Word文档下载到电脑,方便复制、编辑、收藏和打印 下载失败或者文档不完整,请联系客服人员解决!
本文链接:https://www.77cn.com.cn/wenku/zonghe/465893.html(转载请注明文章来源)
Copyright © 2008-2022 免费范文网 版权所有
声明 :本网站尊重并保护知识产权,根据《信息网络传播权保护条例》,如果我们转载的作品侵犯了您的权利,请在一个月内通知我们,我们会及时删除。
客服QQ: 邮箱:tiandhx2@hotmail.com
苏ICP备16052595号-18
× 注册会员免费下载(下载后可以自由复制和排版)
注册会员下载
全站内容免费自由复制
注册会员下载
全站内容免费自由复制
注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: