In fact, in an intranet, it is very simple to want to remotely connect to the Oracle database on server A at client B.1, first download the Oracle database client and Plsql software and install in B;2. Modify the Tnsnames.ora file under the installation directory of the Oracle
Sometimes it is not convenient to log on to the Linux graphical interface to install the oracle client. We can use the silent mode to install, upgrade, and delete the oracle client (instead of the OUI ). Platform: R
Sometimes it is not convenient to log on to the Linux graphical interface to install the
1. Communication between the Oracle client and the server
1. Protocol lenet Protocol
As shown in, Oracle uses the Oracle Net protocol to connect the client to the server and transmit data. OracleNet is a software layer residing on both the
Label: 1. Download the Oracle instance client. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Since the machine is 64-bit, the 64-bit version is downloaded. But later found that Plsql is 32-bit, and downloaded the 32-bit version. Two versions can exist in parallel, the green versio
First, Oracle client and server-side communication mechanism
1, oraclenet Agreement
as the following illustration shows, Oracle uses the Oracle NET protocol to achieve client-server connectivity and data delivery. Oraclenet is a software layer that resides on both the
First to complain, according to this play to spend my big half a day, all the way to the pit!My computer is Win7 64-bit.The first stepOpen the php.ini and remove the semicolon from the front of the Extension=php_oci8_12c.dll Extension=php_pdo_oci.dll.; Extension=php_ldap. dllextension=php_mbstring. dllextension=php_exif.dll as It depends on Itextension=php_mysqli. Dllextension=php_oci8_12c.dll use with Oracle Database 12c
Tags: ant article directory name add protoc Imp directory database comOracle 11g Lite Client ConfigurationOracle is typically deployed on the server, and the client needs to connect to Oracle on the server using connection tools such as PL/SQL Developer.At this point, it is often necessary to install hundreds of megabytes of
One. Sql*plus Client Tools
1. Download, URL: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html (click to open link)
2. Select the corresponding version of the operating system of the client, the window system as an example, need to download the following two compression packs
3. Down
Tags: CSDN lda hostname String Following extend change process tooReprinted from: http://blog.csdn.net/leshami/article/details/5917103The Oracle client connection to the Oracle database server looks different from the network configuration in SQL serve, except that all SQL Server runs on the Windows platform, so many configurations are integrated directly into th
To configure the ORACLE 11g green client and PLSQL environment, you can use the lite version client officially provided by ORACLE, that is, the green installation-free client. (The official versions are provided here ):Clients used in Windows 32-bit SystemsThere are many ver
This article was reproduced from: http://my.oschina.net/jang/blog/83009This approach is done by using the Oracle-provided lite client, which is a green, free-to-install client.(The official editions are available here):Clients used in Windows 32-bit systemsClients that are used in other system environmentsThere are many versions of the
1. Communication between the Oracle client and the server
1. Protocol lenet Protocol
As shown in, Oracle uses the Oracle Net protocol to connect the client to the server and transmit data. OracleNet is a software layer residing on both the
Configure Oracle 11g Green client and PLSQL environmentThis approach is done by using the Oracle-provided lite client, which is a green, free-to-install client. There are many versions of the Instant
following:
Data Source = (description = (address = (Protocol = TCP) (host = 192.168.1.34) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = ORC); User ID = admin; Password = admin;
Otherwise, an error is returned:
The connection option "Data Source" is invalid. The maximum length is 128.
Develop a. Net program that supports oracle. The standard process is to first install the Oracle
1. Download
SlaveHttp://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.htmlDownload
Instant Client package-Basic Package (Note: All files required to run OCI, occi, and JDBC-OCI applications) downloaded here is version 11.1.0.7
2. Save the Oracle client package locally:
Create a folder
Tags: mes htm prot client soft Protoc conf RIP LibraryDownload Mac Database client: Address: http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html Download these two: (Source: http://www.cnblogs.com/xiaobo-Linux/p/7821402.html) 12.12.0.1.0 version of: Unzip Instantclient package to CD ~ Create a directory Lib and then make a file connection: mkdir ~/lib
ln-s ~/instantclient_12_2/libclnts
Tags: User database Sans esc off instance ref family DMIAvailable with three Oracle clients: SQL Developer, pl Developer, Navicat Premium I. SQL Developer (Oracle's Own) Download and install SQL Developer, the connection is simply not said. : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Ii. PL/SQL Developer11 configuration Client Download PL/SQL Developer11 Chinese
Operating System: SUSE Linux Enterprise Server 11 (i586)Database Version: Oracle 10.2.0.1Database Client Version: oracle10.2.0.1Introduction: in the company's recent phase II project construction, the newly purchased PC server needs to be deployed on the oracle client to facilitate database access. We are naturally use
Http://blog.csdn.net/hongyihua/article/details/2347025
Testing ASP. when connecting to the Oracle database, the "Oracle client and networking components were not found. these components are supplied by Oracle Corporation and are part of the Oracle version 7.3.3 or later
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.