客戶端連線RAC報ora-12545
Applies to:
Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.
***Checked for relevance on 29-APR-2013***
Symptoms
When attempting to connect to a RAC service name, the connection intermittently fails with an ORA-12545 error: TNS: Host or object doesn't exist. The expected behavior. is that the connection would be redirected to any of the listener in the cluster where the listener is running on the VIP. This is normal under RAC Cluster node load balancing.
However, when the server side listener endpoints are not correctly configured OR the client cannot resolve all forms of the VIP hostname, this error can get thrown.
Changes
This is likely a new installation of RAC cluster.
Cause
Whe LOCAL_LISTENER is not set at all or is not set correctly, PMON can register both the VIP hostname and the physical hostname with the REMOTE_LISTENER. This is incorrect in RAC but if it does occur, the client can intermittently be routed to a listener endpoint on either of these addresses. If the client is unable to resolve the physical hostname or even the vip hostname, the connection will fail with ORA-12545.
And important first set is to check the output for : lsnrctl services
You should not see the physical hostname in the handler information for your RAC instances. Here's an example of an incorrect lsnrctl services
Service "oracle.oracle.com" has 2 instance(s).
Instance "orcl1", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=myphysicalhost1)(PORT=1521))
"DEDICATED" established:326 refused:0 state:ready
LOCAL SERVER
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:394371 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=myphysicalhost2)(PORT=1521))
Here's an example of what it ought to look like when LOCAL_LISTENER is configured correctly:
lsnrctl services oracle_rac_listener
Service "oracle.oracle.com" has 2 instance(s).
Instance "orcl1", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=myVIP_host1)(PORT=1521))
"DEDICATED" established:326 refused:0 state:ready
LOCAL SERVER
Instance "orcl2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:394371 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=myVIP_host2)(PORT=1521))
Solution
Log in with privileges to the instance and issue the following commands so that LOCAL_LISTENER is set correctly:
alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=
Do the same for the 2nd instance where host is set to the
alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=
Now the correct address using the VIP hostname will be registered against the listeners in the cluster.
The client should be able to resolve all forms of the VIP host via their /etc/hosts file. i.e. short name and fully qualified.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-762330/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 解決:客戶端連線11gR2 RAC報ORA-12545錯誤客戶端
- 客戶端使用SCNAIP連線11G RAC資料庫報錯ORA-12545解決客戶端AI資料庫
- oracle 客戶端連線11gR2 SCAN 報ORA-12545錯誤Oracle客戶端
- 客戶端通過SCAN TNS無法連線ORA-12545客戶端
- impala客戶端連線客戶端
- Redis客戶端連線Redis客戶端
- 連線rac資料庫報ORA-12545資料庫
- mysql、redis 客戶端連線池MySqlRedis客戶端
- vncserver建立與客戶端連線VNCServer客戶端
- RAC 11.2.0.3 客戶端軟體Toad連線配置 -- Mac版本客戶端Mac
- 如何配置oracle客戶端連線10g rac 資料庫Oracle客戶端資料庫
- Redis客戶端連線數DevOpsRedis客戶端dev
- 從客戶端連線ASM例項客戶端ASM
- 客戶端通過SCAN連線11g Oracle RAC報錯ORA-12537客戶端Oracle
- oracle 10g rac 客戶端連線偶爾報ORA-12535錯誤Oracle 10g客戶端
- Java 客戶端 Jedis和JedisPool 連線池Java客戶端
- Oracle客戶端連線伺服器教程Oracle客戶端伺服器
- 客戶端連線資料庫的方法客戶端資料庫
- 客戶端連線故障檢查流程手段客戶端
- RAC連線的問題ORA-12545
- Oracle 19c中連線RMAN客戶端的連線方法Oracle客戶端
- 使用 WebSocket 客戶端連線 MQTT 伺服器Web客戶端MQQT伺服器
- 客戶端怎麼連線到伺服器?客戶端伺服器
- 配置ORACLE 客戶端連線到資料庫Oracle客戶端資料庫
- MySQL client客戶端的四種連線方式MySqlclient客戶端
- linux之客戶端連線數統計Linux客戶端
- RAC連線的問題ORA-12545(二)
- 客戶端連線資料時會報“ORA-12537:TNS連線已關閉”客戶端
- PL/SQL developer 遠端連線資料庫 客戶端配置SQLDeveloper資料庫客戶端
- ORACLE RAC中連線ScanIP報錯ORA-12545的問題解決Oracle
- HTTP客戶端連線,選擇HttpClient還是OkHttp?HTTP客戶端client
- ESP作為單連線中的TCP客戶端TCP客戶端
- 配置TimesTen客戶端連線[TimesTen運維]客戶端運維
- 8i客戶端不能連線9i?客戶端
- 9i rac 連線時提示ORA-12545!
- php連結nsq客戶端PHP客戶端
- 客戶端段建立到伺服器端的連線過程客戶端伺服器
- oracle客戶端連線server 端, tnsnames的三種設定方式Oracle客戶端Server