Some problems encountered in setting up the server-side environment remotely

Tools:

JDK, Tomcat, Eclipse, Oracle (win64_11gr2_database_1of2.zip, Winx64_12c_database_2of2.zip), Oracle Client (winnt _12c_client32.zip), SVN plugin, visual SVN server

Steps:

JDK, Tomcat, Eclipse installation is quite simple, unzip the configuration environment variables on the line, mainly stuck on the Oracle ~ ~

The following are some of the issues encountered during the Oracle installation process:

1. Uninstalling Oracle

Because the other developers have tried to install Oracle on the server, but finally failed, so the first thing I want to do is to remove it cleanly:

(1), to the control Panel for the removal of Oracle, but because there is no successful installation, I found in the process of discovery, there is no option for Oracle

(2), then go, delete C:\Program files of Oracle related content, C:\ProgramData may also have Oracle-related things, just go in and delete it

(3), delete the Oracle-related content in the registry (REGEDIT)

(4) Remove Oracle at the beginning of the site

2. Start the installation (12c)

(1), unzip the installation package to the same folder, or it will error:Oracle did not find the file Dr0ulib.sql

(2), start the installation, this online has a tutorial, I choose the server class, step together with this almost installation diagram

(3), with SYS login to create the user (sys as SYSDBA), under 12c requires the user name to be with C # #开头

(4), create the user and then assign the appropriate permissions, I assigned the Connect, resource role

(5), with SQL Developer connection, Java.exe path is:Oracle installation directory product\12.1.0, Dbhome_1\jdk\bin, and finally succeeded

(6), but I am accustomed to use navicat so continue navicat installation, because Navicat is used for 32-bit Oracle, so to install oracle32-bit client:winnt_12c_client32.zip

(7), in the process of loading also encountered a problem: the implementation of the installation program to verify the initial setup required failure , the general solution, but I did not solve the problem with this method, took a little time to solve the problem: to the service to the services of Oracle related services to stop , and then the installation can be

It is in the same directory as Oci.dll), restart Navicat effective

(9), and finally run the corresponding SQL file import related data, but there is a problem: The table space ' USER ' does not have permission to operate, and finally found a solution on the Internet

In the build SVN server also encountered a bit of a pit of the problem: the use of localhost to access the SVN repository is accessible, but if the IP is said to be unable to connect, tangled for a long time, the beginning of suspicion is not in the process of the installation of what is less, Again in their own machine was installed once, found that the configuration does not involve the IP settings and the like, but also suspected is not the port number of the problem, then did not think, thought: with localhost can be accessed, it is not the port number problem, see the configuration of Visual server, To change the network into an IP, again access or not ... Tangled, Tangled ... Suddenly, brainwave, thought will not be the port mapping problem , if the other side did not develop these ports, then I must not be able to access Ah, because the project was released before the use of 8080 port discovery is accessible, so I changed the port number of the SVN server to 8080 , with eclipse a connection, accidentally. Yes, and then I'll explain the problem to the other person at the end .

The first time to build a server environment, it takes time or quite long, make a record

There are a lot of things may not be very detailed, because this is in hindsight, what is insufficient, please leave a message below, I use timely supplement:)

　　

　　　　

Some problems encountered in setting up the server-side environment remotely