最近在蘋果的App Stroe上發現Toad放出了免費版本，立刻下載安裝。

本人的虛擬機器為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; 可以正確顯示查詢結果。此次配置成功！

RAC 11.2.0.3 客戶端軟體Toad連線配置 -- Mac版本

相關文章