改IP後出現的tns ora-12541 問題和其他問題

伺服器改為IP,用PL/SQL登入主資料庫，出現的錯誤是：
ORA-12541: TNS:no listener

官方的解釋如下：
ORA-12541: TNS:no listener
Cause: The connection request could not be completed because the listener is not running.
Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

可是我也沒配置錯內部的引數啊，tnsname.ora也對啊。後來恍然大悟啊，趕緊看/etc/hosts，發現這裡的vip設定的ip地址有問題了。改正後順利登入主庫。

_____________________________________________________________

linux下改網路卡地址

root使用者直接用setup命令用提示改! 平時要學linux!

[@more@]