Solving ORA-12545 when connecting with SHARED SERVER mode－DanBrother的部落格

Solving ORA-12545 when connecting with SHARED SERVER mode

當Client 與 Server 的網段不相同時
(e.g. Client IP: 192.168.1.111 ;
           Server IP: 192.168.2.155)

tnsnames.ora 設定為:

test_svr1 =
(DESCRIPTION =
     (ADDRESS_LIST=
         (ADDRESS = (PROTOCOL=TCP)(HOST = 192.168.2.155)(PORT=1234))
    )
   (CONNECT_DATA =
     (SEREVER = SHARED)
    (SERVICE_NAME = test_svr1)
  )
)

c:\> tnsping test_svr1   沒問題
然而
sqlplus /nolog
connect scott/tiger@test_svr1

就會出現   ORA-12545 的錯誤訊息

這個問題的主要原因是出在HOST無法獲得解析的問題,
透過 c:\windows\system32\drivers\etc\hosts 這個檔的設定,問題就可以解決

<< Solution>>
Step 1:
在hosts檔案加上
192.168.2.155    my_host

Step2:
修改tnsnames.ora 檔 (** 將ip改成hostname)

test_svr1 =
(DESCRIPTION =
     (ADDRESS_LIST=
         (ADDRESS = (PROTOCOL=TCP)(HOST = my_host)(PORT=1234))
    )
   (CONNECT_DATA =
     (SEREVER = SHARED)
    (SERVICE_NAME = test_svr1)
  )
)