rac 用scan连接默认的service 是两边都跑

[oracle@yyjk sbin]$ cat testrac.pl 
use DBI;
$dbh2 = DBI->connect( "dbi:Oracle://10.2.120.185:1521/uacdb", uac, xx );
my $sql='select instance_name from v$instance';
my $sth1 = $dbh2->prepare($sql); 
$sth1->execute();
my @res;
$num=$sth1->fetchrow_array();
print $num."\n";

[oracle@uacdb2 ~]$ cat /etc/hosts |grep -i uac
10.2.120.181  uacdb1
10.2.120.182  uacdb2
93.93.15.1    uacdb1-priv
93.93.15.2    uacdb2-priv
10.2.120.183  uacdb1-vip
10.2.120.184  uacdb2-vip
10.2.120.185  uacdb-scan



[oracle@uacdb1 ~]$ /sbin/ifconfig -a|grep 'inet addr'
          inet addr:10.2.120.181  Bcast:10.2.120.255  Mask:255.255.255.0
          inet addr:10.2.120.183  Bcast:10.2.120.255  Mask:255.255.255.0
          inet addr:93.93.15.1  Bcast:93.93.15.255  Mask:255.255.255.0
          inet addr:169.254.219.193  Bcast:169.254.255.255  Mask:255.255.0.0
          inet addr:127.0.0.1  Mask:255.0.0.0
		  
		  
[oracle@uacdb2 ~]$ /sbin/ifconfig -a|grep 'inet addr'
          inet addr:10.2.120.182  Bcast:10.2.120.255  Mask:255.255.255.0
          inet addr:10.2.120.184  Bcast:10.2.120.255  Mask:255.255.255.0
          inet addr:10.2.120.185  Bcast:10.2.120.255  Mask:255.255.255.0
          inet addr:93.93.15.2  Bcast:93.93.15.255  Mask:255.255.255.0
          inet addr:169.254.117.217  Bcast:169.254.255.255  Mask:255.255.0.0
          inet addr:127.0.0.1  Mask:255.0.0.0
		  
		  
[grid@uacdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.FRA.dg
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.LISTENER.lsnr
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.OCRVT.dg
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.asm
               ONLINE  ONLINE       uacdb1                   Started             
               ONLINE  ONLINE       uacdb2                   Started             
ora.gsd
               OFFLINE OFFLINE      uacdb1                                       
               OFFLINE OFFLINE      uacdb2                                       
ora.net1.network
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.ons
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
ora.registry.acfs
               ONLINE  ONLINE       uacdb1                                       
               ONLINE  ONLINE       uacdb2                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       uacdb2                                       
ora.cvu
      1        ONLINE  ONLINE       uacdb2                                       
ora.oc4j
      1        ONLINE  ONLINE       uacdb2                                       
ora.scan1.vip
      1        ONLINE  ONLINE       uacdb2                                       
ora.uacdb.db
      1        ONLINE  ONLINE       uacdb1                   Open                
      2        ONLINE  ONLINE       uacdb2                   Open                
ora.uacdb.uacrac1.svc
      1        ONLINE  ONLINE       uacdb2                                       
ora.uacdb.uacrac2.svc
      1        ONLINE  ONLINE       uacdb2                                       
ora.uacdb1.vip
      1        ONLINE  ONLINE       uacdb1                                       
ora.uacdb2.vip
      1        ONLINE  ONLINE       uacdb2 
	  
	  
	  
[oracle@uacdb1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2019 10:27:48

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                08-JAN-2019 21:29:09
Uptime                    14 days 12 hr. 58 min. 39 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/grid/network/admin/listener.ora
Listener Log File         /oracle/grid/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.120.181)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.120.183)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "uacdb" has 1 instance(s).
  Instance "uacdb1", status READY, has 1 handler(s) for this service...
The command completed successfully


[oracle@uacdb2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-JAN-2019 10:28:14

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                20-NOV-2017 00:06:16
Uptime                    429 days 10 hr. 21 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/grid/network/admin/listener.ora
Listener Log File         /oracle/grid/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.120.182)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.120.184)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "uacdb" has 1 instance(s).
  Instance "uacdb2", status READY, has 1 handler(s) for this service...
Service "uacrac1" has 1 instance(s).
  Instance "uacdb2", status READY, has 1 handler(s) for this service...
Service "uacrac2" has 1 instance(s).
  Instance "uacdb2", status READY, has 1 handler(s) for this service...
The command completed successfully


[oracle@yyjk sbin]$ perl testrac.pl 
uacdb1
You have mail in /var/spool/mail/oracle
[oracle@yyjk sbin]$ 
[oracle@yyjk sbin]$ perl testrac.pl 
uacdb1
[oracle@yyjk sbin]$ perl testrac.pl 
uacdb2
[oracle@yyjk sbin]$ perl testrac.pl 
uacdb2
[oracle@yyjk sbin]$ perl testrac.pl 
uacdb1

 

1、资源项目源码均已通过严格测试验证,保证能够正常运行; 2、项目问题、技术讨论,可以给博主私信或留言,博主看到后会第一时间与您进行沟通; 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用,尤其对于人工智能、计算机科学与技术等相关专业,更为适合; 4、下载使用后,可先查看README.md或论文文件(如有),本项目仅用作交流学习参考,请切勿用于商业用途。 5、资源来自互联网采集,如有侵权,私聊博主删除。、可私 6信博主看论文后选择购买源代码。 1、资源项目源码均已通过严格测试验证,保证能够正常运行; 2、项目问题、技术讨论,可以给博主私信或留言,博主看到后会第一时间与您进行沟通; 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用,尤其对于人工智能、计算机科学与技术等相关专业,更为适合; 4、下载使用后,可先查看README.md或论文文件(如有),本项目仅用作交流学习参考,请切勿用于商业用途。 5、资源来自互联网采集,如有侵权,私聊博主删除。 、可私信6博主看论文后选择购买源代码。 1、资源项目源码均已通过严格测试验证,保证能够正常运行; 2、项目问题、技术讨论,可以给博主私信或留言,博主看到后会第一时间与您进行沟通; 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用,尤其对于人工智能、计算机科学与技术等相关专业,更为适合; 4、下载使用后,可先查看README.md或论文文件(如有),本项目仅用作交流学习参考,请切勿用于商业用途。 5、资源来自互联网采集,如有侵权,私聊博主删除。 、可私信6博主看论文后选择购买源代码。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

scan724

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值