Shulou(Shulou.com)06/01 Report--

Because of the need for work, the data needs to be imported into the oracle database on the remote server through the local oracle client. A lot of oracle clients have been downloaded from csdn, all of which belong to the simplified version, and the lack of imp.exe files makes it impossible to import data. So finally downloaded the oracle client standard version from the oracle official website, the standard version of the oracle client size 570Mb, address; http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

1. Pressurized files, installing oracle client

Open the installation package, locate setup.ext, and begin the installation. The specific reason and solution for the error is the same as installing the oracle server. Just modify one more file and add the same content to both files. Refer to blog: https://www.jb51.net/article/170103.htm

i. After the above error message has been modified, re-setup.ext, and select "administrator" mode in the following interface.

ii. Press and hold shift on the following interface, select all Chinese and English

Create a new oracleclient folder for iii.D disk, and select this folder as the installation base directory

iv. Next, wait for the check to complete, click finish to start the installation.

v. Start the installation and wait for the installation to complete.

As above, the oracle client has been installed. The installed oracle client needs to configure some files before it can connect to the oracle database.

The following begins to demonstrate how to connect to the oracle database through the tool. After installing the oracle client, the database cannot be operated directly and visually. The installation of the client only provides the operating tool with working environment and configuration information.

1. Download and install plsql developer software, after the installation is complete

two。 Before using plsql to connect to the oracle database, configure the oracle client you just installed and open the oracle client installation directory as follows

If there is no tnsnames.ora file in the current directory, make a copy from the sample above, or customize a tnsnames.ora file. Open the file and add the following configuration, mainly host (host ip where the database resides), service_name (current database instance name), and the instance name of the plsql connection with a custom red font.

Orc1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)

3. Connect to the database after opening the plsql configuration

After a successful connection, you can operate the database.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.