Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ To access an Oracle database using Instant Client     - Use eCryptFS encrypt files and directories on Linux (Linux)

- Lenovo E431 notebook CentOS system is installed wireless network card driver (Linux)

- Ubuntu installation 2.10.x version of Scala (Linux)

- build Android environment on Ubuntu 12.04 (Server)

- Linux add a new hard disk (Linux)

- libnet list of functions (Programming)

- RHEL6.5 install the latest version of Vim and increase support for the Python2.7.5 (Linux)

- CentOS 6.5 install VNC-Server (Linux)

- Setting Squid successful anti-hotlinking (Linux)

- Linux common network tools: Scan routing of mtr (Linux)

- Windows Ubuntu dual system a key Ghost, grub rescue prompt solution (Linux)

- How to Install Foreman under Ubuntu (Server)

- Linux see whether there is a hacker program (Linux)

- CentOS 6.6 x64 Oracle Database 11gR2 RAC automated installation scripts (Database)

- Close common port to protect server security (Linux)

- Fast Learning Clojure (Programming)

- 12 novice Linux command must learn (Linux)

- Spring3 + SpringMVC + Hibernate4 full annotation environment configuration (Server)

- Four Methods of Self - Learning Linux (Linux)

- Ubuntu 15.04 and CentOS 7 to deploy .NET, Mono and DNX (Server)

 
         
  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:      
 
- Ubuntu 14.04 / 14.10 how to install Mate 1.10.0 (Linux)
- Upgrade to Linux Mint 16 petra Mint 17 Qiana (Linux)
- OpenStack image production in the CentOS 6.2 (Linux)
- Linux firewall to prevent external network attacks (Linux)
- Upgrade installation manual CentOS6.5 GCC4.8.2 (Linux)
- Shell scripts to copy all directories under the current directory of a certain type of file to the same directory (Linux)
- Phoenix agents use P2P WebRTC development (Programming)
- SSH mutual trust configuration (Server)
- Linux file content inspection - cat, tac, no, more, less, head, tail, od (Linux)
- Java factory pattern (Factory mode) (Programming)
- To establish a secure and reliable Linux operating system (Linux)
- Use lsof restore accidentally deleted log files or database (Linux)
- Performance Diagnosis of 60,000 milliseconds for Linux (Linux)
- Android code performance optimization tips (Programming)
- PL / SQL how to make the program every few seconds to insert a data (Database)
- Linux server data backup (Server)
- Joseph Central Java implementation (Programming)
- Make command Detailed Tutorial (Programming)
- How to publish projects to the Jcenter repository using Gradle in Android Studio (Programming)
- To install file manager Nautilus 3.12.2 under ubuntu (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.