[Oracle Client 12C (32 bit) Installation on Windows 7 (64 bit)]

In this document we will describe installation process for Oracle Database Client on Windows 7 (64 bit).

To correct anything, please write mail to:

Oracle Clietn need for remote connection from desktop to database with programms like SQLPLUS, PL/SQL Developer, TOAD, SQL Navigator and maty other.

Oracle client for Windows you could download from Oracle website.

For installation we need only winnt_12102_client32.zip

With 64 bit client, not works programms like PL/SQL Developer. That is the reason why we will setup 32 bit client

Prepare environment

Before we need to install additional library. This library needed only when you install 32 bit client.

https://www.microsoft.com/en-gb/download/details.aspx?id=5555

hosts

Edit file hosts:

C:\WINDOWS\system32\drivers\etc\hosts

127.0.0.1   	localhost
192.168.1.11	oracle12.localdomain oracle12

Oracle Client 12C (32 bit) Installation on Windows 7 (64 bit)

Oracle Client Installation

We need only Oracle Call Interface library (OCL). But for convenient i will install next:

SQL Plus
Oracle Call Interface (OCI)
Connection Manager

Creating from master tnsnames.ora file:

Connection parameter you could see on database server in tnsnames.ora file

Result should be like

ORCL12 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl12.localdomain)
    )
  )

Check

C:\> tnsping oracl12

system - login
manager - password

C:\>sqlplus /nolog
SQL> conn system/[email protected]

Edit Oracle Enviromnet Variables in windows reestr

I replace AMERICAN_AMERICA.WE8MSWIN1252 on AMERICAN_AMERICA.AL32UTF8