D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = spark)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
ORA254 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server-name)(PORT = 1521))
)
(CONNECT_DATA =
(SID = Test)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORA254为新增加的主机配置信息:
打开sqlplus 输入:
CONNECT SYS@ORA254 AS SYSDBA
密码:***
连接成功。
诊断:使用tnsping命令。 cmd ->
$ tnsping ora254
output:
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-9月 -
2011 14:03:43
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
D:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = server-PC)(PORT = 1521))) (CONNECT_DATA = (SID = Test)))
OK (20 毫秒