2.說明:
Client端無法登入到遠端Server時,就會出現該狀況。
3.可能原因:
Server有開放OS認證模式,已知在Windows機器上,容易導致client端抄寫失敗。
4.解決:
(1)登入到抄寫的Server(也就是提供資料的Oracle 10g機器)上的Windows作業系統。
(2)編輯「%Oracle_HOME%\product\10.1.0\db_1\NETWORK\ADMIN\sqlnet.ora」檔案,做如下方框內的修正:
# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. #SQLNET.AUTHENTICATION_SERVICES = (NTS) --> 註解這一行,取消OS認證! NAMES.DIRECTORY_PATH= (TNSNAMES) |
(3)修改完成後存檔離開。離開後,可以再試試看DB抄寫,應該要能正常運作!