Configuration of connection between Oracle client and server

1. D:/Oracle/ora81/Network/admin path contains the tnsnames. ora file. Add

Code similar to the following:

Osakalinux =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.160.10.239) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

 

Then pl_ SQL automatically generates an additional database, and you only need to log on to it.

Similarly, when the database of the Java project changes, it must be in the C:/program files/Apache Software Foundation/tomcat 5.5/conf path

Modify the server. xml file as follows:

<Context Path = "/DAC" docbase = "E:/0603-450kashi/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" more
Username = "osakashi_da_new" ←
Password = "da" has been updated
Maxidle = "2"
Maxwait = "5000"
Maxactive = "4"/>
</Context>