Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ To access an Oracle database using Instant Client     - Linux system security configuration (Linux)

- Oracle10g 64-bit installation solution in Windows 2008 Server R2 (Database)

- A script to make your Ubuntu 14.04 Memory screen brightness (Linux)

- HA-Federation-HDFS + Yarn cluster deployment (Server)

- Java polymorphism and exception handling (Programming)

- Basic Java JNI (Programming)

- Using FTPClient to upload and download files in Java (Programming)

- CentOS 6.6 install rsync server (Server)

- CentOS 7 virt-manager can not connect a local hypervisor (Linux)

- OpenDaylight Helium version installed (Linux)

- To install HDRMerge 0.4.3 under ubuntu (Linux)

- How to set up HTTPS policies for older browsers (Server)

- Ubuntu 14.04 install Sublime Text 3 plug and use SublimeClang (Linux)

- Struts2 study notes -Valuestack (value stack) and OGNL expression (Programming)

- Ubuntu and derivative system users how to install Pinta 1.5 (Linux)

- Android using SVG vector graphics to create cool animation effects (Programming)

- Linux operating system security tools of the Logs (Linux)

- Linux kernel netpoll framework netconsole (Linux)

- MongoDB in bulk timestamp change the date format (Database)

- VMware virtual machine can not start VMnet0 no Internet access and other issues (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 server security configuration (Server)
- Django url () function Detailed (Programming)
- CentOS6 5 Configure SSH password Free (Linux)
- Use Tails 1.4 Linux system to protect the privacy and anonymity (Linux)
- Ubuntu users how to install the latest Nvidia graphics drivers (Linux)
- The Concept and Semantics of Java Memory Model (Programming)
- Linux POST fstab configuration file read-only variable can not be modified problem (Linux)
- Improve WordPress performance (Server)
- Nagios (centreon) monitoring LVS (Server)
- MySQL rollback insert statement causes ibd file grows double (Database)
- Linux some lessons learned about network security (Linux)
- Binary search and modification (Programming)
- Oracle ORA-01089 failure analysis (Database)
- Adjust the size of the hard disk VirtualBox (Linux)
- Commonly used Linux system camouflage method (Linux)
- C ++ why we chose to use the smart pointer (Programming)
- DB2 manually create a library (Database)
- Three strategies to teach you to release the device memory (Linux)
- Add local search to your Android app (Programming)
- Linux security settings Basics (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.