How to install SQLPLUS (Oracle DB API) on Windows 2008

I have been searching for this topic for many hours, but could not solve this simple question.

I want to install ONLY sqlplus and oci client on my windows computer. The oracle server is working remotely. In this window, I only need client components, including sqlplus terminal.

I already did the following on my windows machine

download oracle data access components here

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

run cmd.exe as administrator and run the following command

install all c: \ oracle myhome

In the Windows Control Panel, set the following environment variables

ORACLE_HOME=C:\ORACLE
LD_LIBRARY_PATH=C:\ORACLE
LIB_PATH=c:\ORACLE
NLS_LANG=AMERICAN_AMERICA.UTF8
PATH=C:\ORACLE;C:\ORACLE\BIN

But when I run sqlplus.exe, I get an error

* * SP2-0667: sp1.msb SP2-0750: ORACLE_HOME Oracle **

, , oracle_home ... , , , .

? sqlplus ?

+5

All Articles