How clients access the Oracle 12c 64-bit database

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.