Because of the work required, the data needs to be imported to the Oracle database on the remote server through the local Oracle client. A lot of Oracle clients from CSDN are in Lite, missing imp.exe files, which makes it impossible to import data. So we finally downloaded Oracle Client Standard version from Oracle website, the standard version of Oracle client size is about 570Mb, address; http://www.oracle.com/technetwork/database/ Enterprise-edition/downloads/112010-win64soft-094461.html
1. Pressurized files, installing the Oracle Client
Open the installation package, locate Setup.ext, and start the installation. Error, the exact reason and resolution is the same as installing the Oracle server-side approach. Just to modify one more file, add the same content in two files. Specific Reference blog: http://blog.csdn.net/qq_26442553/article/details/79597153
I. The above error message after the modification is completed, re-setup.ext, the following interface select "Administrator" mode
II. Press and hold shift on the following screen to select all Chinese and English
Iii. D Disk new OracleClient folder, select the folder to install the base directory
Iv. Next, wait for the check to complete, click Finish, and start the installation.
V. Start the installation and wait for the installation to complete.
As above, the Oracle client installation is complete. The Oracle client that is installed will configure some files to connect to the Oracle database.
The following is a demonstration of how to connect an Oracle database through a tool, and after the Oracle client is installed, the database cannot be directly visualized, and the client installation simply provides the operating environment and configuration information to the Operations tool.
1. Download and install Plsql Developer software, after the installation is complete
2. Before using Plsql to connect to an Oracle database, configure the Oracle client that you just installed to open the Oracle Client installation directory, as in the following directory
If the current directory does not have a Tnsnames.ora file, copy it from the sample above, or customize a Tnsnames.ora file. Open the file, add the following configuration, mainly host (the database hosts IP), service_name (the current DB instance name), and the red font custom Plsql connection instance name.
ORC1 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(Service_Name =ORCL)
)
)
3. Open the Plsql configuration to connect to the database later
Once the connection is successful, the database can be manipulated.
Oracle Client Installation and configuration