将tnsnames.ora文件配置改成这个试试呢:
ODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qskj)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = odb.jzqskj.com)
)
)_____________________________________________________________________在sqlplus中连接格式一定要写成这样:
SQL>conn username@odb
ODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qskj)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = odb.jzqskj.com)
)
)_____________________________________________________________________在sqlplus中连接格式一定要写成这样:
SQL>conn username@odb
你改net manager并保存后看看tnsnames.ora配置文件是否更改成功.
客户机装一个Oracle 客户端 没有别的了!
将tnsnames.ora文件配置改成这样:
ODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qskj)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = odb)
)
)
ODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = odb.jzqskj.com)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名或IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 实例名)
)
)