解决windows系统的oracle数据库不能启动ora-00119和ora-00130的问题
SQL>startup
报错ora-00119
ora-00130
出现上述错误应该是数据库的监听文件出了问题，修改listener.ora文件：
# listener.ora Network Configuration File:
D:\app\WCWEN\product\11.2.0\client_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WCWEN-PC)(PORT = 1521))
)
ADR_BASE_LISTENER = D:\app\WCWEN\product\11.2.0\client_2\log
将红色部分改成服务器的IP地址。
同时也需要修改数据库的NET服务名tnsnames.ora文件：
# tnsnames.ora Network Configuration File: D:\app\WCWEN\product\11.2.0\client_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LJV7HQSFUBEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wcwen-pc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
INUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wcwen-pc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
将上面红色部分也改成服务器的IP地址，重启数据库，即可。
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
