2
rac 常用语句.txt
5墨值下载
#查看状态
[root@rac1 bin]# ./srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
eONS is enabled
eONS daemon is running on node: rac1
eONS daemon is running on node: rac2
[root@rac1 bin]# ./srvctl status asm
ASM is running on rac1,rac2
[root@rac1 bin]# ./srvctl status instance -d racdb -n rac1
Instance racdb1 is running on node rac1
[root@rac1 bin]# ./srvctl status instance -d racdb -n rac2
Instance racdb2 is running on node rac2
#登陆数据库（是建立数据库时 racdb ）
sqlplus sys/tiyukeji@racdb as sysdba
show parameter service_names
#客户端 tnsnames.ora 的配置
* ip 配置如下
* #public
* 192.168.177.128 rac1
* 192.168.177.127 rac2
* #private
* 192.168.213.129 rac1-priv
* 192.168.213.128 rac2-priv
* #virtual
* 192.168.177.126 rac1-vip
* 192.168.177.125 rac2-vip
* #scan
* 192.168.177.122 rac-scan
racdbthw =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.177.126)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.177.125)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = on)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
of 45
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论