新建oracle连接远程服务

更新下面两个文件夹中的

D:\app\shisan\product\11.2.0\client_1\network\admin

D:\ORACLE\product\11.2.0\dbhome_1\NETWORK\ADMIN

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