oracle客户端问题!~高手救救我吧!~ 检查一下你填写的数据库sid是否正确. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 cmd中tnsping 连接名看能不能连通 首先服务器端要配置好监听,其次在客户端需要正确配置tnsnames.ora文件,格式如:ORA_DEV= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 服务器IP地址)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = 服务器实例名) ) ) 在客户端用[Net Manager]配置一个服务命名 tnsnames.ora文件如下:TEST_XTJCSERVER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xtjcserver)(PORT = 1521)) ) (CONNECT_DATA = (SID = test) (SERVER = DEDICATED) ) )test为数据库名,xtjcserver为主机名 constring="user id=system;data source=test_xtjcserver;password=sa";连接不通constring="user id=system;data source="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xtjcserver)(PORT=1521)))(CONNECT_DATA=(SID=test)(SERVER=DEDICATED)))";password=sa";时就通了,但是对数据库操作时,提示超出长度范围 tnsping 连接名如果不同肯定不行,你的客户端用[Net Manager]配置一下 连接名是什么?Net Manager已经配了! TEST_XTJCSERVER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xtjcserver)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) ) 关注!等待Oracle高手的出现。 tnsnames.ora文件如下:连接字符串(自己定义)= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =数据库所在计算机IP地址)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =oracle数据库实例名) ) )你先用sql*plus连接试试看! 求一oracle正则表达式 临时表空间文件太大,导致无法备份数据库,怎么办 oracle 批量更新问题 一个LDAP的问题,网上有提问,无回答 急!如何在数据库中换行! 请教:Oracle ORA-24331 缓冲区过小的问题 懂Oracle的进来看看。。。 推荐几本oracle的经典书吧 请问:worksheet和sqlplus都可以执行sql语句,请问它们各自的优点,不同点 asp连接oracle的问题,急…… 请问:哪儿有比较好的oracle学习资料下载? 请教:关于安装oracle9i的问题
tnsping 连接名
看能不能连通
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 服务器IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务器实例名)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xtjcserver)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = DEDICATED)
)
)test为数据库名,xtjcserver为主机名
constring="user id=system;data source="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xtjcserver)(PORT=1521)))(CONNECT_DATA=(SID=test)(SERVER=DEDICATED)))";password=sa";时就通了,但是对数据库操作时,提示超出长度范围
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xtjcserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =数据库所在计算机IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =oracle数据库实例名)
)
)
你先用sql*plus连接试试看!