使用hibernate配置数据源时,oracle数据源地址使用localhost时无法启动Tomcat。而将localhost改为本机ip地址就可以了。
原因是需要修改oracle的两个配置文件。
C:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora和tnsnames.ora
修改其中的HOST值为本机的计算机名。
# listener.ora Network Configuration File: c:/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 = c:/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 20091113-1052)(PORT = 1521))
)
)