You can use PL/SQLDeveloper to connect to a remote database without installing the Oracle client on the local machine.

Source: Internet
Author: User
1. The project uses the oracle11g database and installs a client to access the server. Go to oracle official download: www.oracle.compolicyglobalcnsoftwaretechociinstantclienthtdocswinsoft.html

1, the project uses oracle11g database, install a client access server. to oracle official download: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html (Chinese) http://www.oracle.com/technology/software/tech/oci/instantclient/

1. The project uses the oracle11g database and installs a client to access the server.


Download from oracle:
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html)
Bytes


Below is what I have found. Copy it to the webpage and download it.


Http://download.oracle.com/otn/nt/instantclient/111070/instantclient-sqlplus-win32-11.1.0.7.0.zip


Three compressed files downloaded


OracleDBinstantclient-basic-win32-11.1.0.7.0.zip this is the core package


Instantclient-jdbc-win32-11.1.0.7.0.zip contains JDBC Driver package


The simplest SQLPLUS package for instantclient-sqlplus-win32-11.1.0.7.0.zip



I decompress the file to drive D: \ OracleClient.


The final file structure should be as follows:





2. configure tnsnames. ora. If oracle is not installed on the local machine, copy one (tnsnames. the ora file is under % ORACLE_HOME % \ network \ admin) in the Directory D: \ OracleClient above. The content of tnsnames. ora is:



# Tnsnames. ora Network Configuration File: C: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora


# Generated by Oracle configuration tools.


ORCL =


(DESCRIPTION =


(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.20.128) (PORT = 1521 ))


(CONNECT_DATA =


(SERVER = DEDICATED)


(SERVICE_NAME = orcl)


)


)


3. Add an environment variable named TNS_ADMIN. The value is the path of the tnsnames. ora file (for example, D: \ OracleClient) to locate tnsnames. ora. If ORACLE is installed on the local machine and the ORACLE_HOME environment variable is set, the tnsnames. ora file is automatically located in % ORACLE_HOME %/network/admin.



4. Set the ORACLE language and add the registry key: "NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK", which is located in HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE. If ORACLE is not installed on the local machine, there is no "ORACLE" in H_L_M \ SOFTWARE \. You need to manually create it, and then create the key NLS_LANG under ORACLE. The key value is: SIMPLIFIED CHINESE_CHINA.ZHS16GBK




5. download and install the PL. SQL. Developer configuration application.
Configure tools> preferences> connection




Find the parameter on the left of the equal sign and enter the content on the right of the equal sign


Oracle Home (empty is autodetect) = D: \ OracleClient


OCI library (empty is autodetect) = D: \ OracleClient \ oci. dll


□Check connection box √



6. If you enable plsql again, the orcl option is available in the database. you can log on to the database by entering the user name and password.

============================================

Oracle clients are not installed on the local machine. PL/SQL Developer is used to connect to a remote database.

Category: Computer Basics 5393 people read comments (2) collect reports

Oracle Database network tool text editing Platform

Oracle clients are not installed on the local machine, and PL/SQL Developer and Instant Client toolkit are used to connect to the oracle 11g remote database.

1. Download the Instant Client from the Oracle Website:

Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Select different Instant Client versions based on your operating system

The download will be a compressed file. The decompressed folder is D:/instantclient_11_2. Put it in your favorite directory. Example: D:/instantclient_11_2

2. Create a New Directory network under the D:/instantclient_11_2 directory, create the admin directory under the network directory, and create the file tnsnames. ora under the admin directory. Use the text editor to open and write the following content:

MWDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = MWDB)
)
)

The first yellow block indicates the local host name of the remote server.

Second yellow block: IP address of the remote database

Third yellow child block: Remote database instance name

3. Add an environment variable named TNS_ADMIN. The value is the path of the tnsnames. ora file. For example, my local machine is D:/instantclient_11_2/network/admin.

4. Set the ORACLE language and add the environment variable NLS_LANG. The value is AMERICAN_AMERICA.US7ASCII.

This value can be connected to a remote database and obtained through the following SQL statement query:

Select userenv('Language')From dual;

If this value is set incorrectly, the data displayed after PL/SQL Developer connects to the database is garbled.

5. download and install the PL. SQL. Developer configuration application
Configure tools> preferences> connection

Oracle Home
D:/instantclient_11_2

OCI library

D:/instantclient_11_2/oci. dll

PL/SQL Developer in Chinese is

Tool --> preferences --> connection

Oracle main directory

D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci. dll

6. Disable PL/SQL Developer and restart Developer.

The host name appears in the PL/SQL Developer list. Enter the user name and password to log on to the remote oracle 11g database.

Supplemented Instant Client description

Oracle Instant client is a simple client provided by oracle and supports multiple platforms. It can be downloaded from the oracle website.
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Includes the following content:
Instant client Package-Basic run all files required by OCI, OCCI, and JDBC-OCI applications.

Instant client Package-Basic Lite: only contains English error messages. Only unicode, ascii, and western European character sets are supported.

Instant client Package-JDBC Supplement adds xa, internationalization, and RowSet operations for jdbc.

Instant Client Package-SQL * Plus contains sqlplus and required library files

Instant client Package-SDK use Instant Client to develop header files and example makefiles required by Oracle Applications

Instant client package-databases required for ODBC usage, not all platforms. linux platforms include.

Either Basic or Basic Lite is required. Other packages are optional. I downloaded Basic, JDBC supplement, SQL * Plus, SDK, ODBC. decompress the package and put it in a folder. in this folder, create the tnsnames file. ora, set the environment variables LD_LIBRARY_PATH and TNS_ADMIN to point to the decompressed directory, you can use sqlplus.

I downloaded the instant client Version 10.2.0.2.0 and tested the connection to oracle 9.2.0.4 and oracle 10.2.0.1.

Instant Client does not contain tools such as tnsping, exp/imp, rman, and netca. If you need these tools, you must install the oracle client.

========================================================== =====

Install the Oracle Instant Client ODBC driver

17:38:47

Oracle ODBC driver Installation Steps

, Author information and this statement. Otherwise, legal liability will be held. Http://kazake.blog.51cto.com/2155462/1336633

The Oracle driver has been asked several times recently. Some people install the Oracle client to obtain the Oracle driver. This method is too troublesome, installation time is too long, and installation is prone to errors, cleaning up garbage after an error is troublesome.
We recommend that you use a lightweight green program such as Oracle Instant Client to install the Oracle Client. You can download various versions from the official website.

Let's use the 64-bit 11g version as an example:

First, go to the official website to download the Oracle Instant Client.

Http://www.oracle.com/technetwork/topics/winx64soft-089540.html


Download the first package instantclient-basic-windows.x64

And ODBC packet instantclient-odbc-windows.x64

Decompress the two packages. Note that all the files extracted from the two packages must be placed in the same directory. Assume that the files are D: \ software \ oracle-instantclient \ instantclient_11_2. Then open the window and enter this directory to run odbc_install.exe.


After the installation is successful, run the 64-bit ODBC driver configuration program "C: \ windows \ system32 \ odbcad32.exe"

Here we can see the Oracle driver.


In fact, there are other packages in the Oracle Instant Client download interface on the official website. The Instant Client can not only install ODBC, but also install JDBC and configure the listening connection server (sqlplus, toad, plsql), back up the database, import and export data.

Since toad and pl/SQL are both 32-bit programs, If we configure toad and pl/SQL to connect to the database server in a 64-bit operating system, you must configure a 32-bit ODBC driver in a 64-bit operating system.
In this case, the 32-bit Instant Client is downloaded, And the configuration method is the same as that of 64-bit.
Note that the 32-bit ODBC driver configuration program is in "C: \ Windows \ SysWOW64 \ odbcad32.exe"

Refer to this blog post:

Http://kazake.blog.51cto.com/2155462/1336622

Note that \ NETWORK \ ADMIN \ tnsnames. ora must be placed in the following directory after the instantclient is decompressed, and the structure cannot be changed.

If the TNS Service Name field is garbled in the drop-down box, enter it manually.

Related Article

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.