ORACLE 10G 10.1.1
官网下载的10g_win32_db.zip文件(server)安装完,在server上可连接。可在别的机器上安装完client后。
不能连接,错误号ORA-12170下面是server的文件(tnsnames.ora文件server client一样)#LISTENER.ORALISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)#sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)#tnsnames.ora
BRDBSVR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ABS0626.center.abeamsystems.local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
官网下载的10g_win32_db.zip文件(server)安装完,在server上可连接。可在别的机器上安装完client后。
不能连接,错误号ORA-12170下面是server的文件(tnsnames.ora文件server client一样)#LISTENER.ORALISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)#sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)#tnsnames.ora
BRDBSVR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ABS0626.center.abeamsystems.local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
解决方案 »
- 求助 oracle VARCHAR2 字段查询数字的写法
- 请问下,我创建一个触发器后删除不了啦,一删除pl/sql就未响应,其他的能删除,这是怎么回事??请帮帮忙
- 视图如何转化为sql 可以查看吗
- 大侠们来给新手点帮助
- 请问.data文件 是那种数据库文件
- 紧急招聘顶尖互联网公司DBA系列职位-TK China soft headhunting
- 小弟跪求!想导出oracle中一个表的部分列,请高手们帮忙啊
- 只有一个数据文件能恢复吗?
- 一个典型的关于ORACLE数据库中大小写的问题。
- oracle登陆异常
- {笨猫(*)进,新开贴,分累加}求一sql语句.@@@@@@@@@@。。。。高人进呀!!!
- oracle 导入问题,急等!
有什么反应?
如果超时,估计就是网络问题了