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数据库用户创建和授权 将字符串拼接成SQL语句和直接执行SQL语句的区别 OCI批处理的问题 【数据库设计】-文章内容-不同的用户角色在前台查看的内容是不同的-【设计思路】-分不同的角色保存不同的内容-能行吗? 一个父子关系的问题?! 哪里找Linux版的11.1.0.7的Patch?OTN上没有。 求大牛解析下:数据差异原因 删除sequence语句怎么写? 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连接试试看!