最近在电脑上装了虚拟机，为的是在虚拟机上安装Oracle数据库，Oracle实在太占内存，配置低的电脑装个Oracle几乎就瘫了，没办法，搞个虚拟机玩玩。我虚拟机用的是xp系统，顺便怀念下经典。装好Oracle之后，虚拟机使用pl/sql developer可以连接，但是物理机Java连接却始终报一个错误：
### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection), mergedContextConfiguration = [MergedContextConfiguration@578f7a8 testClass = UserTest, locations = '{classpath*:/META-INF/spring/spring-*.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]], class dirties context [false], class mode [null], method dirties context [false].
网上搜罗各种解决办法，终于解决了。话不多说：
1：cmd命令行输入hostname查看主机名并记录主机名，如UAFDHGJK；
2：cmd命令行输入ipconfig查看IP地址，如192.168.0.123；
3：修改C:\WINDOWS\system32\drivers\etc目录下hosts文件，在hosts文件最后一行添加 192.168.0.123 UAFDHGJK
4：修改Oracle安装目录D:\oracle\softwarelocation\NETWORK\ADMIN下的监听文件listener.ora
# listener.ora Network Configuration File: D:\oracle\softwarelocation\network\admin\listener.ora
# Generated by Oracle configuration tools. SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\softwarelocation)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\softwarelocation\bin\oraclr11.dll")
)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 这里改为主机名)(PORT = 1521))
)
) ADR_BASE_LISTENER = D:\oracle\basemenu
5：修改Oracle安装目录D:\oracle\softwarelocation\NETWORK\ADMIN下的监听文件tnsnames.ora
# tnsnames.ora Network Configuration File: D:\oracle\softwarelocation\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 这里改为主机名)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
) LISTENER_ORACLE =
(ADDRESS = (PROTOCOL = TCP)(HOST = 这里改为主机名)(PORT = 1521)) ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
6：重启tnslsnr。打开cmd输入命令：
lsnrctl stop
lsnrctl start
lsnrctl stat
7：cmd输入命令：
lsnrctl stat
查看Oracle监听数据已经改为配置的IP地址啦！
此时就可以通过正常Java连接数据库的方式连接虚拟机Oracle数据库了。