在listener.ora里设置了
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1525))
)
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /oracle/product/10.2.0)
(GLOBAL_DBNAME = orcl2)
)
)在tnsnames.ora里设置了:
orcl2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1525))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = orcl2)
)
)在sqlnet.ora里设置了:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
没有设置NAMES.DEFAULT_DOMAIN现在问题是:
conn hr/password@hostname:1525/orcl2 可以连接
conn hr/password@orcl2 不能连接
conn hr/password@orcl(安装时系统自动安装的服务) 可以连接为什么第二项不能连接?望达人指点。
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1525))
)
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /oracle/product/10.2.0)
(GLOBAL_DBNAME = orcl2)
)
)在tnsnames.ora里设置了:
orcl2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1525))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = orcl2)
)
)在sqlnet.ora里设置了:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
没有设置NAMES.DEFAULT_DOMAIN现在问题是:
conn hr/password@hostname:1525/orcl2 可以连接
conn hr/password@orcl2 不能连接
conn hr/password@orcl(安装时系统自动安装的服务) 可以连接为什么第二项不能连接?望达人指点。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货