安装的软件是:win32_11gR2_OracleXE,系统是64位的,win7,安装oracle的时候是默认安装的。
tnsping 都能通。
废话不多说了,直接上几个文件的内容:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without th

在Windows 7 64位系统上安装了win32_11gR2_OracleXE,遇到Oracle数据库监听器问题,表现为ORA-12514错误。尽管tnsping可以正常通信,但启动时仍然出现错误。经过一系列尝试,最终成功解决了这个问题。
最低0.47元/天 解锁文章
1万+

被折叠的 条评论
为什么被折叠?



