TCP.VALIDNODE_CHECKING導致TNS12533
安裝SES後,重啟搜尋伺服器,searchctl start啟動失敗,檢查發現監聽沒有起來,手工啟動監聽
localhost-> lsnrctl start
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 06-MAY-2009 16:25:37
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.domain)(PORT=1524)))
TNS-12533: TNS:illegal ADDRESS parameters
TNS-12560: TNS:protocol adapter error
TNS-00503: Illegal ADDRESS parameters
Listener failed to start. See the error message(s) above...
這個錯誤實際沒有顯示正確的資訊,開始從lisenter.ora,tnsnames.ora入手,但沒有發現錯誤.最後檢查sqlnet.ora,發現TCP引數,原來是IP地址限制的原因
localhost-> vi sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
#TCP.VALIDNODE_CHECKING = yes
SQLNET.AUTHENTICATION_SERVICES= (ALL)
NAMES.DIRECTORY_PATH= (TNSNAMES)
#TCP.INVITED_NODES= (localhost.ldomain, 127.0.0.1)
"sqlnet.ora" 11L, 302C
localhost-> lsnrctl start
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 06-MAY-2009 16:22:55
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.domain)(PORT=1524)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.domain)(PORT=1524)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.5.0 - Production
Start Date 06-MAY-2009 16:22:55
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.domain)(PORT=1524)))
The listener supports no services
The command completed successfully
修改以後,可以成功,但還是不理解,為什麼加入正確IP,還是啟動失敗,暫時先註釋了.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/175005/viewspace-594265/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Latch導致MySQL CrashMySql
- 導致IP被封的原因
- 故障分析 | replace into 導致主備不一致
- 無限遞迴導致StackOverflowError遞迴Error
- 導致InvocationTargetException的最常見原因Exception
- 【Mysql】JDB2導致磁碟io使用率高 導致mysql延遲過高MySqlDB2
- sqlnet.ora 引數tcp.validnode_checking尷尬SQLTCP
- TSM配置不好導致備份不正常,從而導致資料庫效能問題資料庫
- ANALYZE導致的阻塞問題分析
- undo truncate 導致qps下降分析
- 因事件堵塞導致頁面卡頓事件
- MySQL For Update導致全表排他鎖MySql
- oracle bug 6825287導致DX鎖等待Oracle
- 多餘索引導致explain錯誤索引AI
- 當機導致slave異常分析
- ulimit限制導致的 +++ killed by SIGKILL +++MIT
- 由drop datafile導致的oracle bugOracle
- MySQL Flush導致的等待問題MySql
- 低效sql導致DB負載很高SQL負載
- ORACLE 大小寫導致找不到索引Oracle索引
- 中止程式導致系統HANG住
- Redis使用不當導致應用卡死Redis
- Mysql 會導致索引失效的情況MySql索引
- Servlet版本衝突導致頁面404Servlet
- linux start_udev 導致VIP漂移Linuxdev
- 如何定位導致Crash的程式碼位置
- split分割槽操作導致的librarycachelock
- sql中使用函式導致cost高SQL函式
- 版本不當導致的exp出錯
- impdp時parallel=4導致的錯誤Parallel
- 導致的汽車油耗升高的原因分析
- SCHEDULER呼叫XDB程式導致效能問題
- Bitcode導致的編譯報錯編譯
- AIX下nfs故障導致oracle process hangAINFSOracle
- java由於越界導致的報錯Java
- 時區不一致導致spring應用異常Spring
- Oracle 資料庫不一致導致異常的恢復Oracle資料庫
- APA期刊文章: 強勢領導更容易導致團隊內卷?