没配置好吧~
协议是 TCP~参考一下配置后的 tnsname.ora 文件~
...\Oracle\Ora81\network\ADMIN\tnsname.ora
---------------------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORANET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OraData)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
协议是 TCP~参考一下配置后的 tnsname.ora 文件~
...\Oracle\Ora81\network\ADMIN\tnsname.ora
---------------------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORANET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OraData)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
PROTOCOL 协议,一般用 TCP
HOST 主机名,可以写主机名或IP 地址方式,指127.0.0.1 本机
PORT 端口, 默认是 1521...对不对