Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ To access an Oracle database using Instant Client     - 10 really interesting Linux command (Linux)

- To configure and use multiple Tomcat under Linux environment (Server)

- How to Install Telegram instant messaging software on Ubuntu (Linux)

- Share useful bash aliases and functions (Linux)

- Enable Intel Rapid Start in GNU / Linux (Linux)

- The SVN installation, configuration and start - up under Linux (CentOS 6.5) (Server)

- Some practical tips Linux (Linux)

- How to make GRub instead of the default Ubuntu software center (Linux)

- Physical backup and recovery SYSTEM table space (Database)

- Wine 1.7 is installed on a system based on RedHat or Debian (Linux)

- Monitoring Linux System 7 command-line tool (Linux)

- Gentoo: existing preserved libs problem solving (Linux)

- Ubuntu 15.04 installation Powercommands 2.0 (Linux)

- How to use OpenVPN and PrivacyIDEA build two-factor authentication for remote access (Server)

- Docker knowledge base (Server)

- Linux simple commands (Linux)

- Oracle Shared Server Configuration (Database)

- Install Open vSwitch under CentOS 6.5 (Linux)

- Ubuntu Locale configuration problem solving Can not set LC_CTYPE (Linux)

- The Java ThreadLocal (Programming)

 
         
  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:      
 
- Preview function to confirm the stop resource Oracle 12c new feature crsctl (Database)
- CentOS install Redis (Database)
- Linux mount command Detailed (Linux)
- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)
- Linux account management add relevant directives (Linux)
- Tsunami-udp accelerated network transmission (Linux)
- FreeRadius installation process record (Linux)
- Linux process stack and process function stack frame (Linux)
- Difference Redhat5 and 6 YUM source configuration (Linux)
- MySQL binary packages install for RedHat Linux Enterprise 6.4 (Database)
- Debugging with GDB tool Go (Programming)
- Oracle ORA-01089 failure analysis (Database)
- Build RubyMine + Ruby On Rails + MySQL development environment under Windows (Server)
- Linux bash: scp: command not found the problem (Linux)
- Command filter MySQL slow query log (Database)
- Troubleshooting Linux virtual machine device id and the letter of inconsistencies (Linux)
- grep command Detailed and relevant examples (Linux)
- Apache POI Excel Document Processing (Linux)
- Using Python multithreaded mistakes summary (Programming)
- How to configure a development environment elegant Lua (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.