ORA-12514: TNS:listener does not currently know of service requested in connect
# tnsnames.ora Network Configuration File:XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# tnsnames.ora Network Configuration File:XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
解决方案 »
- 我是大四学生,考研估计失败,想专攻数据库方向,南京哪里OCP培训不错?
- 求 Oracle+11g权威指南(第2版)下载地址
- pl/sql里不能写select * ,'aa' from 表吗?
- Oracle中VarChar2字段的长度问题
- 在线等!!!请问如何把ORACLE81或更高版本的客户端打进自己的安装程序?
- 实例,服务,数据库?
- 学习 oracle (9i的)吗?这里有视频教学
- 数据导入问题
- 新手,菜鸟级别的新手,求各位指教,万分感激
- Oracle sql server 连接局域网内的一个oracle数据库怎么连
- oracle存储过程
- Oracle select..into 变量。变量没有值!
http://blog.csdn.net/inthirties/archive/2009/08/17/4450927.aspx
打开命令行:
输入: lsnrctl stop
->> lsnrctl start
->> lsnrctl status