使用Toad 連 oracle 8.17 會跳掉!

edited 十月 2013 in 資料庫
S1:為架設 Oracle 8.17 Server
S2:Client 上有安裝 Toad 9.6 for oracle

當在 S2 上執行 Toad時,可以正常連線,只要按瀏覽資料表時,軟體就會自動跳掉,其在安裝 S2時系統上是有安裝 oracle 9.2 database 其tnsnames.ora 設定如下

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORA817.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora.test.com.tw)
)
)

INST1_HTTP.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ora.test.com.tw)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

TWOWIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

WENG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora.test.com.tw)
)
)

YUDA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora.test.com.tw)
)



原始討論: http://twpug.net/x/modules/newbb/viewtopic.php?topic_id=4229
Sign In or Register to comment.