用sql developer的时候提示listener does not currently know of SID
来源:互联网 发布:流程优化的方法和应用 编辑:程序博客网 时间:2024/06/05 04:40
提示错误为
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
你的tnsnames.ora怎么配置的?肯定是你sqldeveloper里的SID名,不是按照你的tnsnames.ora配置的。
例:tnsnames.ora的内容如下:
vis-dalian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.161.***)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VIS)
)
)
你的sql developer里的配置应该是:
选择SID的时候,配成:VIS,而不是vis-dalian.
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
弄了一晚还是不行,但用sqlplus能用,我只有100分解决了就全给了!!
tnsnames.ora中,sid配置的与服务器监听不符。
贴出tnsnames.ora的内容和服务器监听文件的内容,或者列出sid内容。
你的tnsnames.ora怎么配置的?肯定是你sqldeveloper里的SID名,不是按照你的tnsnames.ora配置的。
例:tnsnames.ora的内容如下:
vis-dalian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.161.***)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VIS)
)
)
你的sql developer里的配置应该是:
选择SID的时候,配成:VIS,而不是vis-dalian.
0 0
- 用sql developer的时候提示listener does not currently know of SID
- 关于Oracle的ORA 12505错误 ORA-12505, TNS:listener does not currently know of SID given in connect descrip
- kettle入门(一) 之kettle连接oracle rac 报listener does not currently know of sid错误的解决
- Oracle ORA-12505 TNS:listener does not currently know of SID given in connect descriptor 的解决办法
- navicat 连接 oracle 的时出现:ORA-12505, TNS:listener does not currently know of SID given in connect descr
- oraclejdbc连接数据库的问题ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- ORA-12505, TNS:listener does not currently know of SID given in connect desc
- Oracle中"listener does not currently know of SID given in connect descriptor"
- Oracle中"listener does not currently know of SID given in connect descriptor"
- listener does not currently know of SID given in connect descriptor
- TNS:listener does not currently know of SID given in connect descriptor 解决
- Oracle中"listener does not currently know of SID given in connect descriptor"
- ORACLE :listener does not currently know of SID given in connect descriptor
- ORA-12505 TNS:listener does not currently know of SID given in connect descriptor
- 解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
- ORA-12505, TNS:listener does not currently know of SID given in connect desc
- 解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
- 解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
- MySQL5.6 如何优化慢查询的SQL语句 -- SQL优化
- Lighttpd 配置fastcgi
- 智能电网学习3---论文7section1-3
- JSP技术已死 ? (Java Server Page technology will die) ?
- R播放音频
- 用sql developer的时候提示listener does not currently know of SID
- FFMPEG avformat_write_header changing my stream time_base
- Linux ,*.zip、*.tar、*.tar.gz、*.tar.bz2、*.tar.xz、*.jar、*.7z 压缩与解压
- <css 三>font
- 龙芯电脑—编译 resiprocate-1.10.0.tar.gz
- (OK) CentOS7—用本地光盘(ISO文件)制作yum源
- 每天学点JQuery(1)—选择器
- 【Maven】使用入门
- ProcessMaker Installation—MySQL-MariaDB—Apache—PHP