最近在苹果的App Stroe上发现Toad放出了免费版本，立刻下载安装。

https://itunes.apple.com/cn/app/toad/id747961939?mt=12

本人的虚拟机为VirtualBox, 虚拟机中的操作系统为OracleLinux5.7，数据库环境为Oracle11g 11.2.0.3 双节点RAC。

[root@node1 ~]# cat /etc/issue
Oracle Linux Server release 5.7

[root@node1 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
192.168.1.181   node1   node1.oracle.com
192.168.1.161   node1-vip

192.168.1.182   node2   node2.oracle.com
192.168.1.162   node2-vip

192.168.1.176   node-cluster node-cluster-scan

172.168.1.191   node1-priv
172.168.1.192   node2-priv

连接前确定集群环境已经启动，监听已经启动
[root@node1 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
ora.DATA.dg
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
ora.LISTENER.lsnr
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
ora.ORCVOTE.dg
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
ora.asm
               ONLINE ONLINE       node1                    Started
               ONLINE ONLINE       node2                    Started
ora.gsd
               OFFLINE OFFLINE      node1
               OFFLINE OFFLINE      node2
ora.net1.network
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
ora.ons
               ONLINE ONLINE       node1
               ONLINE ONLINE       node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE ONLINE       node2
ora.cvu
      1        ONLINE ONLINE       node1
ora.node1.vip
      1        ONLINE ONLINE       node1
ora.node2.vip
      1        ONLINE ONLINE       node2
ora.oc4j
      1        ONLINE ONLINE       node1
ora.prod.db
      1        ONLINE ONLINE       node1                    Open
      2        ONLINE ONLINE       node2                    Open
ora.scan1.vip
      1        ONLINE ONLINE       node2

客户端连接设置
Host：192.168.1.181 <<< 节点node1的IP地址
Port：默认1521
SID：PROD1 <<< 节点node1的SID
User/Schema：sys
Password：oracle <<< 本机的sys密码为oracle
Connect as：sysdba <<< 截图中是Normal可以忽略
Connection Name: 根据前面的信息自动生成可以不填

连接成功后进入Toad主页
输入测试SQL语句 select instance_name,status from gv$instance; 可以正确显示查询结果。此次配置成功！

ITPub博客

RAC 11.2.0.3 客户端软件Toad连接配置 -- Mac版本

最新文章