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

In the process of Oracle maintenance, if we happen not to be in the computer room or the location does not have Oracle database management tools, we use the computer around us to make a remote connection to check the relevant information. Next, the editor will share for you to query and manipulate the database by using the command line method that comes with the system without database management tools.

Introduction to the experiment

Install the oracle client on the Windows system and connect to the oracle database remotely

Experimental environment

Oracle database IP address: 192.168.66.129

Remote connection port: 1521

Oracle client package

Link: https://pan.baidu.com/s/19WYlVn58azmGaNooSr7x1w

Extraction code: 53v7

Experimental procedure

1. First of all, you need to go to the oracle official website to download the software package required by the client.

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

two。 Drag the downloaded package to the win7 virtual machine to extract it

Since there is no decompression software in the virtual machine, you need to install the decompression tool first.

After the decompression tool is installed, extract the two packages of oracle. First extract the basic package, and then extract the toolkit. The two packages will save in the same file.

3. Move the extracted file instantclient_18_3 to disk C and find the decompressed oracle toolkit sqlplus.exe, which is not only a tool but also a command. In order to facilitate the windows system to recognize this command, it is necessary to add environment variables.

4. Copy the path to the sqlplus tool and add it to the environment variable (right-click this computer > Properties)

5. After the environment variables are added, when the sqlplus tool is opened, the following situation occurs, indicating that the tool cannot be used because of the lack of file support in the windows system. Therefore, it is necessary to install this file support (that is, the environment where C++ is installed)

6. After installation, open the sqlplus tool again, and the login user name will be displayed, but there is no address and port to connect to the oracle database.

7. Start monitoring and starting the database

[oracle@oracle ~] $lsnrctl start / / start monitoring

LSNRCTL for Linux: Version 12.2.0.1.0-Production on October-October-2018 14:34:47

Copyright (c) 1991, 2016, Oracle. All rights reserved.

TNS-01106: listeners with the name LISTENER have been started

[oracle@oracle ~] $sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wednesday 10 October 14:35:11 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connect to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

SQL > startup / / start the database

ORA-01081: unable to start ORACLE that is already running-please turn it off first

8. Use cmd to connect to the database remotely. The command format is: sqlplus user / password @ / / ip: Port / instance

In order to solve the problem of garbled code, we need to add utf8 (Chinese character set) to the environment variable.

9. Connect to the database again

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.