请问RAC下如何查看另一个实例所在机器的IP? 已经登录到其中一个实例所在机器,想查看另一个实例在哪台机器上,请问该怎么看呢?谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQL> select 2 instance_name, 3 host_name, 4 archiver, 5 thread#, 6 status 7 from gv$instance;INSTANCE_NAME HOST_NAME ARCHIVE THREAD# STATUS-------------- --------------------- ------- -------- ----------------------------devdb1 rac1.mycorpdomain.com STARTED 1 OPENdevdb2 rac2.mycorpdomain.com STARTED 2 OPEN或者:# more /etc/ocfs2/cluster.confnode: ip_port = 7777 ip_address = 192.168.1.131 number = 0 name = rac1 cluster = ocfs2node: ip_port = 7777 ip_address = 192.168.1.132 number = 1 name = rac2 cluster = ocfs2cluster: node_count = 2 name = ocfs2 你也可以查看一下tnsnames.ora中的配置,类似:MYRAC = (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SVC1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = SVC2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SVC) ) ) SOS:关于Oracle存储过程中的临时表的用法 在配置快闪恢复区时遇到的一些问题 Oracle表列,行转换问题? 用sql语句把数据库中的重复数据消除,只保留一条,可以做吗? 一个数据库设计的问题 Oracle817下如何用internal用户连接到远端Oracle数据库 急啊!!为什么数据库不能更新了呢? 请帮我看看,我的函数为什么出错? 我怎样找回密码? 数据库设计求助 3表关联 max函数 oracle biee 用户访问权限问题
2 instance_name,
3 host_name,
4 archiver,
5 thread#,
6 status
7 from gv$instance;INSTANCE_NAME HOST_NAME ARCHIVE THREAD# STATUS
-------------- --------------------- ------- -------- ----------------------------
devdb1 rac1.mycorpdomain.com STARTED 1 OPEN
devdb2 rac2.mycorpdomain.com STARTED 2 OPEN或者:
# more /etc/ocfs2/cluster.conf
node:
ip_port = 7777
ip_address = 192.168.1.131
number = 0
name = rac1
cluster = ocfs2node:
ip_port = 7777
ip_address = 192.168.1.132
number = 1
name = rac2
cluster = ocfs2cluster:
node_count = 2
name = ocfs2
MYRAC =
(DESCRIPTION =
(LOAD_BALANCE = yes)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SVC1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = SVC2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SVC)
)
)