Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ To access an Oracle database using Instant Client     - Create Your Own Docker base image in two ways (Linux)

- Android Fragment everything you need to know (Programming)

- Installation Android IDE development tools, Android Studio 1.5 under Ubuntu (Linux)

- Linux environment variable settings methods and differences (Linux)

- Linux system firewall defense network attacks (Linux)

- CentOS 6.x systems installation + NIC driver installation (Realtek PCIe GBE Family Controller for Linux) (Linux)

- To install PostgreSQL 9.4 (Database)

- RHEL 6.5 x86_64 CentOS yum configuration source (Linux)

- Ubuntu 15.04 using the Eclipse 4.4, Java 8 and WTP (Linux)

- Linux character device - a simple character device model (Linux)

- Running the open-source Swift under Linux platform (Linux)

- How LUKS encrypted disk / partition to perform remote incremental backup (Linux)

- systemd Power Management (Linux)

- MySQL 5.6 use GTIDs build the master database (Database)

- Linux Mint under tty.js Installation Guide (Linux)

- MySQL high availability cluster fragmentation of deployment uses Fabric (Database)

- Creating and extracting archives 11 tar command examples in Linux (Linux)

- Use nice, cpulimit and cgroups limit cpu usage (Linux)

- MBR partitions under Linux (Linux)

- Five useful commands to manage file types and system time in linux (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:      
 
- Caffe + Ubuntu 14.04 64bit + CUDA 6.5 configuration instructions (Linux)
- Docker build private warehouse (Server)
- How to install with JSON support in Ubuntu 15.04 SQLite 3.9.1 (Database)
- Linux Shell introduces (Linux)
- How to use awk command in Linux (Linux)
- Spring Integration ehcache annotation implement the query cache and cache update or delete instant (Programming)
- Go build the locale under Windows (Linux)
- How to Set Free SSH password on CentOS / RHEL (Linux)
- Oracle database NUMBER (x, y) data types (Database)
- Oracle bug Ora-04043 (Database)
- Linux Monitoring Command (Linux)
- AngularJS application unit testing started (Programming)
- Oracle 11g new features and associated SQL TUNING (Database)
- How Ubuntu Snappy Core 2 running on Raspberry Pi (Linux)
- Oracle 11g new features of the collection of multi-column statistics (Database)
- Memcached source installation and configuration under CentOS 6.6 (Server)
- There are three ways to run a Linux operating system from a USB stick (Linux)
- CentOS system dual network card IP information configuration (Linux)
- Linux network security probing tools Hping2 (Linux)
- ORA-01157 & ORA-01110 Troubleshooting (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.