連線scan ip出現ORA-12545錯誤
GRID和資料庫版本:11.2.0.1
OS: Solaris 5.10
現象: 在客戶端連線scan ip時報錯
sqlplus system/oracle@210.10.4.5:1521/pdpt
ORA-12545: 因目標主機或物件不存在,連線失敗
但兩臺資料庫伺服器之間連scan ip則沒問題
# cat /etc/hosts
::1 localhost
127.0.0.1 localhost
210.10.4.5 taian-pt-d1 loghost
210.10.4.6 taian-pt-d2
210.10.4.9 taian-pt-d1-vip
210.10.4.10 taian-pt-d2-vip
210.10.4.7 pdpt-cluster-scan
192.168.2.1 taian-pt-d1-priv
192.168.2.2 taian-pt-d2-priv
經檢查scan ip監聽正常,客戶端能ping通scan ip
-bash-3.2$ crs_stat -t rac資源服務正常
Name Type Target State Host
------------------------------------------------------------
ora.ARCHDG.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora.DATADG.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora....ER.lsnr ora....er.type ONLINE ONLINE taian-pt-d1
ora....N1.lsnr ora....er.type ONLINE ONLINE taian-pt-d2
ora.OCRVT.dg ora....up.type ONLINE ONLINE taian-pt-d1
ora.asm ora.asm.type ONLINE ONLINE taian-pt-d1
ora.eons ora.eons.type ONLINE ONLINE taian-pt-d1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE taian-pt-d1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE taian-pt-d1
ora.pdpt.db ora....se.type ONLINE ONLINE taian-pt-d1
ora.scan1.vip ora....ip.type ONLINE ONLINE taian-pt-d2
ora....SM1.asm application ONLINE ONLINE taian-pt-d1
ora....D1.lsnr application ONLINE ONLINE taian-pt-d1
ora....-d1.gsd application OFFLINE OFFLINE
ora....-d1.ons application ONLINE ONLINE taian-pt-d1
ora....-d1.vip ora....t1.type ONLINE ONLINE taian-pt-d1
ora....SM2.asm application ONLINE ONLINE taian-pt-d2
ora....D2.lsnr application ONLINE ONLINE taian-pt-d2
ora....-d2.gsd application OFFLINE OFFLINE
ora....-d2.ons application ONLINE ONLINE taian-pt-d2
ora....-d2.vip ora....t1.type ONLINE ONLINE taian-pt-d2
-bash-3.2$ lsnrctl status LISTENER_SCAN1 scan IP監聽正常
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 06-MAR-2012 09:36:50
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 29-FEB-2012 13:42:48
Uptime 5 days 19 hr. 54 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/app/grid_home/network/admin/listener.ora
Listener Log File /home/app/grid_home/log/diag/tnslsnr/taian-pt-d2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=210.10.4.7)(PORT=1521)))
Services Summary...
Service "PDPT" has 2 instance(s).
Instance "PDPT1", status READY, has 1 handler(s) for this service...
Instance "PDPT2", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL> show parameter listener 資料庫例項的local_listener引數內容為vip的主機名
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=taia
n-pt-d2-vip)(PORT=1521))))
remote_listener string pdpt-cluster-scan:1521
經Metalink上查詢,發現這是11.2.0.1的小bug:“ORA-12545 or ORA-12537 while connecting to RAC through SCAN name[ID 970619.1]”,11.2.0.2及之後的版本就修復好了
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.
因此只要把資料庫例項引數local_listener內的host改為vip的IP地址即可。
NODE1:
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=210.10.4.9)(PORT=1521))))' scope=both sid='PDPT1';
System altered.
SQL> alter system register;
System altered.
NODE2:
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=210.10.4.10)(PORT=1521))))' scope=both sid='PDPT2';
System altered.
SQL> alter system register;
System altered.
參考: How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name [ID 975457.1]
ORA-12545 or ORA-12537 while connecting to RAC through SCAN name[ID 970619.1]
11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24966341/viewspace-753010/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- scan-ip連線出現“ORA-12545”
- ORACLE DG為RAC時使用scan-ip連線資料庫會報 ORA-12545錯誤Oracle資料庫
- oracle 客戶端連線11gR2 SCAN 報ORA-12545錯誤Oracle客戶端
- 網路連線出現意外錯誤
- oracle11g RAC scan ip連線時出現ORA-12545: 因目標主機或物件不存在Oracle物件
- 連線MySQL出現2013錯誤解決MySql
- 客戶端通過SCAN TNS無法連線ORA-12545客戶端
- phpmyadmin配製連線mysql時出現錯誤(轉)PHPMySql
- Oracle11gR2 RAC 使用scan IP無法連線資料庫(ORA-12545)問題解決Oracle資料庫
- Spring websocket瀏覽器連線時出現404錯誤SpringWeb瀏覽器
- windows下ftp出現軟體造成連線終止錯誤WindowsFTP
- win10ip地址配置錯誤網路無法連線怎麼辦 ip地址配置錯誤網路無法連線的方法Win10
- JDBC 連oracle 時出現錯誤,,求助???JDBCOracle
- Mac SSH 連線出現 Host key verification failed. 錯誤解決MacAI
- zedboard 使用OTG連線USB串列埠時出現錯誤問題ZedOTG串列埠
- 解決:客戶端連線11gR2 RAC報ORA-12545錯誤客戶端
- 寬頻連線錯誤678 寬頻連線錯誤691錯誤的解決辦法
- perl連線Oracle錯誤Oracle
- 連線ASM例項後出現ORA-1012錯誤ASM
- 連線資料庫時出現ORA-12514錯誤資料庫
- Oracle 11g RAC通過SCAN IP連線資料庫 - JDBC連線串問題Oracle資料庫JDBC
- SonicWALL Global VPN客戶端連線出現Failed to open the IPSec driver錯誤客戶端AI
- 連線ASM例項後出現ORA-1012錯誤(三)ASM
- Win7撥號連線時出現錯誤711的解決方案Win7
- 客戶端TNSPING通 連線出現ORA-12514錯誤客戶端
- 寬頻連線錯誤651怎麼辦 寬頻連線錯誤651故障排除方法
- GetDlgItem() 出現錯誤Git
- 專案上線, 連線出錯
- win10系統寬頻連線出現“錯誤769無法連線到指定目標”如何解決Win10
- 爬蟲代理ip出現401錯誤原因是什麼?如何修復錯誤?爬蟲
- Win10系統出現Media State已斷開連線錯誤如何修復Win10
- 【mysql】關於連線mysql資料庫時出現的時區錯誤time zoneMySql資料庫
- 寬頻連線錯誤678怎麼辦? 寬頻連線錯誤678故障解決辦法
- 11g RAC ORA-12545 解決方案 +11g scan IP新特性
- 連線資料庫出錯???資料庫
- 修改scan ip
- Opencv出現detecMultiScale錯誤OpenCV
- mysql連線錯誤碼1251MySql