Tomcat Setup Oracle Datasource

1. Change configuration files

a. C:\TomcatTrans\conf\server.xml

i. Change the GlobalNamingResources\Resource: Resource name / url / connectionCacheName

ii. Change the Service\Connector: address

b. C:\TomcatTrans\conf\web.xml

i. change the web-app\resource-ref: res-ref-name

c. C:\TomcatTrans\conf\context.xml

i. Change the Context\ResourceLink: global

d. All the application in webapps need to change

Example:

i. find thor.properties files

ii. Change the dataSourceName

2. Change the java property of Tomcat

3. Run script in database: ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

4. Disable the firewall of application server and database serve

5. Copy msvcr71.dll from java’s bin directory to tomcat’s bin folder.

6. Check the tomcat version to define 32 or 64. Use the attachment tool PESnoop.exe

command: PESnoop tomcat6.exe /pe_dh

Tomcat 8 needs at least JRE 7

Tomcat 7 needs at least JRE 6

Devops Engineer