Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ To access an Oracle database using Instant Client     - STL in the list of erase () method (Programming)

- High-performance JavaScript loops and flow control (Programming)

- Oracle RMAN repair logical bad blocks (Database)

- Usage of sudo (Linux)

- LVM management parameters commonly used commands explained in detail (Linux)

- CentOS 6.5 using Virtualenv under development environment to build Python3 (Linux)

- How Linux Log Analysis (Linux)

- Safety testing Unix and Linux server entry succinctly (Linux)

- ORA-00845: MEMORY_TARGET not supported on this system Problem (Database)

- Mount and unloading disks under Linux (Linux)

- Usage Linux device tree (Programming)

- Python virtual environment: Virtualenv (Linux)

- Oracle table space is too large processing time (Database)

- Oracle Enterprise Linux 64-bit install apache-tomcat-7.0.53 step (Server)

- SQLite (Database)

- Specifies the open ports of the SUSE firewall settings (Linux)

- To install the mail client terminal Evolution 3.13.2 under Ubuntu 14.04 (Linux)

- Linux common commands MEMO (Linux)

- Getting Started with Linux system to learn: how to check memory usage of Linux (Linux)

- Network Security Basics Linux command (Linux)

 
         
  To access an Oracle database using Instant Client
     
  Add Date : 2017-01-08      
         
       
         
  Operating System: Win8.1 Enterprise

Oracle Development Tools: PL / SQL Developer 7.0.1.1066 (MBCS)

step

Download InstantClient

Oracle's official website http://www.oracle.com/cn/downloads/index.html navigation in Downloads There Oracle Instant Client download.

Download compressed package extract to a directory, extract the article in C: \ Oracle directory.

Create tnsnames.ora File

Created in the previous step in the C: \ Oracle directory created tnsnames.ora file:

orcl =
(DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.100) (PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = orcl)
  )
)

Configuration environment variable

Environment variable name Value Purpose
TNS_ADMIN C: \ Oracle Oracle database to tell the location of the tnsnames.ora connection drive
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK database according to their actual configuration

TNS_ADMIN NLS_LANG environment variables and registry configuration can be used instead of months to see the official FAQ.

Path environment variable

In order for the program to automatically find these InstantClient library file, it is recommended to InstantClient directory (this article is C: \ Oracle) was added to the system Path environment variable. If you need to use ODP.NET and is not hosted version (ODP.NET Managed Driver without installing any Oracle client), it is necessary to do so. Another point to best use ODP.NET download Oracle Data Access Components (ODAC), which contains InstantClient and ODP.NET, which can ensure their maximum extent compatible version.

Configuring PL / SQL Developer

Tools-> Preferences-> Oracle-> Connection:

Oracle Home = C: \ Oracle

OCI Library = C: \ Oracle \ oci.dll

If you add InstantClient directory in the system Path environment variable, then this step is not necessary, PL / SQL will automatically load oci according to environment variables.

Try to connect

Configured, using a database account password test the connection.
     
         
       
         
  More:      
 
- Nginx version information hidden or modified (Server)
- Flow control message transmission between RAC (Database)
- The traffic monitoring system: cacti (Linux)
- The correct method to modify the maximum number of concurrent connections Tomcat 7 (Server)
- Linux iptables: Composition Rules (Linux)
- Java collections series (Programming)
- LAN in Ubuntu shared folders to Windows (Linux)
- Linux Oracle environment variable is invalid Problem Solving (Database)
- To compile and install OpenCV-2.3.1 FFmpeg-2.1.2 under CentOS (Linux)
- 10 example of the detection memory usage free Linux commands (Linux)
- Java Set and List in the relationship and difference (Programming)
- Linux Man Page Installation (Linux)
- Detailed use Zabbix monitoring Nginx (Server)
- How LUKS encrypted disk / partition to perform remote incremental backup (Linux)
- Oracle View index and use indexes Precautions (Database)
- java.net.NoRouteToHostException of Hadoop problem: no route to host (Server)
- See Linux kernel, CPU, memory, and various versions of the command module and means (Linux)
- DRBD switchover (Server)
- C language programming entry - Common operators (Programming)
- Linux Network Security Tips Share (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.