解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
来源:互联网 发布:sql 关键字书写顺序 编辑:程序博客网 时间:2024/06/05 07:36
解决方法:
打开Oracle的 listener.ora 文件:
(/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 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
)
)
------------------------------------------------------------------------------------------------------------------------------
修改后:
# 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 = /oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521)) ) )
- 解决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
- arm驱动程序——自动创建设备节点 (韦东山的视频总结及针对linux-2.6.30)
- Windows系统环境变量大全(XP/Win7/Win8)
- 初学spring3.05,一个helloworld例子
- iOS后台多任务研究
- 你每天的努力,到底值多少钱?
- 解决Oracle ORA-12505, TNS:listener does not currently know of SID given in connect
- 在MongoDB中一起使用$or和sort()时,查询性能差的一种解决方案
- opencv之highgui中createTrackbar
- java技术网站
- VisualStudio使用技巧
- 重复数据删除的算法
- Redis内存存储结构分析
- Dom4j教程
- ssh整合步骤之二(架构设计)