ORACLE 11G RAC 訪問SCANIP ORA-12545
ORA-12545 or ORA-12537 Reported while Connecting to RAC through SCAN name [ID 970619.1] | |||||
修改時間 20-JAN-2010 型別 PROBLEM 狀態 MODERATED |
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Symptoms
Error ORA-12545 or ORA-12537 reported while trying to connect to 11gR2 Real Application Cluster (RAC) database through SCAN name
Cause
Client is able to resolve all Fully Qualified Domain Name (FQDN) SCAN and VIP name but not short ones(without domain name) as its in different domain; even though FQDN names were specified during Grid Infrastructure setup, due to bug 9150053 by default DBCA set database parameter local_listener to short node VIP name while database is created.
In following example, eotcs.us.oracle.com is SCAN name and eyrac1fv.us.oracle.com is one of the node VIP name, on client machine:
PING eotcs.us.oracle.com (120.0.0.207) 56(84) bytes of .
64 bytes from 120.0.0.207: icmp_seq=1 ttl=64 time=0.034 ms
ping -c 1 ping eotcs
ping: unknown host eotcs
ping -c 1 eyrac1fv.us.oracle.com
PING eyrac1fv.us.oracle.com (120.0.0.211) 56(84) bytes of data.
64 bytes from 120.0.0.211: icmp_seq=1 ttl=64 time=0.034 ms
ping -c 1 ping eyrac1fv
ping: unknown host eyrac1fv
Solution
bug 9150053 will be fixed in 11.2.0.2 and above, though easy workaround is available:
1. Database level setting:
Modify pfile/spfile parameter local_listener to use FQDN VIP name or VIP.
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=eyrac1fv.us.oracle.com)(PORT=1521))))' sid='b2no1';
Or
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=120.0.0.211)(PORT=1521))))' sid='b2no1';
And register with listener:
SQL> alter system register;
2. Per client setting:
Specify FQDN SCAN name in client tnsnames.ora and add all node VIP name/IP pairs to hosts file:
120.0.0.211 eyrac1fv.us.oracle.com eyrac1fv
Or set search domain: in /etc/resolv.conf on Linux/Unix or "Append DNS suffixes" on Windows
Linux/Unix:
search us.oracle.com
Windows:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-751625/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE RAC中連線ScanIP報錯ORA-12545的問題解決Oracle
- 【Oracle】11g RAC ORA-12545 解決方案Oracle
- [重慶思莊每日技術分享]-ORACLE RAC中連線ScanIP報錯ORA-12545的問題解決Oracle
- 更改rac scanIP IP的地址
- RAC連線的問題ORA-12545
- 11g RAC ORA-12545 解決方案 +11g scan IP新特性
- ORACLE 11g RAC時鐘同步問題Oracle
- RAC連線的問題ORA-12545(二)
- 解決Oracle 11g R2 RAC 無法在客戶端通過scanIP連線資料庫Oracle客戶端資料庫
- 搭建RAC時配置scanip的DNS環境DNS
- Oracle RAC的ORA-12545 Connect failed because target host or object does not exist問題OracleAIObject
- Oracle RAC Cache Fusion 系列十三:PCM資源訪問Oracle
- 【RAC】RAC 實現IP訪問控制
- ORA-12545 RAC 解決
- Oracle 11g RAC之HAIP相關問題總結OracleAI
- 安裝Oracle RAC 11gOracle
- oracle 11G Rac service管理Oracle
- oracle 11g rac 程式理解Oracle
- redhat7 搭建oracle 11g RAC 問題與處理RedhatOracle
- Oracle 11G RAC CTSS服務Oracle
- Oracle 11g修改RAC SCAN IPOracle
- Oracle 11g Rac清理指令碼Oracle指令碼
- Oracle 11g rac add nodeOracle
- Oracle 11g RAC檔案目錄Oracle
- Oracle 11g r2 racOracle
- ORACLE 11g sqlnet.ora 設定限制IP 訪問OracleSQL
- Oracle 12C ORA-12545 While Connecting to RAC through SCAN NameOracleWhile
- Oracle 11g RAC 監聽日常管理Oracle
- Oracle 11g RAC Silent Install For NFSOracleNFS
- Oracle 11g RAC手動新增serviceOracle
- ORACLE 11g RAC EM手動配置Oracle
- oracle RAC 11G 時間同步策略Oracle
- oracle 11g rac TAF 測試方案Oracle
- oracle 11g rac 修改字符集Oracle
- oracle 11g rac install for linuxOracleLinux
- oracle 11g rac 叢集操作命令Oracle
- Oracle 11g RAC 常用命令Oracle
- Redhat Linux AS 5 + Oracle 11g RACRedhatLinuxOracle