Oracle + Tomcat + Java build a test environment

I thought this environment was easy to build, but it took an afternoon to put the system on the shelf. The problems encountered were recorded, which is also the biggest achievement of today!

1. the developer is a newbie and may not have dealt with the testing department before. The source code is the file for the cmme, not the compiled file, and the war file package is not generated for the Java project. Directly put it under Tomcat -- webapp, and it cannot run at all. The format is discuz.zip. Ask the developer to give a war package again. It took almost half an hour.

 

2. the developer's Oracle Data is 9i, And the tester is 10 Gb. Fortunately, it is compatible. In the past, our environment was 9i. The last time I installed a 10 Gb package, I finally didn't have to worry about version compatibility. It is easy to import the database, because I tried to import the database once last time. I thought it was a success, but there was also a small problem:

Create a user and grant the following permissions:

SQL> create user distest identified by distest;

SQL> grant DBA to distest;

Import database:

SQL> imp distest/distest fromuser = distest touser = distest file = c: \ distest. dmp. (x)

Oracle prompts an error. The IMP command is not recognized. I thought it was a permission issue. I ran the 302 pilot again, but it was still this error. I did not have the patience to read the error prompt. I should check the problem clearly and analyze it carefully. The problem was found because the import command should be in the DOS environment:

C: \> imp distest/distest fromuser = distest touser = distest file = c: \ distest. DMP, instead of SQL>.

 

3, data import is successful, the thought only needs to in Tomcat-> webapp-> discuz-> WEB-INF-> class modify connection data file is enough, but still problems, since the username I created is distest and the developer username is discuz, the developer also reads the table from the discuz Shema during programming. When the environment is set up, the application cannot read discuz, an HTTP 500 error is reported, indicating that the file cannot be found, but the user name must be consistent with the developer's user name.

This is because I only know the reason for the database, but do not know how the program connects to the data and how to query the table for development. The third problem was solved by the developer. I deeply understand that testers should also understand the importance of internal programming.

 

Today, I also found a problem. Since I used RMAN in Oracle 408, I always reported an error. The statement for connecting to RMAN is as follows:

C: \> RMAN target sys/testing @ wyy nocatalog; (the semicolon should not exist)

An error still occurred after the connection. After analysis, a semicolon was added. The correct statement is as follows:

C: \> RMAN target sys/testing @ wyy nocatalog

 

Summary: The series of problems that have emerged today are all their negligence and carelessness, with no attention to details. I have performed the above operations n times by myself, but problems still occur, which proves that I am not careful enough,

Although it was finally solved, the efficiency was not high.

Remember: The details are really important.