解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
来源:互联网 发布:vb编程题及答案 编辑:程序博客网 时间:2024/06/05 10:56
解决方法:
打开Oracle的 listener.ora 文件:
(oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora)
修改前:
# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
LISTENER =
------------------------------------------------------------------------------------------------------------------------------
修改后:
# listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = suse10.site)(PORT = 1521)) ) )
上面的红色文字是增加的内容。 (ORCL -- 是你的SID 数据库名)
重启Oracle的监听器。
问题解决。
其实我都不敢相信可以解决 可是确实解决了问题 心中狂喜,不要犹豫,改吧!!!
- 解决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
- 解决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
- 解决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
- Oracle - 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
- Oracle - 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
- 解决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
- 解决‘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 descriptor
- Oracle出错:ORA-12505, TNS:listener does not currently know of SID given in connect desc
- ORA-12505, TNS:listener does not currently know of SID given in connect desc
- 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
- android:shape的使用
- 浅析android UI 定制
- 2.2、线性表的顺序表示和实现
- 四十、类别 和 协议(四)协议
- Kinect 深度测量原理
- 解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
- 四十一、类别 和 协议(五)非正式协议
- linux mdadm raid
- 四十二、类别 和 协议(六)合成物件
- 球的运算
- 四十三、基础框架(一)关于 基础框架
- 伤感日志发布:如果一切重来。我会更加珍惜
- Android 对Path的旋转效果的拓展
- JAVA中反射机制的研究