How clients access the Oracle 12c 64-bit database

Server A installs the Oracle 12c 64-bit database, and Machine B accesses the Oracle database.

Get ready:

1. Download Instantclient-basic-nt-12.1.0.2.0.zip,:http://pan.baidu.com/s/1c04lzso

2. Download Plsql,:http://pan.baidu.com/s/1bnhkdoj

Installation steps

1. Installing the Orcle Client

Unzip the downloaded instantclient-basic-nt-12.1.0.2.0.zip to the directory of the non-Chinese path in machine B, assuming the path is extracted

D:\tools\Application Develop\oracle\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1

2. Configure the data source file

Create a new file in the above path in machine B Network\admin\tnsnames.ora

The content of Tnsnames.ora is the content of the configuration Tnsnames.ora for the data source in Server A.

Address of Tnsnames.ora in Server A: C:\app\Administrator\product\12.1.0\dbhome_2\NETWORK\ADMIN\tnsnames.ora

3. Add Environment variables

Right-click "My Computer"-"Properties"-"advanced"-"Environment variables"-"System environment variables" in machine B

3.1 Select "Path"-click "Edit" to "D:\tools\Application develop\oracle\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1;" Join

3.2 Click New, the variable name is set to "Tns_admin", and the variable value is set to "D:\tools\Application develop\oracle\instantclient-basic-nt-12.1.0.2.0\ instantclient_12_1; ", click" OK ";

4. Install Plsql, set up Oracle home and OCI Library

Install Plsql to the non-Chinese directory in machine B. Open Plsql Click Cancel Login, enter the Plsql interface, set the Oracle home and OCI Library in "preferences" of "tools" or "preferences" of English "tools"

Oracle home:d:\tools\application Develop\oracle\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1

OCI library:d:\tools\application Develop\oracle\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1\oci.dll

How clients access the Oracle 12c 64-bit database