1.D:/oracle/ora81/network/ADMIN 路径下有tnsnames.ora文件, 在其中加入
类似如下代码:
OSAKALINUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.160.10.239)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
然后PL_SQL自动就会多出一个数据库,只需要登陆就可以了
同样,当java工程的数据库变化时,需要在C:/Program Files/Apache Software Foundation/Tomcat 5.5/conf路径下
修改server.xml文件,如下
<Context path="/dac" docBase="E:/0603-OSAKASHI/001-SOURCE/dac"
reloadable="true">
<Resource
name="TDK"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.160.10.239:1521:orcl" ←変更
username="osakashi_da_new" ←変更
password="da" ←変更
maxIdle="2"
maxWait="5000"
maxActive="4" />
</Context>