更新下面两个文件夹中的
D:appshisanproduct11.2.0client_1 etworkadmin
D:ORACLEproduct11.2.0dbhome_1NETWORKADMIN
Tnsnames.ora文件后添加如下代码
#数据库
orcllqp =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.30.72)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcllqp)
)
)
10.98.30.72既是IP
Db.property中 lqp.driverClassName=oracle.jdbc.driver.OracleDriver lqp.url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.30.72)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.30.72)(PORT = 1521)) )(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcllqp))) lqp.username=lqp lqp.password=XXXXXXXXX lqp.initialSize=2 lqp.maxActive=160